Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> tracing an sql session?
As per
http://www.oracle.com/technology/oramag/oracle/04-jan/o14tech_perf.html
I run this tracing example.
As an admin user I have not problem, but in my application account I get a "ORA-01031: insufficient privileges" on line 4 ("set events...").
What do I need to change so that I can execute this command?
alter session set timed_statistics=true; alter session set max_dump_file_size=unlimited; alter session set tracefile_identifier='Hello'; alter session set events '10046 trace name context forever, level 12'; select 'Howdy, it is '||sysdate from dual; exit;
Many TIA!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Tue Jan 16 2007 - 00:29:22 CST
![]() |
![]() |