| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: explain plan works when using vi, but fails with microsoft client
There is a big difference between client versions some times.
I have a 9i test database, a 10g test database and an 8i production
database.
The users currently have the 8i client and I have the 10g client.
I was demoing the "select current_timestamp from dual;' to the
developers and it it wouldn't
work against the 9i or 10g database from the 8i client.
It worked okay from the 9i and 10g client against the 9i and 10g
database.
It caught me off guard for a moment until I realized the client
version.
Ron
>>> DWILLIAMS_at_LIFETOUCH.COM 07/14/2004 9:02:27 AM >>> 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
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
1
Elapsed: 00:00:00.00
Execution Plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (FULL) OF 'DUAL'
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |