Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Announcement Support for this product will end on December 22, 2025. To monitor Oracle databases, we recommend that you use PATROL for Oracle Enterprise Database.

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


 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


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*