dba_waiters & dba_blockers views not working in 10.1.0.4
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dba_waiters & dba_blockers views not working in 10.1.0.4

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    dba_waiters & dba_blockers views not working in 10.1.0.4

    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
    People with goals know where they are going

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ?/rdbms/admin/catblock.sql
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width