select pmem.snap_id, pmem.dbid, pmem.instance_number,
category, num_processes, non_zero_allocs,
used_total, allocated_total, allocated_total / num_processes,
allocated_stddev, allocated_max, max_allocated_max,
decode(pmem.con_dbid, 0, pmem.dbid, pmem.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_PROCESS_MEMORY_SUMMARY pmem
where sn.snap_id = pmem.snap_id
and sn.dbid = pmem.dbid
and sn.instance_number = pmem.instance_number
SELECT PMEM.SNAP_ID
, PMEM.DBID
, PMEM.INSTANCE_NUMBER
,
CATEGORY
, NUM_PROCESSES
, NON_ZERO_ALLOCS
,
USED_TOTAL
, ALLOCATED_TOTAL
, ALLOCATED_TOTAL / NUM_PROCESSES
,
ALLOCATED_STDDEV
, ALLOCATED_MAX
, MAX_ALLOCATED_MAX
,
DECODE(PMEM.CON_DBID
, 0
, PMEM.DBID
, PMEM.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_PROCESS_MEMORY_SUMMARY PMEM
WHERE SN.SNAP_ID = PMEM.SNAP_ID
AND SN.DBID = PMEM.DBID
AND SN.INSTANCE_NUMBER = PMEM.INSTANCE_NUMBER
|
|
|