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 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 - 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 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.
 
 SQLconnect cti/cti;
 SQLset 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 }
 
 SQLconnect cti/[EMAIL PROTECTED];
 SQLset 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).

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 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 ?

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 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 ?

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 the error below.
 { this client machine has 9.2.0.2/Win2K server - with SP3 }

 SQLconnect cti/[EMAIL PROTECTED];
 SQLset 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 ?

2003-07-28 Thread Sarnowski, Chris 

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 }
 
  SQLconnect cti/[EMAIL PROTECTED];
  SQLset 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 ?

2003-07-28 Thread Quamrul Polash 

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'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 } 
 
 SQLconnect cti/[EMAIL PROTECTED]; 
 SQLset 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).