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

VIEW: SYS.CDB_SQL_MONITOR_USAGE

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

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
NUM_DB_REPORTS NUMBER
Yes
NUM_EM_REPORTS NUMBER
Yes
FIRST_DB_REPORT_TIME DATE

LAST_DB_REPORT_TIME DATE

FIRST_EM_REPORT_TIME DATE

LAST_EM_REPORT_TIME DATE

CON_ID NUMBER

container id
Query Text

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


SELECT NUM_DB_REPORTS
,      NUM_EM_REPORTS
,      FIRST_DB_REPORT_TIME
,      LAST_DB_REPORT_TIME
,      FIRST_EM_REPORT_TIME
,      LAST_EM_REPORT_TIME
,      CON_ID
FROM SYS.CDB_SQL_MONITOR_USAGE;

Dependencies

[top of page]

SYS.CDB_SQL_MONITOR_USAGE does not reference any database object

SYS.CDB_SQL_MONITOR_USAGE is referenced by following:

SchemaPUBLIC
SynonymCDB_SQL_MONITOR_USAGE