v$sqlarea 保留了每条执行的SQL
SQL> delete from t100 where object_id = :n;
1 row deleted.
SQL> select to_char(sysdate,'yyyy-mm-dd,hh24:mi:ss'),a.sql_text,to_char(a.LAST_ACTIVE_TIME,'yyyy-mm-dd,hh24:mi:ss') from v$sqlarea a where sql_text like '%delete%t100%';
TO_CHAR(SYSDATE,'YY SQL_TEXT TO_CHAR(A.LAST_ACTI
------------------- ------------------------------ -----------------------------
2014-11-14,09:37:28 delete from t100 where object_id = :n 2014-11-14,09:35:17
SQL> select to_char(sysdate,'yyyy-mm-dd,hh24:mi:ss'),a.sql_text,to_char(a.LAST_ACTIVE_TIME,'yyyy-mm-dd,hh24:mi:ss') from v$sqlarea a where sql_text like '%delete%t100%';
TO_CHAR(SYSDATE,'YY SQL_TEXT TO_CHAR(A.LAST_ACTI
------------------- ------------------------------ -------------------
2014-11-14,09:38:10 delete from t100 where object_id = :n 2014-11-14,09:37:56
SQL> select to
v$sqlarea和v$lock
最新推荐文章于 2021-04-16 02:25:45 发布