Re: Problem with Autotrace - Is this a BUG ?

Hi

Hm, but try to query sys.v_$session sys.v_$sesstat and sys.v_$statname views under cti user.
If it works, then enable event 10046 at level 4 before you set autotrace on and check trace file (maybe there are some parse errors for example)

It could be a bug, or just change in behaviour when enabling tracing. Did you actually try, that in 9.2.0.3 tracing works as expected?! Maybe in newer version just no warning is shown...

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

> Tanel,
>
> PLUSTRACE role was already granted to CTI.
>
> it's the SAME user "CTI".
> i tried it on a different machine.that's it.
>
> when i upgraded oracle client 9.2.0.2 to 9.2.0.3,
> it worked fine and i was able to get the statistics.
>
> So,is this a bug or .... ?
>
> BTW,did u get my mail regarding "Index usage" which we were discussing
earlier ?
>
> Regards,
> Jp.
>
> 28-07-2003 18:49:24, "Tanel Poder" <tanel.poder.003_at_mail.ee> wrote:
>
> >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.
>
>
>
> --
> 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).