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 |
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.
- Choose Reports > Database > Schema Table Info from the INSTANCE menu.
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 reportItem
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.
- 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
- 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.
- Choose Reports > Database > Rollback Segments from the INSTANCE menu.
Select a rollback segment or select ALL SEGMENTS, and click Accept.
The following table shows the information that the report provides.
Rollback Segments reportItem
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.
- Choose Reports > Database > Statistic Summary from the INSTANCE menu.
- Select a statistic type that you want reported and click Accept:
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 reportItem
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