Database reports


Warning

This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.

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

Item

Description

Name

name of the parameter

Type

type of the parameter:

  • string
  • boolean
  • integer

Value

value or setting of the parameter


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
Was this page helpful? Yes No Submitting... Thank you

Comments