commit 50e86d

2025-12-02 12:11:31 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

`oracle/awr и ash/AWR - Buffer Hit Ratio в разрезе снапшотов.md` ..
@@ 14,7 14,9 @@
	where trunc(BEGIN_INTERVAL_TIME) >= to_date('25.03.2024','dd.mm.yyyy')
	order by 1
	)
-	SELECT t.start_dt,buffer_hit_ratio hit_g, trunc(
-	(1-((ph_r_delta)/(gets_delta+c_gets_delta)))*100
-	,2) hit_l FROM t
+	SELECT t.start_dt,
+	buffer_hit_ratio hit_g,
+	trunc((1-((ph_r_delta)/(gets_delta+c_gets_delta)))*100,2) hit_l
+	FROM t
+
	```