Re: Error running autotrace
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-lReceived on Thu Nov 27 2008 - 10:10:26 CST