Before running PL/SQL Profiler for the first time, several tables and indexes have to be created in schema that will collect profiling data. To create them, run the script from file prof_install.sql located in the \Install sub-directory of SQL Navigator home directory (C:\Program Files\Quest Software\SQL Navigator 5.5\Install).
To run the PL/SQL Profiler, the following conditions must be met:
1. the 'DBMS_PROFILER' package needs to be installed under SYS. This is does not happen by default on a new instance.
2. To collect session statistics, the users need access to V$SESSION, V$SESSTAT and V$STATNAME. That means they have to have SELECT privilege on system views V_$SESSION, V_$SESSTAT and V_$STATNAME.