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" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED];
> >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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
