DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_HIST_PROCESS_MEM_SUMMARY

Object Details
Object Name: CDB_HIST_PROCESS_MEM_SUMMARY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Process Memory Historical Summary Information in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAP_ID NUMBER
Yes
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
CATEGORY VARCHAR2 (15) Yes
NUM_PROCESSES NUMBER

NON_ZERO_ALLOCS NUMBER

USED_TOTAL NUMBER

ALLOCATED_TOTAL NUMBER

ALLOCATED_AVG NUMBER

ALLOCATED_STDDEV NUMBER

ALLOCATED_MAX NUMBER

MAX_ALLOCATED_MAX NUMBER

CON_DBID NUMBER

CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      CATEGORY
,      NUM_PROCESSES
,      NON_ZERO_ALLOCS
,      USED_TOTAL
,      ALLOCATED_TOTAL
,      ALLOCATED_AVG
,      ALLOCATED_STDDEV
,      ALLOCATED_MAX
,      MAX_ALLOCATED_MAX
,      CON_DBID
,      CON_ID
FROM SYS.CDB_HIST_PROCESS_MEM_SUMMARY;

Dependencies

[top of page]

SYS.CDB_HIST_PROCESS_MEM_SUMMARY does not reference any database object

SYS.CDB_HIST_PROCESS_MEM_SUMMARY is referenced by following:

SchemaPUBLIC
SynonymCDB_HIST_PROCESS_MEM_SUMMARY