commit 70b025

2025-12-02 11:46:19 feagor: -/-

0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9

`home/oracle/awr и ash/ash - дерево блокировок.md` ..
@@ 7,7 7,8 @@
	FROM dba_hist_active_sess_history ash
	where ash.BLOCKING_SESSION is not null
	and event = 'enq: TX - row lock contention'
-	and ash.SAMPLE_TIME between to_date('10.08.2018 12:20:00','dd.mm.yyyy hh24:mi:ss') and to_date('10.08.2018 12:30:00','dd.mm.yyyy hh24:mi:ss')
+	and ash.SAMPLE_TIME between to_date('10.08.2018 12:20:00','dd.mm.yyyy hh24:mi:ss')
+	and to_date('10.08.2018 12:30:00','dd.mm.yyyy hh24:mi:ss')
	group by sample_id,event
	order by 3 desc;
	```