Message-Id: <10647.119109@fatcity.com> From: "Koivu, Lisa" Date: Thu, 12 Oct 2000 16:35:26 -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_01C0348B.F4496C88 Content-Type: text/plain; charset="iso-8859-1" Ajay, grant ALTER SESSION to the user who needs to trace. That should do it. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "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 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_01C0348B.F4496C88 Content-Type: text/html; charset="iso-8859-1"

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

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

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

"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

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