ORA-06528: Error executing PL/SQL profiler
Cause: An error occurred in during execution of a PL/SQL profiler procedure.
Action: Check the stacked errors for more details.
ORA-06528表示执行PL/SQL profiler时出现报错。
1.确保具有必要的权限以正确执行Profiler:
a.检查是否具有EXECUTE PUBLIC profiler权限:SELECT * FROM session_privs WHERE privilege = ‘EXECUTE PUBLIC profiler’;
b.为使用者分配一个TEMP表空间,以模拟PL/SQL Profiler运行环境:ALTER USER username DEFAULT TABLESPACE temp;
2.确保有足够的内存资源可供PL/SQL Profiler使用:
a.确定用于PL/SQL Profiler的默认内存池大小:SELECT name, value FROM v$parameter WHERE name = ‘pga_aggregate_target’;
b.增加内存池大小:ALTER SYSTEM SET pga_aggregate_target = ” Increased size in bytes” SCOPE=SPFILE;
3.使用PL/SQL Profiler的”Start/Stop”(STA/STO)命令来检查其运行状态:
a.检查PL/SQL Profiler是否已经启动:SELECT * FROM v$session WHERE type = ‘profiler’;
b.如果PL/SQL Profiler尚未启动,请用该命令启动它:EXEC DBMS_PROFILER.START_PROFILER(‘profname’);
c.启动PL/SQL Profiler之后,请用该命令在完成任务后停止它:EXEC DBMS_PROFILER.STOP_PROFILER;