和v$sql_text再关联,v$sql_text好象是全的(order by piece)
同时可以看看v$sqlarea
V$SQLAREA lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution.
用trigger的话
CREATE OR REPLACE TRIGGER T
BEFORE INSERT OR UPDATE OR DELETE ON MonitorTable
FOR EACH ROW
BEGIN
If updating Then
deal with yourlogtable;
End If;
IF inserting then
deal with yourlogtable;
End If;
IF deleting then
deal with yourlogtable;
End If;
END;