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

VIEW: SYS.CDB_ADVISOR_USAGE

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

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
ADVISOR_ID NUMBER
Yes
ADVISOR_NAME VARCHAR2 (128) Yes
LAST_EXEC_TIME DATE
Yes
NUM_EXECS NUMBER
Yes
NUM_DB_REPORTS NUMBER
Yes
FIRST_REPORT_TIME DATE

LAST_REPORT_TIME DATE

CON_ID NUMBER

container id
Query Text

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


SELECT ADVISOR_ID
,      ADVISOR_NAME
,      LAST_EXEC_TIME
,      NUM_EXECS
,      NUM_DB_REPORTS
,      FIRST_REPORT_TIME
,      LAST_REPORT_TIME
,      CON_ID
FROM SYS.CDB_ADVISOR_USAGE;

Dependencies

[top of page]

SYS.CDB_ADVISOR_USAGE does not reference any database object

SYS.CDB_ADVISOR_USAGE is referenced by following:

SchemaPUBLIC
SynonymCDB_ADVISOR_USAGE