Oracle DBMS_PROFILER package requires several tables which are not installed by default. Oracle admin directory contains 3 scripts DBMSPBP.SQL, PROFTAB.SQL, and PRVTPDB.PLB for creating and setting up these tables Please check that you have these tables. If not run PROFLOAD.SQL wich will rebuild the profiler package and tables. Also make sure you have ORA_MONITOR.PROFILER_DATA table that should be created by the setup. Here is the scipt that you can use for creating this table manually create table ora_monitor.profiler_data ( runid number not null primary key, run_name varchar2(100) check (rtrim(run_name) != null), start_time date default sysdate not null, user_runid number default 1 not null, run_seq integer default 1 not null, user_sid number not null, user_name varchar2(30) default user not null, run_cpu number default 0, run_io number default 0, run_memory number default 0, run_sorts number default 0, run_sort_ratio number default 0, run_gets number default 0, run_status varchar2(12) default 'INCOMPLETE', session_name varchar2(100) check (rtrim(session_name) != null), session_comments varchar2(4000), run_source long); create index ora_monitor.i_profiler_data on ora_monitor.profiler_data (user_name, session_name); GRANT SELECT, INSERT, DELETE, UPDATE ON ora_monitor.profiler_data TO PUBLIC; : I am getting an error with the install. It says DBMS_Profiler does not exist, : but it does and I am installing under SYS. : Then when I run the SQL Profiler and try to execute some code I get a Table : not found Oracle Error. : Regards : JD
|