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

VIEW: SYS.CDB_ROLLING_EVENTS

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

List of all events reported from DBMS_ROLLING PL/SQL package in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENTID NUMBER

Event identifier which identifies event order
EVENT_TIME TIMESTAMP(6) (11)
Time associated with the event
TYPE VARCHAR2 (7)
Type of event: INFO, NOTICE, WARNING, or ERROR
MESSAGE VARCHAR2 (256)
Text describing the event details
STATUS NUMBER

Status code associated with an event
INSTID NUMBER

Instruction ID associated with an event
REVISION NUMBER

Plan revision number associated with an event
CON_ID NUMBER

container id
Query Text

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


SELECT EVENTID
,      EVENT_TIME
,      TYPE
,      MESSAGE
,      STATUS
,      INSTID
,      REVISION
,      CON_ID
FROM SYS.CDB_ROLLING_EVENTS;

Dependencies

[top of page]

SYS.CDB_ROLLING_EVENTS does not reference any database object

SYS.CDB_ROLLING_EVENTS is referenced by following:

SchemaPUBLIC
SynonymCDB_ROLLING_EVENTS