DBA Data[Home] [Help]

VIEW: SYS.CDB_SUMMARIES

Source

View Text - Preformatted

SELECT "OWNER","SUMMARY_NAME","CONTAINER_OWNER","CONTAINER_NAME","LAST_REFRESH_SCN","LAST_REFRESH_DATE","REFRESH_METHOD","SUMMARY","FULLREFRESHTIM","INCREFRESHTIM","CONTAINS_VIEWS","UNUSABLE","RESTRICTED_SYNTAX","INC_REFRESHABLE","KNOWN_STALE","QUERY_LEN","CON_ID" FROM CONTAINERS("SYS"."DBA_SUMMARIES")
View Text - HTML Formatted

SELECT "OWNER"
, "SUMMARY_NAME"
, "CONTAINER_OWNER"
, "CONTAINER_NAME"
, "LAST_REFRESH_SCN"
, "LAST_REFRESH_DATE"
, "REFRESH_METHOD"
, "SUMMARY"
, "FULLREFRESHTIM"
, "INCREFRESHTIM"
, "CONTAINS_VIEWS"
, "UNUSABLE"
, "RESTRICTED_SYNTAX"
, "INC_REFRESHABLE"
, "KNOWN_STALE"
, "QUERY_LEN"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SUMMARIES")