Page History

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

...

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

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

...

1. Execute:

   Code Block
   create view appd4db_groups as select * from x$kglrd;

...

...

1. Execute:

   Code Block
   grant select on appd4db_groups to appd4db;

   where appd4db is the monitoring user.

...

1. Execute:

create synonym appd4db.appd4db_groups for sys.appd4db_groups;

where appd4db is the monitoring user.