Re: Error running autotrace
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Thu, 27 Nov 2008 17:10:26 +0100
What does a select * from session_roles return for the session you're trying
to use it in ?
Stefan
=========================
Stefan P Knecht
Senior Consultant
Systems Engineering
OPITZ CONSULTING Schweiz GmbH
Seestrasse 97
CH-8800 Thalwil
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxxxxxxxxx
http://www.opitz-consulting.ch
OCP 9i/10g SCSA SCNA
=========================
On Thu, Nov 27, 2008 at 5:04 PM, Dennis Williams <
oracledba.williams@xxxxxxxxx> wrote:
> List,
>
> I'm trying to run autotrace. The database is 10.2.0.4. On one database
> this ran fine with me doing nothing. On two other databases, I get the
> following error.
>
> SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
> enabled
> SP2-0611: Error enabling STATISTICS report
> I have read the SQLPLUS manual, and Googled online for this error.
> I have dropped and recreated the PLUSTRACE role and granted it to the
> schema where I want to run this.
> No luck.
>
> Can anyone think of what I may be overlooking?
>
> Thanks,
> Dennis Williams
>
Other related posts: