1。select * from v$active_session_history where program ='oracle@GXDB1 (J001)' //进程名(特殊如ora_j0001) 注意进程运行的时间段;
2。筛先出SQL_ID
3。根据SQL_ID从v$sql表中查询SQL内容;
1。select * from v$active_session_history where program ='oracle@GXDB1 (J001)' //进程名(特殊如ora_j0001) 注意进程运行的时间段;
2。筛先出SQL_ID
3。根据SQL_ID从v$sql表中查询SQL内容;