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

Report message to a moderator

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: 7065
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?

Report message to a moderator

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: 7901
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

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I would hate to have seen this reply if there were a million hits.

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
lol. Admit it. You counted them (ok, calculated, but nevertheless..)

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I have no shame in admitting I multiplied 19 by 20 and added 7.

Report message to a moderator

Previous Topic: New to Oracle
Next Topic: search varchar2 feild and get numbers from it???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 01:31:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.