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.

Monitoring SQL statements

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.

From PATROL for Oracle, you can use the following functions to obtain information about SQL commands used in Oracle processes:

  • SQL Snapshot displays the last SQL statement sent by a client process. You can use SQL Snapshot to examine the SQL statements being currently executed by a problem process.
  • SQL Viewer captures all SQL statements that are sent in the instance during a time interval. You can use SQL Viewer to examine all SQL statements in a polling cycle to find trends or continuous problems.

 

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

BMC PATROL for Oracle Database Monitoring 9.7