Blame
| c405e8 | feagor | 2025-12-02 11:48:13 | 1 | # ASH - Список наиболее полезных полей |
| 2 | ||||
| a07e93 | feagor | 2025-12-06 11:06:04 | 3 | ```ora |
| c405e8 | feagor | 2025-12-02 11:48:13 | 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 | ``` |