请问：怎样知道Oracal8最近处理的SQL

Question

you can find it in V$SQL

Answer 1

在v_$sql里有所有应用程序发送的sql，可以使用select "SQL_TEXT","SHARABLE_MEM","PERSISTENT_MEM","RUNTIME_MEM","SORTS","LOADED_VERSIONS","OPEN_VERSIONS","USERS_OPENING","EXECUTIONS","USERS_EXECUTING","LOADS","FIRST_LOAD_TIME","INVALIDATIONS","PARSE_CALLS","DISK_READS","BUFFER_GETS","ROWS_PROCESSED","COMMAND_TYPE","OPTIMIZER_MODE","OPTIMIZER_COST","PARSING_USER_ID","PARSING_SCHEMA_ID","KEPT_VERSIONS","ADDRESS","TYPE_CHK_HEAP","HASH_VALUE","PLAN_HASH_VALUE","CHILD_NUMBER","MODULE","MODULE_HASH","ACTION","ACTION_HASH","SERIALIZABLE_ABORTS","OUTLINE_CATEGORY","CPU_TIME","ELAPSED_TIME","OUTLINE_SID","CHILD_ADDRESS","SQLTYPE","REMOTE","OBJECT_STATUS","LITERAL_HASH_VALUE","LAST_LOAD_TIME","IS_OBSOLETE" from v$sql 查看相关字段的记录
Last_load_time 字段就是在V$SQL视图里面

Answer 2

jiezhi(西域浪子) :
能否说详细些？

Answer 3

最近时间：
select  LAST_LOAD_TIME from v$sql where rownum<=1;
更详细点：
select * from v$sql where rownum<=1;

Answer 4

可以查看重做日志。
用LogMiner分析工具。