who,when,what,how locked an object ????
select /*+ rule */ aa.object_name,aa.owner,LL.LOCKED_MODE, DECODE (LL.LOCKED_MODE, 0, 'none', 1, 'null', 2,'Row- Share', 3,'Row- exclusive', 4,'Share', 5,'Share /Row- exclusive', 6,'exclusive' ) Locked_Mode_Detail, SES.PROGRAM ,LL.SESSION_ID,SES.SQL_ID ,TXT.LAST_ACTIVE_TIME, TXT.SQL_FULLTEXT from dba_objects aa, v$locked_object ll, v$session ses, V$SQLAREA txt where aa.object_id = LL.OBJECT_ID and LL.SESSION_ID=SES.SID and TXT.SQL_ID=SES.SQL_ID; What queries are going on in my database on a particular object select AR.PARSING_SCHEMA_NAME, AR.EXECUTIONS, AR.ELAPSED_TIME/1000000 "ELAPSED_SECOND", AR.ROWS_PROCESSED,AR.MODULE,AR.LAST_LOAD_TIME, AR.LAST_ACTIVE_TIME,AR.SQL_FULLTEXT from v$sqlarea ar where trunc(AR.LAST_ACTIVE_TIME,'MI') = trunc(sysdate,'MI') and upper(AR.SQL_FULLTEXT) like '%SAMPLE_TEXT%'; Total query list in my database SELECT parsing_schema_name,LAST_LOAD_TIM