Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> tracing an sql session?

tracing an sql session?

From: Mark Harrison <mh_at_pixar.com>
Date: Tue, 16 Jan 2007 06:29:22 GMT
Message-ID: <6h_qh.1491$O02.567@newssvr11.news.prodigy.net>


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 Studios
Received on Tue Jan 16 2007 - 00:29:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US