Re: Problem with Autotrace - Is this a BUG ?
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 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 in behaviour when enabling tracing. Did >you actually try, that in 9.2.0.3 tracing works as expected?! Maybe in newer >version just no warning is shown... >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).
Re: Problem with Autotrace ?
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 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 error below. > { this client machine has 9.2.0.2/Win2K server - with SP3 } > > SQL>connect cti/[EMAIL PROTECTED]; > SQL>set autot trace > SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled > SP2-0611: Error enabling STATISTICS report > > .seems to be unusual.isn't it ? > had anyone faced the same problem ? > can someone help me out. > > Regards, > Jp. > > > > > > > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] DIV <>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). MSN 8 with e-mail virus protection service: 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quamrul Polash 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).
RE: Problem with Autotrace ?
SQL-Plus is a little like the old interactive fiction games (text-based games, like 'Adventure' or 'Zork'). You only need to type enough of some words so that they are unambiguous. See the SQL-Plus User's Guide, "command reference" (chapter 8 for 8.1.7, chapter 13 for 9.2.0) for details. I'm afraid I don't have anything add to the original question, I was going to suggest the obvious "grant PLUSTRACE" but I reviewed the thread and saw that was already dealt with. -Chris > -Original Message- > From: [EMAIL PROTECTED] > [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 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 error below. > > { this client machine has 9.2.0.2/Win2K server - with SP3 } > > > > SQL>connect cti/[EMAIL PROTECTED]; > > SQL>set autot trace > > SP2-0618: Cannot find the Session Identifier. Check > PLUSTRACE role is > enabled > > SP2-0611: Error enabling STATISTICS report > > > > .seems to be unusual.isn't it ? > > had anyone faced the same problem ? > > can someone help me out. > > > > Regards, > > Jp. > > > LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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).
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, July 28, 2003 09:19 > Guys, > > when i try the same from a different machine,i get the error below. > { this client machine has 9.2.0.2/Win2K server - with SP3 } > > SQL>connect cti/[EMAIL PROTECTED]; > SQL>set autot trace > SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled > SP2-0611: Error enabling STATISTICS report > > .seems to be unusual.isn't it ? > had anyone faced the same problem ? > can someone help me out. > > Regards, > Jp. > > > > > > > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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).
Re: Problem with Autotrace - Is this a BUG ?
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 in behaviour when enabling tracing. Did you actually try, that in 9.2.0.3 tracing works as expected?! Maybe in newer version just no warning is shown... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 28, 2003 1:54 PM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Re: Problem with Autotrace - Is this a BUG ?
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).
Re: Problem with Autotrace - Is this a BUG ?
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. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 28, 2003 8:54 AM > 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 AUTOTRACE works fine on the Database server machine. > >the database server ENV is 9.2.0.3/Win2k AS - With SP3. > > > >SQL>connect cti/cti; > >SQL>set autot trace > >SQL> > > > >whereas when i try the same from a different machine,i get the error below. > >{ this client machine has 9.2.0.2/Win2K server - with SP3 } > > > >SQL>connect cti/[EMAIL PROTECTED]; > >SQL>set autot trace > >SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled > >SP2-0611: Error enabling STATISTICS report > > > >.seems to be unusual.isn't it ? > >had anyone faced the same problem ? > >can someone help me out. > > > >Regards, > >Jp. > > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
Problem with Autotrace - Is this a BUG ?
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 AUTOTRACE works fine on the Database server machine. >the database server ENV is 9.2.0.3/Win2k AS - With SP3. > >SQL>connect cti/cti; >SQL>set autot trace >SQL> > >whereas when i try the same from a different machine,i get the error below. >{ this client machine has 9.2.0.2/Win2K server - with SP3 } > >SQL>connect cti/[EMAIL PROTECTED]; >SQL>set autot trace >SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled >SP2-0611: Error enabling STATISTICS report > >.seems to be unusual.isn't it ? >had anyone faced the same problem ? >can someone help me out. > >Regards, >Jp. -- 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).
Problem with Autotrace ?
Guys, SET AUTOTRACE works fine on the Database server machine. the database server ENV is 9.2.0.3/Win2k AS - With SP3. SQL>connect cti/cti; SQL>set autot trace SQL> whereas when i try the same from a different machine,i get the error below. { this client machine has 9.2.0.2/Win2K server - with SP3 } SQL>connect cti/[EMAIL PROTECTED]; SQL>set autot trace SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report .seems to be unusual.isn't it ? had anyone faced the same problem ? can someone help me out. Regards, Jp. -- 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).