Re: Error running autotrace
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 P Knecht
OPITZ CONSULTING Schweiz GmbH
Mobile +41-79-571 36 27
OCP 9i/10g SCSA SCNA
On Thu, Nov 27, 2008 at 5:04 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:
> 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
> 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?
> Dennis Williams