Pl refer to bug # 2876841 on Metalink.
The workaround may work for you, else you will need to upgrade the Client software.
Regards,
- Kirti
- ryan.gaffuri_at_comcast.net wrote:
> 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'
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
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:25:21 CDT
