1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
select distinct
to_char(s.snap_time,'dd/mm/yyyy hh24:mi:ss') heure
,i.db_name
,e.parameter
,e.usage - b.usage "usage"
from
stats$rowcache_summary e
,stats$rowcache_summary b
,stats$snapshot s
,stats$database_instance i
where
b.snap_id >= (select min(snap_id) from cp_snapshot)
and
e.snap_id = b.snap_id + 1
and
b.parameter = e.parameter
and
e.snap_id = s.snap_id
and
i.startup_time = s.startup_time
and
i.instance_number = s.instance_number
and
e.gets > 0 and b.gets > 0 |
