Re: Problem with Autotrace - Is this a BUG ?

2003-07-29 Thread Prem Khanna J
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

Re: Problem with Autotrace ?

2003-07-28 Thread Quamrul Polash
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

RE: Problem with Autotrace ?

2003-07-28 Thread Sarnowski, Chris
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

Re: Problem with Autotrace ?

2003-07-28 Thread bulbultyagi
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

Re: Problem with Autotrace - Is this a BUG ?

2003-07-28 Thread Tanel Poder
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

Re: Problem with Autotrace - Is this a BUG ?

2003-07-28 Thread Prem Khanna J
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

Re: Problem with Autotrace - Is this a BUG ?

2003-07-28 Thread Tanel Poder
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