Re: Problem with Autotrace - Is this a BUG ?

Are you actually getting the statistics back when you run a sql statement now?

Normaly one had to run $ORACLE_HOME/sqlplus/admin/plustrce.sql to get a role named PLUSTRACE, which should have been granted to users doing sql tracing with statistics.

The role has only following privs:

grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$session to plustrace;

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, July 28, 2003 8:54 AM

> In continuation of my previous mail :
>
> just now i upgraded the cleint to 9.2.0.3 ,
> and tried it once again. IT WORKS !!!!
>
> i simply wonder why ?!!!!!!!!!
> is this a bug in 9.2.0.2 ?*!#$#&*
>
> Thanks and Regards,
> Jp.
>
> 28-07-2003 12:49:24, Prem Khanna J <jprem_at_kssnet.co.jp> wrote:
>
> >Guys,
> >
> >SET AUTOTRACE works fine on the Database server machine.
> >the database server ENV is 9.2.0.3/Win2k AS - With SP3.
> >
> >SQL>connect cti/cti;
> >SQL>set autot trace
> >SQL>
> >
> >whereas when i try the same from a different machine,i get the error
below.
> >{ this client machine has 9.2.0.2/Win2K server - with SP3 }
> >
> >SQL>connect cti/cti_at_mf;
> >SQL>set autot trace
> >SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
enabled
> >SP2-0611: Error enabling STATISTICS report
> >
> >.seems to be unusual.isn't it ?
> >had anyone faced the same problem ?
> >can someone help me out.
> >
> >Regards,
> >Jp.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).