SQL Group Management for Oracle Only

On this page:

From the Main Menu, click Setup->SQL to display the SQL Group Management window.

You can apply logical names to individual, or groups of, SQL Statements based on either their Oracle SQL_ID (Oracle 10g and above) or HashCode (Oracle 8i and 9i). This grouping is relevant to the SQL Group Report and is required for Monitor PL/SQL.

There is also an automated grouping feature which will group SQL Statements to their parent PL/SQL package on an hourly or daily schedule.

Enable automatic SQL grouping in Oracle

The steps access the Oracle x$kglrd table, which is the Oracle internal table used to provide the mapping.

Connect to the Oracle instance via sqlplus as the sysdba user.

Execute:

create view appd4db_groups as select * from x$kglrd;

Execute:
```
grant select on appd4db_groups to appd4db;
```
where appd4db is the monitoring user.
Execute:

create synonym appd4db.appd4db_groups for sys.appd4db_groups;

where appd4db is the monitoring user.