Oracle Tips by Burleson

Oracle 10g osm_power_limit

The Database Scan Summary Report

As we said above, the scan.txt file contains the Database Scan Summary Report. Let's first look at the report header section of this report.

Time Started  : 2003-09-14 13:04:25
Time Completed: 2003-09-14 13:11:20

Process ID         Time Started       Time Completed
---------- -------------------- --------------------
         1  2003-09-14 13:05:27  2003-09-14 13:11:18
---------- -------------------- --------------------

As you can see, the header report contains information about the elapsed time for the report, the details on processes used (I only used 1 process, you can actually specify parallel processes to speed the report) and their relative elapsed time data.

The rest of the report consists of the following sub-sections:

• Database Size
   

• Database Scan Parameters
   

• Scan Summary
   

• Data Dictionary Conversion Summary
   

• Application Data Conversion Summary
   

• Application Data Conversion Summary Per Column Size Boundary
   

• Distribution of Convertible Data Per Table
   

• Distribution of Convertible Data Per Column
   

• Indexes To Be Rebuilt
   

• Truncation Due To Character Semantics

The information available for each section depends on the type of scan, the exceptions or problems encountered, and the parameters you select (for example, whether you specify the BOUNDARY parameter).

Let's examine the first sub section, the Database Size report.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm