Re: Problem with Autotrace - Is this a BUG ?

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).