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,
Read the metalink article 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't know
D]
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 5:14 PM
> 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 au
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
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
