i want to store the last 5 days locks in database
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?
You can use auditing to track when objects are locked.
But you may want to start by looking for "for update" and "lock table" in your code.
this space intentionally left blank
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;
Click Here to Expand Forum to Full Width