| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
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
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_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
"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_at_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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>Hi Ajay/Lisa,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000> You also need to run =
plustrce.sql=20
from sys/internal login.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>(Note the exact name of script is plustrce =
and not=20
plustrace.sql)</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>This will create a role called =20
plustrace . Later you should</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>grant the role to the user who wants to =
enable=20
autotrace.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000> The script can be found =
in=20
$ORACLE_HOME/sqlplus/admin</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>HTH,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D436533807-14102000>Rajesh</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Koivu, =
Lisa<BR><B>Sent:</B>=20
Friday, October 13, 2000 1:31 AM<BR><B>To:</B> Multiple recipients of =
list=20
ORACLE-L<BR><B>Subject:</B> RE: Autotrace on <BR><BR></DIV></FONT>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D890532320-12102000>Ajay, grant ALTER SESSION to the user who =
needs to=20
trace. That should do it.</SPAN></FONT></DIV>
<P><B><FONT face=3DArial size=3D1>Lisa Rutland Koivu</FONT></B> =
<BR><FONT=20
face=3DArial size=3D1>Oracle Database Administrator</FONT> <BR><FONT =
face=3DArial=20
size=3D1>Qode.com</FONT> <BR><FONT face=3DArial size=3D1>4850 North =
State Road=20
7</FONT> <BR><FONT face=3DArial size=3D1>Suite G104</FONT> <BR><FONT =
face=3DArial=20
size=3D1>Fort Lauderdale, FL 33319</FONT> </P>
<P><FONT face=3DArial size=3D1>V: 954.484.3191, x174</FONT> <BR><FONT =
face=3DArial=20
size=3D1>F: 954.484.2933 </FONT><BR><FONT face=3DArial size=3D1>C:=20
954.658.5849</FONT> <BR><FONT face=3DArial size=3D1><A =
href=3D"http://www.qode.com/"=20
target=3D_blank>http://www.qode.com</A></FONT> </P>
<P><I><FONT color=3D#000000 face=3DArial size=3D1>"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."</FONT></I></P>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Ajay K=20 [mailto:ajay_at_tems.com]<BR><B>Sent:</B> Thursday, October 12, 2000 = 4:40=20
PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
Autotrace on <BR><BR></DIV></FONT>
<DIV><FONT face=3DArial size=3D2>Hi DBAs ,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>While trying to set autorace on I =
am getting=20
the message :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> SP2-0618: =
Cannot find the=20
Session Identifier. Check PLUSTRACE role is=20
enabled<BR> SP2-0611: Error enabling STATISTICS=20
report</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>but if i try to connect as system =
I am able to=20
explain plan. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>what should be the =
reason.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>thanks in advance </FONT></DIV> Received on Sat Oct 14 2000 - 02:44:01 CDT
 |
 |