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