DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: i want to store the last 5 days locks in database

  1. #1
    Join Date
    Oct 2013
    Posts
    3

    i want to store the last 5 days locks in database

    Hi all,

    i am manoj.im a DBA for production of size 7TB runnig o 4 node i want to store all locks in db for feature analysis like Grid monitoring analysis. How to do that please tell me how

    and wht is diff b/w dba_lock and gv$lock

    what i am thinking is i am creating trigger on dba_lock after insert i will store it another table is this correct?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can use auditing to track when objects are locked.

    http://docs.oracle.com/cd/B12037_01/...ments_4007.htm

    But you may want to start by looking for "for update" and "lock table" in your code.

  3. #3
    Join Date
    Oct 2013
    Posts
    3
    thnak you mod. i need to get some more information about locks like program name etc. and store it in my table for feature.

    in auditing below is right or wrong.
    AUDIT INSERT, UPDATE, DELETE ON sys.dba_lock BY ACCESS;

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