视图杂记7

ALL_AUDIT_POLICIES
ALL_AUDIT_POLICY_COLUMNS
ALL_CLUSTERS
ALL_COLL_TYPES
ALL_COL_COMMENTS
ALL_COL_PENDING_STATS
ALL_COL_PRIVS 
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_CONS_OBJ_COLUMNS
ALL_CONTEXT

ALL_DB_LINKS
ALL_DIRECTORIES
ALL_ERRORS
ALL_ERRORS_AE
ALL_EXTERNAL_LOCATIONS
ALL_EXTERNAL_TABLES
ALL_HISTOGRAMS
ALL_IDENTIFIERS
ALL_INDEXES 
ALL_INDEXTYPES
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_IND_PARTITIONS 
ALL_IND_PENDING_STATS
ALL_IND_STATISTICS 
ALL_IND_SUBPARTITIONS
ALL_INTERNAL_TRIGGERS
ALL_LOG_GROUPS
ALL_LOG_GROUP_COLUMNS
ALL_MVIEWS

DBA_BASE_TABLE_MVIEWS
ALL_MVIEW_AGGREGATES
ALL_MVIEW_ANALYSIS
ALL_MVIEW_COMMENTS
ALL_MVIEW_DETAIL_PARTITION
ALL_MVIEW_DETAIL_RELATIONS
ALL_MVIEW_DETAIL_SUBPARTITION
ALL_MVIEW_JOINS
ALL_MVIEW_KEYS
ALL_MVIEW_LOGS
ALL_MVIEW_REFRESH_TIMES
 
ALL_SYNONYMS: Syntax 
ALL_TABLES: Syntax 
ALL_TAB_COLS: Syntax 
ALL_TAB_COLUMNS: Syntax 
ALL_TAB_COL_STATISTICS: Syntax 
ALL_TAB_COMMENTS: Syntax 
ALL_TAB_HISTGRM_PENDING_STATS: Syntax 
ALL_TAB_HISTOGRAMS: Syntax 
ALL_TAB_MODIFICATIONS: Syntax 
ALL_TAB_PARTITIONS: Syntax 
ALL_TAB_PENDING_STATS: Syntax 
ALL_TAB_PRIVS: Syntax 
ALL_TAB_PRIVS_MADE: Syntax 
ALL_TAB_PRIVS_RECD: Syntax 
ALL_TAB_STATISTICS: Syntax 
ALL_TAB_STATS_HISTORY: Syntax 
ALL_TAB_STAT_PREFS: Syntax 
ALL_TAB_SUBPARTITIONS: Syntax 

ALL_TRIGGERS: Syntax 
ALL_TRIGGER_COLS: Syntax 
ALL_TRIGGER_ORDERING: Syntax 

DBA_HIST_ENQUEUE_STAT: Syntax 
DBA_HIST_EVENT_HISTOGRAM: Syntax 
DBA_HIST_EVENT_NAME: Syntax 
DBA_HIST_FILEMETRIC_HISTORY: Syntax 
DBA_HIST_FILESTATXS: Syntax 
DBA_HIST_IC_CLIENT_STATS: Syntax 
DBA_HIST_IC_DEVICE_STATS: Syntax 
DBA_HIST_INSTANCE_RECOVERY: Syntax 
DBA_HIST_INST_CACHE_TRANSFER: Syntax 
DBA_HIST_INTERCONNECT_PINGS: Syntax 
DBA_HIST_IOSTAT_DETAIL: Syntax 
DBA_HIST_IOSTAT_FILETYPE: Syntax 
DBA_HIST_IOSTAT_FILETYPE_NAME: Syntax 
DBA_HIST_IOSTAT_FUNCTION: Syntax 
DBA_HIST_IOSTAT_FUNCTION_NAME: Syntax 
DBA_HIST_JAVA_POOL_ADVICE: Syntax 
DBA_HIST_LATCH: Syntax 
DBA_HIST_LATCH_CHILDREN: Syntax 
DBA_HIST_LATCH_MISSES_SUMMARY: Syntax 
DBA_HIST_LATCH_NAME: Syntax 
DBA_HIST_LATCH_PARENT: Syntax 
DBA_HIST_LIBRARYCACHE: Syntax 

