Autotrace only works OK on the DB server machine sqlplus.

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 19 May 2004 05:54:28 -0700
Message-ID: <1de5ebe7.0405190454.3846393b@posting.google.com>

DB: Oracle 9.2.0.4
OS: Windows 2000 Server sp3

I set up autotrace as usual (utlxplan, utlxpls, public synonym for PLAN_TABLE, plustrace, grant plustrace to PUBLIC ...) and then when connecting from a sqlplus session on the DB server machine everything works fine:

user_at_dbname.server> set autotrace on
user_at_dbname.server> select sysdate from dual;

SYSDATE

---

19-MAY-04 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
        383  bytes sent via SQL*Net to client
        503  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

user_at_dbname.server>

But when connecting from a sqlplus session on another machine (same user) :

user_at_dbname.server> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report user_at_dbname.server>
user_at_dbname.server> select sysdate from dual;

SYSDATE

---

19-MAY-04 Execution Plan

---

   0 SELECT STATEMENT Optimizer=CHOOSE    1 0 TABLE ACCESS (FULL) OF 'DUAL' (No statistics info).

Of course, PLUSTRACE role is enabled and granted to PUBLIC.

The only difference is the Oracle client version:

9.2.0.1 (upgraded to) -> 9.2.0.4 on server (including sqlplus version
9.2.0.4 too)
9.2.0.1 on client machines (sqlplus version 9.2.0.1).

Can be this (little) difference the cause?

Any clues out there?

Thanks.

Carlos. Received on Wed May 19 2004 - 07:54:28 CDT