RE: explain plan works when using vi, but fails with microsoft cl ient

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 14 Jul 2004 08:02:27 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B009E8@EXCHMN3>

Ryan

Yes, you need to upgrade the Windows client. Some change was made with 9.2.0.3 that makes it incompatible for autotrace with earlier versions of the client. Sounds weird, but that is the solution.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_comcast.net
Sent: Wednesday, July 14, 2004 7:48 AM
To: oracle-l_at_freelists.org
Subject: explain plan works when using vi, but fails with microsoft client

I have granted plustrace role and there is an explain plan. Database verion is 9.2.0.3. However, the windows client is just 9.0.1.3, do I really need to patch that client? I installed with the developer suite? I run the following from the same user on the same database connected to the unix server and running sqlplus and the following happens: SQL> set autotrace on
SQL> select 1 from dual;

1
Execution Plan

0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (FULL) OF 'DUAL' Statistics

          0  recursive calls
          0  db block gets
          3  consistent gets
          0  physical reads
          0  redo size
        484  bytes sent via SQL*Net to client
        651  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

Exact same thing against the same database with the same user with the windows client:
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report SQL> select 1 from dual;

1
Elapsed: 00:00:00.00
Execution Plan

0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (FULL) OF 'DUAL'

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jul 14 2004 - 08:04:22 CDT