Re: Error running autotrace

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 27 Nov 2008 17:10:26 +0100
Message-ID: <486b2b610811270810n5d2af19au3aee0cca41fc4850@mail.gmail.com>


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_at_opitz-consulting.ch
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA


On Thu, Nov 27, 2008 at 5:04 PM, Dennis Williams < oracledba.williams_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 27 2008 - 10:10:26 CST

Original text of this message