Home A - Z
Menu
Page Index

Commit 50e86d

2025-12-02 12:11:31 feagor: -/-
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
+
```
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