Re: tracing an sql session?

Mark Harrison wrote:
> 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

conn / as sysdba

grant ALTER SESSION to <schema>;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org