Home A - Z
Menu

Blame

c405e8 feagor 2025-12-02 11:48:13
1 
# ASH - Список наиболее полезных полей
2
3
```sql
4
SELECT snap_id,sample_id,sample_time,u.username,session_id sid,session_serial# serial,program,module,action,machine,
5
t.sql_id,dbms_lob.substr(tt.SQL_TEXT,3000) sql_text,
6
sql_plan_hash_value phv,sql_opname,wait_class,event,p1,p2,p3,blocking_session
7
FROM dba_hist_active_sess_history t
8
join dba_users u on u.user_id =t.user_id
9
left join dba_hist_sqltext tt on tt.SQL_ID = t.SQL_ID
10
```