Home » SQL & PL/SQL » SQL & PL/SQL » autotrace problem in oracle9i
icon7.gif  autotrace problem in oracle9i [message #226271] Fri, 23 March 2007 02:29 Go to next message
sudharshan
Messages: 48
Registered: November 2006
Member
SQL> set autotrace on stat;
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

Re: autotrace problem in oracle9i [message #226272 is a reply to message #226271] Fri, 23 March 2007 02:32 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
sudharshan wrote on Fri, 23 March 2007 08:29
SQL> set autotrace on stat;
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
And? Have you checked the role?

MHE

[Updated on: Fri, 23 March 2007 02:33]

Report message to a moderator

Re: autotrace problem in oracle9i [message #226274 is a reply to message #226271] Fri, 23 March 2007 02:36 Go to previous messageGo to next message
sudharshan
Messages: 48
Registered: November 2006
Member
Check PLUSTRACE role is enabled


how do we enbale this?
Re: autotrace problem in oracle9i [message #226281 is a reply to message #226274] Fri, 23 March 2007 02:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google google


I got 387 hits on Check PLUSTRACE role is enabled
Re: autotrace problem in oracle9i [message #226382 is a reply to message #226281] Fri, 23 March 2007 08:04 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I would hate to have seen this reply if there were a million hits.
Re: autotrace problem in oracle9i [message #226391 is a reply to message #226382] Fri, 23 March 2007 08:45 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
lol. Admit it. You counted them (ok, calculated, but nevertheless..)
Re: autotrace problem in oracle9i [message #226428 is a reply to message #226391] Fri, 23 March 2007 12:11 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I have no shame in admitting I multiplied 19 by 20 and added 7.
Previous Topic: New to Oracle
Next Topic: search varchar2 feild and get numbers from it???
Goto Forum:
  


Current Time: Sun Dec 04 14:34:52 CST 2016

Total time taken to generate the page: 0.23371 seconds