Database reports

Use the following reports to get information about the database files:

• Database Files
• Oracle License Limits
• Parameter File (init.ora )
• Schema Table Information

Use the following reports to get information about the functions, packages, procedures, and triggers used in the database:

• Schema Functions
• Schema Packages
• Schema Procedures
• Schema Triggers

Use the following reports for information about activity in the database:

• Rollback Segments
• Statistic Summary

Getting basic database information

Use the following reports to get database file information, the schema information, and init.ora parameter settings for the database.

Database file information

Use this report to obtain information about the data files, redo files, and control files used in the instance.

Choose Reports > Database > Database Files from the INSTANCE menu.

Viewing schema table information

The Schema Table Info report provides constraints, storage parameters, and storage allocation for the tables in a schema.

1. Choose Reports > Database > Schema Table Info from the INSTANCE menu.

2. Select a schema and click Accept. Select a table in the schema or select ALL TABLES, and click Accept.
   The following table shows the information that the report provides.
   
   Schema Table Information report

   Item	Description
   Report 1 - lists all table constraints ordered by owner and table name
   Constraint Name	name of the constraint
   Type	type of constraint
   Owner	owner of the table
   Table Name	name of the table
   Status	status of the table
   Report 2 - lists the storage parameters for all tables ordered by owner and table name
   Table Name	name of the table
   Tablespace Name	name of the tablespace that the table is in
   Init Extent	the size of the initial extent in the tablespace
   Next Extent	the size of the next extent in the tablespace
   Min Ext	minimum number of extents allowed in the segment
   Max Ext	maximum number of extents allowed in the segment
   Pct	percentage to use to increase the size of the next allocated extent
   Report 3 - lists storage allocated for all table segments ordered by owner and table name
   Table Name	name of the table
   Tablespace Name	name of the tablespace that the table is in
   Bytes	number of bytes in the table
   Extents	number of extents in the table
   Report 4 - lists table column information ordered by owner, table_name, and column_id
   Table Owner	owner of the table
   Table Name	name of the table
   Column	name of the column
   Column ID	ID of the column
   Report 5 - lists storage allocated for all segment types, except Table, ordered by owner and segment name
   Table Name	name of the table
   Segment Type	name of the segment in the table
   Tablespace Name	name of the tablespace the table is in
   Bytes	number of bytes in the tablespace
   Extents	number of extents in the tablespace

Oracle license information

The Oracle License Limits report displays the current values of the following Oracle parameters:

• license_max_sessions
• license_max_users
• license_sessions_warning

Choose Reports > Database > Oracle License Limits from the INSTANCE menu.

Oracle init.ora information

The Parameter File (init.ora ) report displays the current value of selected init.ora parameters.

Choose Reports > Database > Parameter File (init.ora) from the INSTANCE menu. Select the parameters that you want to view or select Select All Parameters, and click Accept.

The following table shows the information that the report provides.

Parameter File init.ora report

Getting function, package, procedure and trigger information

Use the following reports to get information about the functions, packages, procedures, and triggers used in the database.

1. From the INSTANCE menu, choose one of the following reports:
   • Reports > Database > Schema Function Info
   • Reports > Database > Schema Package Info
   • Reports > Database > Schema Procedure Info
   • Reports > Database > Schema Trigger Info
2. Select a schema, or select ALL SCHEMAS, and click Accept.
   The report appears in a text window. The following items are displayed on each report:
   • owner of the object
   • name of the object
   • status of the object
   • date and time that the object last executed

Getting database activity information

Use the following reports to get information about the rollback segment activity and statistic activity on the instance.

Viewing rollback segment activity information

The Rollback Segment report displays information about the rollback segments in the database.

1. Choose Reports > Database > Rollback Segments from the INSTANCE menu.

2. Select a rollback segment or select ALL SEGMENTS, and click Accept.
   The following table shows the information that the report provides.
   
   Rollback Segments report

   Item	Description
   Report 1
   Segment Name	name of the segment
   Tablespace Name	tablespace that the segment is in
   Owner	the owner of the tablespace
   Status	the status of the segment
   Bytes	the size in bytes of the segment
   Blocks	the size in blocks of the segment
   Extents	the number of extent to the segment
   Init Extents	the size of the initial extent in the tablespace
   Min Extents	minimum number of extents allowed in the segment
   Max Extents	maximum number of extents allowed in the segment
   % Inc	percentage to use to increase the size of the next allocated extent
   Report 2
   Segment Name	name of the segment
   Writes	number of writes to the segment
   Gets	number of header gets
   Waits	number of header waits
   Wraps	number of times rollback segment is wrapped
   Extends	number of times rollback segment size is extended
   Ave Shrinks	average number of times the size of a rollback segment decreased
   Ave Active	average number of active extents

Instance statistics information

The Statistic Summary report displays information about system values, system events, block contentions, and rollback segments in the database.

1. Choose Reports > Database > Statistic Summary from the INSTANCE menu.
2. Select a statistic type that you want reported and click Accept:

3. Select a class of system-wide statistics from the list of Statistics of system-wide values and click Accept.
   The following table shows the information that the report provides.
   
   Statistic Summary report

   Item	Description
   System Wide Values
   Name	name of the statistic class: User Redo Enqueue Cache OS SQL Debug
   Value	value of the statistic
   Statistics of Rollback Segments
   Rollback Segment	rollback segment number
   Status	rollback segment status
   Extents	number of extents in rollback segment
   RS Size	size in bytes of rollback segment
   Writes	number of bytes written to rollback segment
   Transactions	number of active transactions
   Gets	number of header gets
   Waits	number of header waits
   Shrinks	number of times the size of a rollback segment decreases
   Wraps	number of times that the rollback segment is wrapped
   Extends	number of times that the rollback segment size is extended
   System Events
   Event Name	name of the wait event
   Total Waits	total number of waits for this event
   Total Timeouts	total number of timeouts for this event
   Time Waited	total amount of time waited for this event, in hundredths of a second
   Average Wait	average amount of time waited for this event
   Block Contentions
   Class	class of block
   Wait Count	number of waits by this operation for this class of block
   Wait Time	sum of all wait times for all the waits by this operation for this class of block