Message-Id: <10647.119120@fatcity.com> From: Garrity Ed R Date: Thu, 12 Oct 2000 19:34:09 -0400 Subject: RE: Autotrace on This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C034A4.EC132072 Content-Type: text/plain; charset="iso-8859-1" I'm not sure if you are on NT or UNIX. On Solaris, you will find a file called plustrce.sql in $ORACLE_HOME/sqlplus/admin. Look for it in the equivalent location on NT. Check in the top portion of the script to make sure, but I believe you run it as sys. It creates the PLUSTRACE role. After the script completes, grant the PLUSTRACE role to those who need to set autotrace on. Ed -----Original Message----- From: Ajay K [mailto:ajay@tems.com] Sent: Thursday, October 12, 2000 4:40 PM To: Multiple recipients of list ORACLE-L Subject: Autotrace on Hi DBAs , While trying to set autorace on I am getting the message : SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report but if i try to connect as system I am able to explain plan. what should be the reason. thanks in advance ajay ------_=_NextPart_001_01C034A4.EC132072 Content-Type: text/html; charset="iso-8859-1"

I'm not sure if you are on NT or UNIX. On Solaris, you will find a file called plustrce.sql in $ORACLE_HOME/sqlplus/admin. Look for it in the equivalent location on NT. Check in the top portion of the script to make sure, but I believe you run it as sys. It creates the PLUSTRACE role.

After the script completes, grant the PLUSTRACE role to those who need to set autotrace on.

-----Original Message-----
From: Ajay K [mailto:ajay@tems.com]
Sent: Thursday, October 12, 2000 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Autotrace on

Hi DBAs ,

While trying to set autorace on I am getting the message :

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

but if i try to connect as system I am able to explain plan.

what should be the reason.

thanks in advance

ajay