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
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
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 ?
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 don't know much about Oracle,
Is there a spelling mistake in the command you gave ?
SQL set autot trace
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 09:19
Guys,
when i try the same from a different machine,i get the
To: Multiple recipients of list ORACLE-L
Subject: Re: Problem with Autotrace ?
I don't know much about Oracle,
Is there a spelling mistake in the command you gave ?
SQL set autot trace
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday
Hi,
Read the metalink article Note:116091.1 which may solve your problem.
/Quamrul
From: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Problem with Autotrace ?
Date: Mon, 28 Jul 2003 13:14:23 -0800
I don