OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » SQL TRACE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL TRACE [message #139401]

Tue, 27 September 2005 19:13

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

Hi,

I am trying to enable sql trace for my session.

I have the alter session privs

I issue

ALTER SESSION SET SQL_TRACE=TRUE;

I get an error: ORA-01031-Insufficient privs

Please specify why do i get this.

Thanks

Nitin

Report message to a moderator

Re: SQL TRACE [message #139448 is a reply to message #139401]

Wed, 28 September 2005 01:35

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Are you sure this user has sufficient privileges ,

I tried on my machine, see this

Code: [Select all] [Show/ hide]

 SQL> create user newbie identified by newbie;

User created.

SQL> grant create session to newbie;

Grant succeeded.

SQL> conn newbie/newbie;
Connected.

SQL> alter session set sql_trace=true;
ERROR:
ORA-01031: insufficient privileges

SQL> show user 
USER is "SYS"

SQL> grant connect,resource to newbie;

Grant succeeded.

SQL> conn newbie/newbie
Connected.

SQL> show user
USER is "NEWBIE"

SQL> alter session set sql_trace=true;

Session altered.

SQL> alter session set sql_trace=false;

Session altered.

not able to replicate your problem with sufficient privileges.

regards,
tarun

Report message to a moderator

Re: SQL TRACE [message #139594 is a reply to message #139401]

Wed, 28 September 2005 14:39

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

Thanks Tarun. Probably the user did not have resource privelege in my case.

Thanks,
Nitin

Report message to a moderator

Previous Topic:	RAC: "global cache cr request" events take 1 second ocasionally
Next Topic:	Statspack

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 11:39:33 CDT 2025