一般分类
-
编辑 删除
oracle 10g tuning 常用sql
v$active_session_history V$SYSTEM_WAIT_CLASS v$session [@more@]select obj.object_name, obj.object_type, ash.event, sum(ash.wait_time + ash.time_waited) wait_timefrom v$active_session_history ash, dba_objects objwhere ash.sample_time > sysdate -1 and ash.current_obj# = obj.object_idgroup by obj.object_name, obj.object_type, ash.eventorder by 4 desc;select ash.user_id, u.username, sqla.sql_text, sum(ash.wait_time + ash.time_waited) wait_timefrom
