PL/SQL Profiler Requirements
Required Oracle Conditions
|
To run the PL/SQL Profiler |
The DBMS_PROFILER package needs to be installed under SYS. This is does not happen by default on a new instance. |
|
To collect session statistics |
The users need access to V$SESSION, V$SESSTAT and V$STATNAME. This condition is satisfied when the users have SELECT privilege on system views V_$SESSION, V_$SESSTAT and V_$STATNAME. |
|
For schemas that use the PL/SQL Profiler |
The profiler server side objectsInstalling_server_side_objects (tables and sequences) need to be installed. |