Regresar
-
Título
Error using the Profiler: "SYS.DBMS_PROFILER is missing" -
Descripción
User attempted to use the Profiler and the following error occurs:
"An error occurred when connecting to database"
"SYS.DBMS_PROFILER is missing" -
Causa
DBMS_PROFILER package has not been installed on the database. -
Resolución
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.