Message-Id: <10649.119241@fatcity.com> From: Rajesh Dayal Date: Sat, 14 Oct 2000 11:44:01 +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_01C035B2.87C7CFE6 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Ajay/Lisa, =A0 =A0=A0=A0 You also need to run plustrce.sql from sys/internal login. (Note the exact name of script is plustrce and not plustrace.sql) This will create a role called=A0=A0 plustrace=A0=A0 . Later you should grant the role to the user who wants to enable autotrace. =A0 =A0=A0=A0 The script can be found in $ORACLE_HOME/sqlplus/admin =A0 HTH, =A0 Rajesh -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Koivu, = Lisa Sent: Friday, October 13, 2000 1:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: Autotrace on=20 Ajay, grant ALTER SESSION to the user who needs to trace.=A0 That = should do it. Lisa Rutland Koivu=20 Oracle Database Administrator=20 Qode.com=20 4850 North State Road 7=20 Suite G104=20 Fort Lauderdale, FL=A0 33319=20 V: 954.484.3191, x174=20 F: 954.484.2933=20 C: 954.658.5849=20 http://www.qode.com=20 "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----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=20 Hi DBAs , While trying to set autorace on I am getting the message : =A0=A0=A0 SP2-0618: Cannot find the Session Identifier.=A0 Check = PLUSTRACE role is enabled =A0=A0=A0 SP2-0611: Error enabling STATISTICS report =A0 but if i try to connect as system I am able to explain plan.=20 what should be the reason. =A0 thanks in advance=20 ajay ------ =_NextPart_001_01C035B2.87C7CFE6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi Ajay/Lisa,

You also need to run = plustrce.sql=20 from sys/internal login.

(Note the exact name of script is plustrce = and not=20 plustrace.sql)

This will create a role called =20 plustrace . Later you should

grant the role to the user who wants to = enable=20 autotrace.

The script can be found = in=20 $ORACLE_HOME/sqlplus/admin

HTH,

Rajesh

-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Koivu, = Lisa
Sent:=20 Friday, October 13, 2000 1:31 AM
To: Multiple recipients of = list=20 ORACLE-L
Subject: RE: Autotrace on

Ajay, grant ALTER SESSION to the user who = needs to=20 trace. That should do it.

Lisa Rutland Koivu =
Oracle Database Administrator
Qode.com
4850 North = State Road=20 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933
C:=20 954.658.5849
http://www.qode.com

"The information = contained herein=20 does not express the opinion or position of Qode.com and cannot be = attributed=20 to or made binding upon Qode.com."

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

Hi DBAs ,

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

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

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

what should be the = reason.

thanks in advance