oracle 10g下的视图

《oracle 10g下的视图》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle10g下的视图SQL>selectobject_namefromall_objects2whereobject_namelike'V$%';OBJECT_NAME------------------------------V$MAP_LIBRARYV$MAP_FILEV$MAP_FILE_EXTENTV$MAP_ELEMENTV$MAP_EXT_ELEMENTV$MAP_COMP_LISTV$MAP_SUBELEMENTV$MAP_FILE_IO_STACKV$SQL_REDIRECTIONV

2、$SQL_PLANV$SQL_PLAN_STATISTICSV$SQL_PLAN_STATISTICS_ALLV$SQL_WORKAREAV$SQL_WORKAREA_ACTIVEV$SQL_WORKAREA_HISTOGRAMV$PGA_TARGET_ADVICEV$PGA_TARGET_ADVICE_HISTOGRAMV$PGASTATV$SYS_OPTIMIZER_ENVV$SES_OPTIMIZER_ENVV$SQL_OPTIMIZER_ENVV$DLM_MISCV$DLM_LATCHV$DLM_

3、CONVERT_LOCALV$DLM_CONVERT_REMOTEV$DLM_ALL_LOCKSV$DLM_LOCKSV$DLM_RESSV$HVMASTER_INFOV$GCSHVMASTER_INFOV$GCSPFMASTER_INFOV$DLM_TRAFFIC_CONTROLLERV$GES_ENQUEUEV$GES_BLOCKING_ENQUEUEV$GC_ELEMENTV$CR_BLOCK_SERVERV$CURRENT_BLOCK_SERVERV$GC_ELEMENTS_WITH_COLLIS

4、IONSV$FILE_CACHE_TRANSFERV$TEMP_CACHE_TRANSFERV$CLASS_CACHE_TRANSFERV$BHV$LOCK_ELEMENTV$LOCKS_WITH_COLLISIONSV$FILE_PINGV$TEMP_PINGV$CLASS_PINGV$INSTANCE_CACHE_TRANSFERV$BUFFER_POOLV$BUFFER_POOL_STATISTICSV$INSTANCE_RECOVERYV$CONTROLFILEV$LOGV$STANDBY_LOG

5、V$DATAGUARD_STATUSV$THREADV$PROCESSV$BGPROCESSV$SESSIONV$LICENSEV$TRANSACTIONV$BSPV$FAST_START_SERVERSV$FAST_START_TRANSACTIONSV$LOCKED_OBJECTV$LATCHV$LATCH_CHILDRENV$LATCH_PARENTV$LATCHNAMEV$LATCHHOLDERV$LATCH_MISSESV$SESSION_LONGOPSV$RESOURCEV$_LOCKV$LO

6、CKV$SESSTATV$MYSTATV$SUBCACHEV$SYSSTATV$STATNAMEV$OSSTATV$ACCESSV$OBJECT_DEPENDENCYV$DBFILEV$FILESTATV$TEMPSTATV$LOGFILEV$FLASHBACK_DATABASE_LOGFILEV$FLASHBACK_DATABASE_LOGV$FLASHBACK_DATABASE_STATV$RESTORE_POINTV$ROLLNAMEV$ROLLSTATV$UNDOSTATV$SGAV$CLUSTE

7、R_INTERCONNECTSV$CONFIGURED_INTERCONNECTSOBJECT_NAME------------------------------V$PARAMETERV$PARAMETER2V$OBSOLETE_PARAMETERV$SYSTEM_PARAMETERV$SYSTEM_PARAMETER2V$SPPARAMETERV$PARAMETER_VALID_VALUESV$ROWCACHEV$ROWCACHE_PARENTV$ROWCACHE_SUBORDINATEV$ENABL

8、EDPRIVSV$NLS_PARAMETERSV$NLS_VALID_VALUESV$LIBRARYCACHEV$TYPE_SIZEV$ARCHIVEV$CIRCUITV$DATABASEV$INSTANCEV$DISPATCHERV$DISPATCHER_CONFIGV$DISPATCHER_RATEV$LOGHISTV$SQLAREAV$SQLAREA_PLAN_HASHV$SQLTEXTV$SQLTEXT_WITH_NE