The user is able to query the v_$ views and statistics are
explained properly.
let me enable "Event 10046" and see what happens.
Thanx Tanel.
Regards,
Jp.
28-07-2003 22:34:30, "Tanel Poder" <[EMAIL PROTECTED]> wrote:
>Hi
>Hm, but try to query sys.v_$session s
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 i
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
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
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 AUTOTRAC