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
>
> --
> Mark Harrison
> Pixar Animation Studios
To "alter session set events..." you need to log into the database with
an account that has DBA privileges.
Received on Tue Jan 16 2007 - 04:58:55 CST
