V$ 的表到底有哪几个? 很多的,好像100多个v$session中的sid ,serial#用来唯一标示会话的。你select * 仔细看一看,应该可以明白很多的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select object_name from dba_objects where object_name like 'V$%';然后再desc看看表的描述 V$ARCHIVE_PROCESSES V$BGPROCESS V$BSP V$CACHE V$CACHE_LOCK V$CIRCUIT V$DB_OBJECT_CACHE V$DISPATCHER V$DISPATCHER_RATE V$DLM_ALL_LOCKS V$DLM_LOCKS V$ENQUEUE_LOCK V$FAST_START_SERVERS V$HS_AGENT V$HS_SESSION V$INSTANCE_RECOVERY V$LATCHHOLDER V$LOCK V$LOCKED_OBJECT V$LOCK_ELEMENT V$OBJECT_DEPENDENCY V$PQ_SESSTAT V$PQ_SLAVE V$PQ_SYSSTAT V$PQ_TQSTAT V$PROCESS V$PX_PROCESS V$PX_PROCESS_SYSSTAT V$PX_SESSION V$PX_SESSTAT V$QUEUE V$RECOVERY_FILE_STATUS V$RECOVERY_LOG V$RECOVERY_STATUS V$RESOURCE_LIMIT V$SESSION V$SESSION_LONGOPS V$SHARED_SERVER V$SQL V$SQLAREA V$TRANSACTION_ENQUEUE 参考:http://otn.oracle.com/pls/tahiti/tahiti.drilldown?re=&word=proc&book=a76961&preference= select owner, object_name from all_objects where object_name like 'V$%'; V$ACCESSV$ACTIVE_INSTANCESV$AQV$AQ1V$ARCHIVEV$ARCHIVED_LOGV$ARCHIVE_DESTV$ARCHIVE_PROCESSESV$BACKUPV$BACKUP_ASYNC_IOV$BACKUP_CORRUPTIONV$BACKUP_DATAFILEV$BACKUP_DEVICEV$BACKUP_PIECEV$BACKUP_REDOLOGV$BACKUP_SETV$BACKUP_SYNC_IOV$BGPROCESSV$BHV$BSPV$BUFFER_POOLV$BUFFER_POOL_STATISTICSV$CIRCUITV$CLASS_PINGV$COMPATIBILITYV$COMPATSEGV$CONTEXTV$CONTROLFILEV$CONTROLFILE_RECORD_SECTIONV$COPY_CORRUPTIONV$DATABASEV$DATAFILEV$DATAFILE_COPYV$DATAFILE_HEADERV$DBFILEV$DBLINKV$DB_CACHE_ADVICEV$DB_OBJECT_CACHEV$DB_PIPESV$DELETED_OBJECTV$DISPATCHERV$DISPATCHER_RATEV$DLM_ALL_LOCKSV$DLM_CONVERT_LOCALV$DLM_CONVERT_REMOTEV$DLM_LATCHV$DLM_LOCKSV$DLM_MISCV$DLM_RESSV$DLM_TRAFFIC_CONTROLLERV$ENABLEDPRIVSV$ENQUEUE_LOCKV$EVENT_NAMEV$EXECUTIONV$FAST_START_SERVERSV$FAST_START_TRANSACTIONSV$FILESTATV$FILE_PINGV$FIXED_TABLEV$FIXED_VIEW_DEFINITIONV$GLOBAL_BLOCKED_LOCKSV$GLOBAL_TRANSACTIONV$HS_AGENTV$HS_PARAMETERV$HS_SESSIONV$INDEXED_FIXED_COLUMNV$INSTANCEV$INSTANCE_RECOVERYV$LATCHV$LATCHHOLDERV$LATCHNAMEV$LATCH_CHILDRENV$LATCH_MISSESV$LATCH_PARENTV$LIBRARYCACHEV$LICENSEV$LOADCSTATV$LOADISTATV$LOADPSTATV$LOADTSTATV$LOCKV$LOCKED_OBJECTV$LOCKS_WITH_COLLISIONSV$LOCK_ACTIVITYV$LOCK_ELEMENTV$LOGV$LOGFILEV$LOGHISTV$LOGMNR_CONTENTSV$LOGMNR_DICTIONARYV$LOGMNR_LOGSV$LOGMNR_PARAMETERSV$LOG_HISTORYV$MAX_ACTIVE_SESS_TARGET_MTHV$MLS_PARAMETERSV$MTSV$MYSTATV$NLS_PARAMETERSV$NLS_VALID_VALUESV$OBJECT_DEPENDENCYV$OBSOLETE_PARAMETERV$OFFLINE_RANGEV$OPEN_CURSORV$OPTIONV$PARALLEL_DEGREE_LIMIT_MTHV$PARAMETERV$PARAMETER2V$PQ_SESSTATV$PQ_SLAVEV$PQ_SYSSTATV$PQ_TQSTATV$PROCESSV$PROXY_ARCHIVEDLOGV$PROXY_DATAFILEV$PWFILE_USERSV$PX_PROCESSV$PX_PROCESS_SYSSTATV$PX_SESSIONV$PX_SESSTATV$QUEUEV$RECOVERY_FILE_STATUSV$RECOVERY_LOGV$RECOVERY_PROGRESSV$RECOVERY_STATUSV$RECOVER_FILEV$REQDISTV$RESERVED_WORDSV$RESOURCEV$RESOURCE_LIMITV$ROLLNAMEV$ROLLSTATV$ROWCACHEV$ROWCACHE_PARENTV$ROWCACHE_SUBORDINATEV$RSRC_CONSUMER_GROUPV$RSRC_CONSUMER_GROUP_CPU_MTHV$RSRC_PLANV$RSRC_PLAN_CPU_MTHV$SESSIONV$SESSION_CONNECT_INFOV$SESSION_CURSOR_CACHEV$SESSION_EVENTV$SESSION_LONGOPSV$SESSION_OBJECT_CACHEV$SESSION_WAITV$SESSTATV$SESS_IOV$SGAV$SGASTATV$SHARED_POOL_RESERVEDV$SHARED_SERVERV$SORT_SEGMENTV$SORT_USAGEV$SQLV$SQLAREAV$SQLTEXTV$SQLTEXT_WITH_NEWLINESV$SQL_BIND_DATAV$SQL_BIND_METADATAV$SQL_CURSORV$SQL_SHARED_CURSORV$SQL_SHARED_MEMORYV$STATNAMEV$SUBCACHEV$SYSSTATV$SYSTEM_CURSOR_CACHEV$SYSTEM_EVENTV$SYSTEM_PARAMETERV$SYSTEM_PARAMETER2V$TABLESPACEV$TARGETRBAV$TEMPFILEV$TEMPORARY_LOBSV$TEMPSTATV$TEMP_EXTENT_MAPV$TEMP_EXTENT_POOLV$TEMP_PINGV$TEMP_SPACE_HEADERV$THREADV$TIMERV$TRANSACTIONV$TRANSACTION_ENQUEUEV$TYPE_SIZEV$VERSIONV$WAITSTATV$_LOCK 去查一下吧!select table_name from dict where table_name like 'V$%'; 到oracle网站上下载oracle参考,其中有所有的动态视图的说明 怎样通过SCN值来恢复已经删除的数据 Hit_radio和Reads_per_run是什么意思呢? oracle数据快速入库的研究和实现 【大虾请进】 关于ORACLE 导入和导出数据 无效SQL。。GG们帮忙解决下。。谢谢。。。 Insert语句对查询性能的影响? 如何更新游标 oracle 每天都要做的imp问题 很简单的问题 bzszp(SongZip) 请进,什么叫命令行未正确结束? 初学Oracle,请问Oracle9i for windows的版本哪里有下载啊?谢谢 RMAN的还原问题,急,马上给分
然后再desc看看表的描述
V$BGPROCESS
V$BSP
V$CACHE
V$CACHE_LOCK
V$CIRCUIT
V$DB_OBJECT_CACHE
V$DISPATCHER
V$DISPATCHER_RATE
V$DLM_ALL_LOCKS
V$DLM_LOCKS
V$ENQUEUE_LOCK
V$FAST_START_SERVERS
V$HS_AGENT
V$HS_SESSION
V$INSTANCE_RECOVERY
V$LATCHHOLDER
V$LOCK
V$LOCKED_OBJECT
V$LOCK_ELEMENT
V$OBJECT_DEPENDENCY
V$PQ_SESSTAT
V$PQ_SLAVE
V$PQ_SYSSTAT
V$PQ_TQSTAT
V$PROCESS
V$PX_PROCESS
V$PX_PROCESS_SYSSTAT
V$PX_SESSION
V$PX_SESSTAT
V$QUEUE
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_STATUS
V$RESOURCE_LIMIT
V$SESSION
V$SESSION_LONGOPS
V$SHARED_SERVER
V$SQL
V$SQLAREA
V$TRANSACTION_ENQUEUE 参考:
http://otn.oracle.com/pls/tahiti/tahiti.drilldown?re=&word=proc&book=a76961&preference=
V$ACCESS
V$ACTIVE_INSTANCES
V$AQ
V$AQ1
V$ARCHIVE
V$ARCHIVED_LOG
V$ARCHIVE_DEST
V$ARCHIVE_PROCESSES
V$BACKUP
V$BACKUP_ASYNC_IO
V$BACKUP_CORRUPTION
V$BACKUP_DATAFILE
V$BACKUP_DEVICEV$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$BACKUP_SYNC_IO
V$BGPROCESS
V$BH
V$BSP
V$BUFFER_POOL
V$BUFFER_POOL_STATISTICS
V$CIRCUIT
V$CLASS_PING
V$COMPATIBILITY
V$COMPATSEGV$CONTEXT
V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION
V$DATABASE
V$DATAFILE
V$DATAFILE_COPY
V$DATAFILE_HEADER
V$DBFILE
V$DBLINK
V$DB_CACHE_ADVICE
V$DB_OBJECT_CACHE
V$DB_PIPESV$DELETED_OBJECT
V$DISPATCHER
V$DISPATCHER_RATE
V$DLM_ALL_LOCKS
V$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE
V$DLM_LATCH
V$DLM_LOCKS
V$DLM_MISC
V$DLM_RESS
V$DLM_TRAFFIC_CONTROLLER
V$ENABLEDPRIVS
V$ENQUEUE_LOCKV$EVENT_NAME
V$EXECUTION
V$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS
V$FILESTAT
V$FILE_PING
V$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
V$GLOBAL_BLOCKED_LOCKS
V$GLOBAL_TRANSACTION
V$HS_AGENT
V$HS_PARAMETER
V$HS_SESSIONV$INDEXED_FIXED_COLUMN
V$INSTANCE
V$INSTANCE_RECOVERY
V$LATCH
V$LATCHHOLDER
V$LATCHNAME
V$LATCH_CHILDREN
V$LATCH_MISSES
V$LATCH_PARENT
V$LIBRARYCACHE
V$LICENSE
V$LOADCSTAT
V$LOADISTATV$LOADPSTAT
V$LOADTSTAT
V$LOCK
V$LOCKED_OBJECT
V$LOCKS_WITH_COLLISIONS
V$LOCK_ACTIVITY
V$LOCK_ELEMENT
V$LOG
V$LOGFILE
V$LOGHIST
V$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY
V$LOGMNR_LOGSV$LOGMNR_PARAMETERS
V$LOG_HISTORY
V$MAX_ACTIVE_SESS_TARGET_MTH
V$MLS_PARAMETERS
V$MTS
V$MYSTAT
V$NLS_PARAMETERS
V$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY
V$OBSOLETE_PARAMETER
V$OFFLINE_RANGE
V$OPEN_CURSOR
V$OPTIONV$PARALLEL_DEGREE_LIMIT_MTH
V$PARAMETER
V$PARAMETER2
V$PQ_SESSTAT
V$PQ_SLAVE
V$PQ_SYSSTAT
V$PQ_TQSTAT
V$PROCESS
V$PROXY_ARCHIVEDLOG
V$PROXY_DATAFILE
V$PWFILE_USERS
V$PX_PROCESS
V$PX_PROCESS_SYSSTATV$PX_SESSION
V$PX_SESSTAT
V$QUEUE
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_PROGRESS
V$RECOVERY_STATUS
V$RECOVER_FILE
V$REQDIST
V$RESERVED_WORDS
V$RESOURCE
V$RESOURCE_LIMIT
V$ROLLNAMEV$ROLLSTAT
V$ROWCACHE
V$ROWCACHE_PARENT
V$ROWCACHE_SUBORDINATE
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSION_CURSOR_CACHE
V$SESSION_EVENT
V$SESSION_LONGOPSV$SESSION_OBJECT_CACHE
V$SESSION_WAIT
V$SESSTAT
V$SESS_IO
V$SGA
V$SGASTAT
V$SHARED_POOL_RESERVED
V$SHARED_SERVER
V$SORT_SEGMENT
V$SORT_USAGE
V$SQL
V$SQLAREA
V$SQLTEXTV$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_DATA
V$SQL_BIND_METADATA
V$SQL_CURSOR
V$SQL_SHARED_CURSOR
V$SQL_SHARED_MEMORY
V$STATNAME
V$SUBCACHE
V$SYSSTAT
V$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT
V$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2V$TABLESPACE
V$TARGETRBA
V$TEMPFILE
V$TEMPORARY_LOBS
V$TEMPSTAT
V$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL
V$TEMP_PING
V$TEMP_SPACE_HEADER
V$THREAD
V$TIMER
V$TRANSACTION
V$TRANSACTION_ENQUEUEV$TYPE_SIZE
V$VERSION
V$WAITSTAT
V$_LOCK