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

VIEW: SYS.PDB_ALERTS

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

Contains descriptions of reasons for PDB alerts

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME TIMESTAMP(6) WITH TIME ZONE (13) Yes Time the vilation happened
NAME VARCHAR2 (30) Yes A name of a non-CDB or a PDB to which this record applies
CAUSE_NO NUMBER
Yes Number identifying a specific reason for a PDB alerts
TYPE_NO NUMBER
Yes Type of the violation
ERROR NUMBER

Oracle error if this violation
LINE NUMBER
Yes Line number for the violation message
MESSAGE VARCHAR2 (4000) Yes An explanation of a reason why a PDB or a non-CDB violations
STATUS NUMBER

Status of the violation
ACTION VARCHAR2 (4000)
Actions to take to resolve the violations
Query Text

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


SELECT TIME
,      NAME
,      CAUSE_NO
,      TYPE_NO
,      ERROR
,      LINE
,      MESSAGE
,      STATUS
,      ACTION
FROM SYS.PDB_ALERTS;

Dependencies

[top of page]

SYS.PDB_ALERTS references the following:

SchemaSYS
TablePDB_ALERT$
SYS.PDB_ALERTS is referenced by following:

SchemaPUBLIC
SynonymPDB_ALERTS