SQL & PL/SQL

Hi,

In my database I have three users who are PLAN_TABLE owners: SYS, user1, user2.
When I try to create explain plan with any of these users it’s giving me the error and doesn’t gave me the Time column:


SQL>set autotrace on
SQL> explain plan for
2 select ....;

Explained.

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 141 | 18 (12)|
| 1 | SORT UNIQUE NOSORT | | 1 | 141 | 18 (12)|
| 2 | NESTED LOOPS | | 1 | 141 | 17 (6)|
| 3 | HASH JOIN | | 2 | 220 | 15 (7)|
....
--------------------------------------------------------------------------------------------

Note
-----
- *'PLAN_TABLE' is old version*



Execution Plan
----------------------------------------------------------

----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 8168 | 16336 | 24 (0)|
| 1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY | | | |
----------------------------------------------------------------------------------

Note
-----
- *'PLAN_TABLE' is old version*


Statistics
----------------------------------------------------------
3258 recursive calls
0 db block gets
1605 consistent gets
3 physical reads
64 redo size
1280 bytes sent via SQL*Net to client
492 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
131 sorts (memory)
0 sorts (disk)
12 rows processed

PLEASE HELP!!!