dba_waiters & dba_blockers views not working in 10.1.0.4

[zakriyamhd]

All,
oracle :10.1.0.4
SunOs:5.9


I am trying to query the view dba_waiters and dba_blockers;
but iam getting the error view doesnt exist is there anything i need to run before using them.


SQL> desc dba_waiters;
ERROR:
ORA-04043: object dba_waiters does not exist


SQL> desc dba_waiters;
ERROR:
ORA-04043: object dba_waiters does not exist


SQL> desc dba_blockers;
ERROR:
ORA-04043: object dba_blockers does not exist


SQL> select * from dba_wiaters;
select * from dba_wiaters
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> show user
USER is "SYS"


One of the user complained me that from oracle warehouse builder (owb) when he connects he gets the message orphaned sessions existing and to kill those sessions with the sid and the serial# but when i went and see in the v$ session there were no serial# existing with the sid so i asked me to complete come out of the owb and log in again, he said it works fine now.

during this process i tried to query the dba_waiters and dba_blockers to see whther i can find any orphaned sessions.

is there anything really exist like orphaned sessions that the user complained me about , if yes how to check them


thanks

[davey23uk]

need to run a script to create waiters and blockers from oracle_home/rdbms/admin - cant remember name of the script but you can search for it

[marist89]

?/rdbms/admin/catblock.sql