Skip to Content

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

Information
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.

Archiving SQL Viewer data

Error
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.

After you have collected the SQL statements, you can delete the data that has been collected from the SQL Viewer tables and save it in flat files for later viewing in a text editor. The data is deleted from the current SQL Viewer tables, leaving them empty for another collection.

Warning

Note

The SQL Viewer must be stopped before you can archive the data.

To archive the SQL statements, choose Archive Data from the SQLVIEWER menu. You can change the directory where the files are created, and then click Accept to delete the information from the database tables and save to the flat files.

The following files are created:

  • psql.dat, which contains the statistics about the SQL statements
  • psqltest.dat, which contains the text of the SQL statements

The data is deleted from the tables. You can now open the file and view the SQL information in a text editor.

 

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

BMC PATROL for Oracle Database Monitoring 9.7