RE: Autotrace on

From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
Date: Thu, 12 Oct 2000 19:34:09 -0400
Message-Id: <10647.119120@fatcity.com>

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.

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

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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content='"MSHTML 4.72.3612.1706"' name=GENERATOR>
<STYLE></STYLE>

</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=937541823-12102000><FONT color=#0000ff face=Arial size=2>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. 
</FONT></SPAN></DIV>
<DIV><SPAN class=937541823-12102000><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=937541823-12102000><FONT color=#0000ff face=Arial size=2>After
the script completes, grant the PLUSTRACE role to those who need to set autotrace on.</FONT></SPAN></DIV>
<DIV><SPAN class=937541823-12102000><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=937541823-12102000><FONT color=#0000ff face=Arial
size=2>Ed</FONT></SPAN></DIV>
<BLOCKQUOTE>

    <DIV class=OutlookMessageHeader><FONT face="Times New Roman"     size=2>-----Original Message-----<BR><B>From:</B> Ajay K     [mailto:ajay_at_tems.com]<BR><B>Sent:</B> Thursday, October 12, 2000 4:40     PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>     Autotrace on <BR><BR></FONT></DIV>
    <DIV><FONT face=Arial size=2>Hi DBAs ,</FONT></DIV>     <DIV><FONT face=Arial size=2>While trying to set autorace on I am getting     the message :</FONT></DIV>
    <DIV><FONT face=Arial size=2>    SP2-0618: Cannot find the     Session Identifier.  Check PLUSTRACE role is     enabled<BR>    SP2-0611: Error enabling STATISTICS     report</FONT></DIV>
    <DIV><FONT face=Arial size=2></FONT> </DIV>     <DIV><FONT face=Arial size=2>but if i try to connect as system I am able to     explain plan. </FONT></DIV>

    <DIV><FONT face=Arial size=2>what should be the reason.</FONT></DIV>
    <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
    <DIV><FONT face=Arial size=2>thanks in advance </FONT></DIV>
    <DIV><FONT face=Arial size=2>ajay</FONT></DIV></BLOCKQUOTE></BODY></HTML>

Received on Thu Oct 12 2000 - 18:34:09 CDT