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