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 | |
SQL Viewer tables
The SQL Viewer utility captures SQL statements submitted to the Oracle server. SQL statements are captured at certain intervals that you set by specifying the scheduling of the CollSqlViewer parameter in the COLLECTORS application. The SQL Viewer stores information about the activities that occur on an SQL statement and the statistics related to the statement.
SQL Viewer captures information in the following tables:
- P$SQL
- P$SQL_TEXT
You can access reports about SQL statements through the SQLVIEWER menu. You can also access the tables through SQL*Plus or Server Manager to create your own reports.
P$SQL table
The P$SQL table stores history and trend information about each SQL statement. The information includes the date that the SQL was first loaded. If a SQL statement is executed more than once by the same Oracle user, that statement is listed in the P$SQL table only once. However, SQL Viewer keeps track of the total number of times that the SQL is reloaded, invalidated, parsed, and executed and provides history and trend information.
The table is always appended; values are not updated. The table is emptied during the archive and truncate process.
P$SQL_TEXT table
The P$SQL_TEXT table collects the text of each unique SQL statement. The SQL is readable text, and the number of text characters that the table can store is unlimited.