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.

 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