ASH - Список наиболее полезных полей

SELECT snap_id,sample_id,sample_time,u.username,session_id sid,session_serial# serial,program,module,action,machine,
t.sql_id,dbms_lob.substr(tt.SQL_TEXT,3000) sql_text,
sql_plan_hash_value phv,sql_opname,wait_class,event,p1,p2,p3,blocking_session
FROM dba_hist_active_sess_history t
join dba_users u on u.user_id =t.user_id
left join dba_hist_sqltext tt on tt.SQL_ID = t.SQL_ID