DBA_HIST_LOG: Syntax 
DBA_HIST_MEMORY_RESIZE_OPS: Syntax 
DBA_HIST_MEMORY_TARGET_ADVICE: Syntax 
DBA_HIST_MEM_DYNAMIC_COMP: Syntax 
DBA_HIST_METRIC_NAME: Syntax 
DBA_HIST_MTTR_TARGET_ADVICE: Syntax 
DBA_HIST_OSSTAT: Syntax 
DBA_HIST_OSSTAT_NAME: Syntax 
DBA_HIST_PARAMETER: Syntax 
DBA_HIST_PARAMETER_NAME: Syntax 
DBA_HIST_PGASTAT: Syntax 
DBA_HIST_PGA_TARGET_ADVICE: Syntax 
DBA_HIST_PROCESS_MEM_SUMMARY: Syntax 
DBA_HIST_RESOURCE_LIMIT: Syntax 
DBA_HIST_ROWCACHE_SUMMARY: Syntax 
DBA_HIST_RSRC_CONSUMER_GROUP: Syntax

DBA_HIST_SGA: Syntax 
DBA_HIST_SGASTAT: Syntax 
DBA_HIST_SGA_TARGET_ADVICE: Syntax 
DBA_HIST_SHARED_POOL_ADVICE: Syntax 
DBA_HIST_SHARED_SERVER_SUMMARY: Syntax 
DBA_HIST_SNAPSHOT: Syntax 
DBA_HIST_SNAP_ERROR: Syntax 
DBA_HIST_SQLBIND: Syntax 
DBA_HIST_SQLCOMMAND_NAME: Syntax 
DBA_HIST_SQLSTAT: Syntax 
DBA_HIST_SQLTEXT: Syntax 
DBA_HIST_SQL_BIND_METADATA: Syntax 
DBA_HIST_SQL_PLAN: Syntax 
DBA_HIST_SQL_SUMMARY: Syntax 
DBA_HIST_SQL_WORKAREA_HSTGRM: Syntax 
DBA_HIST_STAT_NAME: Syntax 

DBA_HIST_SYSSTAT: Syntax 
DBA_HIST_SYSTEM_EVENT: Syntax 

DBA_HIST_TABLESPACE_STAT: Syntax 
DBA_HIST_TBSPC_SPACE_USAGE: Syntax 
DBA_HIST_TEMPFILE: Syntax 
DBA_HIST_TEMPSTATXS: Syntax 
DBA_HIST_THREAD: Syntax 
DBA_HIST_TOPLEVELCALL_NAME: Syntax 
DBA_HIST_UNDOSTAT: Syntax 
DBA_HIST_WAITCLASSMET_HISTORY: Syntax 
DBA_HIST_WAITSTAT: Syntax 

DBA_INDEXES: Syntax 
DBA_INDEXTYPES: Syntax
DBA_IND_COLUMNS: Syntax
DBA_IND_PARTITIONS: Syntax
DBA_IND_PENDING_STATS: Syntax
DBA_IND_STATISTICS: Syntax 
DBA_IND_SUBPARTITIONS: Syntax

DBA_PROCEDURES: Syntax 
DBA_PROFILES: Syntax 
DBA_SCHEDULER_JOBS: Syntax
DBA_SCHEDULER_JOB_LOG: Syntax 
DBA_SCHEDULER_JOB_ROLES: Syntax 
DBA_SCHEDULER_JOB_RUN_DETAILS: Syntax 
DBA_SCHEDULER_NOTIFICATIONS: Syntax 
DBA_SCHEDULER_PROGRAMS: Syntax 

V$LOCK: Syntax 
V$LOCKED_OBJECT: Syntax 
V$LOCK_ACTIVITY: Syntax 
V$LOCK_TYPE: Syntax 

V$SESSION: Syntax 
V$SESSION_BLOCKERS: Syntax 
V$SESSION_CONNECT_INFO: Syntax 
V$SESSION_CURSOR_CACHE: Syntax 
V$SESSION_EVENT: Syntax 
V$SESSION_FIX_CONTROL: Syntax 
V$SESSION_LONGOPS: Syntax 
V$SESSION_OBJECT_CACHE: Syntax 
V$SESSION_WAIT: Syntax 
V$SESSION_WAIT_CLASS: Syntax 
V$SESSION_WAIT_HISTORY: Syntax

V$SESSTAT: Syntax 
V$SESS_IO: Syntax 
V$SESS_TIME_MODEL: Syntax 
V$SES_OPTIMIZER_ENV: Syntax 
V$SGA: Syntax 
V$SGAINFO: Syntax 
V$SGASTAT: Syntax 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22308399/viewspace-750707/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22308399/viewspace-750707/