Home » RDBMS Server » Server Administration » database in mount mode
database in mount mode [message #505418] Tue, 03 May 2011 00:27 Go to next message
shoeb_s3
Messages: 2
Registered: May 2011
Location: Dhaka
Junior Member
which commands only we can use in database mount mode?
Re: database in mount mode [message #505419 is a reply to message #505418] Tue, 03 May 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
alter database

Regards
Michel
Re: database in mount mode [message #505421 is a reply to message #505419] Tue, 03 May 2011 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Mmm! after a thought I'm not sure of your question.
Which question do you ask:
* which commands can only be executed in mount mode that is which commands cannot be executed when you are not in mount mode?
* in mount mode, which commands can be executed that is among all the commands which one are available in mount mode?

Regards
Michel
Re: database in mount mode [message #505424 is a reply to message #505419] Tue, 03 May 2011 01:09 Go to previous messageGo to next message
shoeb_s3
Messages: 2
Registered: May 2011
Location: Dhaka
Junior Member
amy other command we can use like v$instance or v$database?
in mount mode instance is started,so why v$instance cannot be executed in mount mode? please reply.
Re: database in mount mode [message #505427 is a reply to message #505424] Tue, 03 May 2011 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
amy other command we can use like v$instance or v$database?

These are not commands, these are views.

In mount mode, only control file is opened, so only views about memory struture and control file content can be queried.
This includes v$instance:
***SYS***> select status from v$instance;
STATUS
------------
MOUNTED


Regards
Michel
Re: database in mount mode [message #505556 is a reply to message #505418] Tue, 03 May 2011 14:50 Go to previous messageGo to next message
malalation
Messages: 12
Registered: April 2011
Junior Member
I think you can query any v$ view since they are located in the control file and not in the data dictionary.

But remember, these are views and not commands!

To open the database (changing it's status from mount to open), use the following command in SQL*Plus:

alter database open;


But be careful, this will open the database which is something not wanted in case the DB is a physical standby database!
Re: database in mount mode [message #505558 is a reply to message #505556] Tue, 03 May 2011 15:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I think you can query any v$ view
Most will succeed, but a few will fail & throw error.
Re: database in mount mode [message #505575 is a reply to message #505556] Wed, 04 May 2011 01:13 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Those that work and those that does not work (in 10.2.0.4).

DO NOT WORK:
GV$AQ1
GV$LOGMNR_CONTENTS
GV$LOGMNR_REGION
GV$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE
GV$RSRC_PLAN_HISTORY
GV$SEGMENT_STATISTICS
GV$STREAMS_CAPTURE
GV$TEMP_EXTENT_MAP
GV$TEMP_EXTENT_POOL
GV$TEMP_SPACE_HEADER
V$AQ1
V$BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY
V$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY
V$BACKUP_PIECE_DETAILS
V$BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY
V$BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY
V$LOGMNR_CONTENTS
V$LOGMNR_REGION
V$LOGSTDBY_PROGRESS
V$LOGSTDBY_STATE
V$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY
V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS
V$RSRC_PLAN_HISTORY
V$SEGMENT_STATISTICS
V$STREAMS_CAPTURE
V$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL
V$TEMP_SPACE_HEADER
V$UNUSABLE_BACKUPFILE_DETAILS


WORK:
GV$ACCESS
GV$ACTIVE_INSTANCES
GV$ACTIVE_SERVICES
GV$ACTIVE_SESSION_HISTORY
GV$ACTIVE_SESS_POOL_MTH
GV$ADVISOR_PROGRESS
GV$ALERT_TYPES
GV$AQ1
GV$ARCHIVE
GV$ARCHIVED_LOG
GV$ARCHIVE_DEST
GV$ARCHIVE_DEST_STATUS
GV$ARCHIVE_GAP
GV$ARCHIVE_PROCESSES
GV$ASM_ALIAS
GV$ASM_CLIENT
GV$ASM_DISK
GV$ASM_DISKGROUP
GV$ASM_DISKGROUP_STAT
GV$ASM_DISK_STAT
GV$ASM_FILE
GV$ASM_OPERATION
GV$ASM_TEMPLATE
GV$AW_AGGREGATE_OP
GV$AW_ALLOCATE_OP
GV$AW_CALC
GV$AW_LONGOPS
GV$AW_OLAP
GV$AW_SESSION_INFO
GV$BACKUP
GV$BACKUP_ASYNC_IO
GV$BACKUP_CORRUPTION
GV$BACKUP_DATAFILE
GV$BACKUP_DEVICE
GV$BACKUP_PIECE
GV$BACKUP_REDOLOG
GV$BACKUP_SET
GV$BACKUP_SPFILE
GV$BACKUP_SYNC_IO
GV$BGPROCESS
GV$BH
GV$BLOCKING_QUIESCE
GV$BSP
GV$BUFFERED_PUBLISHERS
GV$BUFFERED_QUEUES
GV$BUFFERED_SUBSCRIBERS
GV$BUFFER_POOL
GV$BUFFER_POOL_STATISTICS
GV$CIRCUIT
GV$CLASS_CACHE_TRANSFER
GV$CLASS_PING
GV$CLIENT_STATS
GV$CLUSTER_INTERCONNECTS
GV$CONFIGURED_INTERCONNECTS
GV$CONTEXT
GV$CONTROLFILE
GV$CONTROLFILE_RECORD_SECTION
GV$COPY_CORRUPTION
GV$CR_BLOCK_SERVER
GV$CURRENT_BLOCK_SERVER
GV$DATABASE
GV$DATABASE_BLOCK_CORRUPTION
GV$DATABASE_INCARNATION
GV$DATAFILE
GV$DATAFILE_COPY
GV$DATAFILE_HEADER
GV$DATAGUARD_CONFIG
GV$DATAGUARD_STATUS
GV$DATAPUMP_JOB
GV$DATAPUMP_SESSION
GV$DBFILE
GV$DBLINK
GV$DB_CACHE_ADVICE
GV$DB_OBJECT_CACHE
GV$DB_PIPES
GV$DB_TRANSPORTABLE_PLATFORM
GV$DELETED_OBJECT
GV$DISPATCHER
GV$DISPATCHER_CONFIG
GV$DISPATCHER_RATE
GV$DLM_ALL_LOCKS
GV$DLM_CONVERT_LOCAL
GV$DLM_CONVERT_REMOTE
GV$DLM_LATCH
GV$DLM_LOCKS
GV$DLM_MISC
GV$DLM_RESS
GV$DLM_TRAFFIC_CONTROLLER
GV$ENABLEDPRIVS
GV$ENCRYPTION_WALLET
GV$ENQUEUE_LOCK
GV$ENQUEUE_STAT
GV$ENQUEUE_STATISTICS
GV$EVENTMETRIC
GV$EVENT_HISTOGRAM
GV$EVENT_NAME
GV$EXECUTION
GV$FAST_START_SERVERS
GV$FAST_START_TRANSACTIONS
GV$FILEMETRIC
GV$FILEMETRIC_HISTORY
GV$FILESPACE_USAGE
GV$FILESTAT
GV$FILE_CACHE_TRANSFER
GV$FILE_HISTOGRAM
GV$FILE_PING
GV$FIXED_TABLE
GV$FIXED_VIEW_DEFINITION
GV$FLASHBACK_DATABASE_LOG
GV$FLASHBACK_DATABASE_LOGFILE
GV$FLASHBACK_DATABASE_STAT
GV$GCSHVMASTER_INFO
GV$GCSPFMASTER_INFO
GV$GC_ELEMENT
GV$GC_ELEMENTS_WITH_COLLISIONS
GV$GES_BLOCKING_ENQUEUE
GV$GES_ENQUEUE
GV$GLOBALCONTEXT
GV$GLOBAL_BLOCKED_LOCKS
GV$GLOBAL_TRANSACTION
GV$HS_AGENT
GV$HS_PARAMETER
GV$HS_SESSION
GV$HVMASTER_INFO
GV$INDEXED_FIXED_COLUMN
GV$INSTANCE
GV$INSTANCE_CACHE_TRANSFER
GV$INSTANCE_LOG_GROUP
GV$INSTANCE_RECOVERY
GV$JAVAPOOL
GV$JAVA_LIBRARY_CACHE_MEMORY
GV$JAVA_POOL_ADVICE
GV$LATCH
GV$LATCHHOLDER
GV$LATCHNAME
GV$LATCH_CHILDREN
GV$LATCH_MISSES
GV$LATCH_PARENT
GV$LIBRARYCACHE
GV$LIBRARY_CACHE_MEMORY
GV$LICENSE
GV$LOADISTAT
GV$LOADPSTAT
GV$LOCK
GV$LOCKED_OBJECT
GV$LOCKS_WITH_COLLISIONS
GV$LOCK_ACTIVITY
GV$LOCK_ELEMENT
GV$LOCK_TYPE
GV$LOG
GV$LOGFILE
GV$LOGHIST
GV$LOGMNR_CALLBACK
GV$LOGMNR_DICTIONARY
GV$LOGMNR_DICTIONARY_LOAD
GV$LOGMNR_LATCH
GV$LOGMNR_LOGFILE
GV$LOGMNR_LOGS
GV$LOGMNR_PARAMETERS
GV$LOGMNR_PROCESS
GV$LOGMNR_SESSION
GV$LOGMNR_STATS
GV$LOGMNR_TRANSACTION
GV$LOGSTDBY
GV$LOGSTDBY_PROCESS
GV$LOGSTDBY_STATS
GV$LOGSTDBY_TRANSACTION
GV$LOG_HISTORY
GV$MANAGED_STANDBY
GV$MAP_COMP_LIST
GV$MAP_ELEMENT
GV$MAP_EXT_ELEMENT
GV$MAP_FILE
GV$MAP_FILE_EXTENT
GV$MAP_FILE_IO_STACK
GV$MAP_LIBRARY
GV$MAP_SUBELEMENT
GV$MAX_ACTIVE_SESS_TARGET_MTH
GV$METRIC
GV$METRICGROUP
GV$METRICNAME
GV$METRIC_HISTORY
GV$MTTR_TARGET_ADVICE
GV$MUTEX_SLEEP
GV$MUTEX_SLEEP_HISTORY
GV$MVREFRESH
GV$MYSTAT
GV$NLS_PARAMETERS
GV$NLS_VALID_VALUES
GV$OBJECT_DEPENDENCY
GV$OBSOLETE_PARAMETER
GV$OFFLINE_RANGE
GV$OPEN_CURSOR
GV$OPTION
GV$OSSTAT
GV$PARALLEL_DEGREE_LIMIT_MTH
GV$PARAMETER2
GV$PARAMETER
GV$PARAMETER_VALID_VALUES
GV$PGASTAT
GV$PGA_TARGET_ADVICE
GV$PGA_TARGET_ADVICE_HISTOGRAM
GV$PQ_SESSTAT
GV$PQ_SLAVE
GV$PQ_SYSSTAT
GV$PQ_TQSTAT
GV$PROCESS
GV$PROCESS_MEMORY
GV$PROCESS_MEMORY_DETAIL
GV$PROCESS_MEMORY_DETAIL_PROG
GV$PROPAGATION_RECEIVER
GV$PROPAGATION_SENDER
GV$PROXY_ARCHIVEDLOG
GV$PROXY_DATAFILE
GV$PWFILE_USERS
GV$PX_BUFFER_ADVICE
GV$PX_PROCESS
GV$PX_PROCESS_SYSSTAT
GV$PX_SESSION
GV$PX_SESSTAT
GV$QUEUE
GV$QUEUEING_MTH
GV$RECOVERY_FILE_STATUS
GV$RECOVERY_LOG
GV$RECOVERY_PROGRESS
GV$RECOVERY_STATUS
GV$RECOVER_FILE
GV$REPLPROP
GV$REPLQUEUE
GV$REQDIST
GV$RESERVED_WORDS
GV$RESOURCE
GV$RESOURCE_LIMIT
GV$RESTORE_POINT
GV$RESUMABLE
GV$RFS_THREAD
GV$RMAN_CONFIGURATION
GV$RMAN_ENCRYPTION_ALGORITHMS
GV$RMAN_OUTPUT
GV$RMAN_STATUS_CURRENT
GV$ROLLSTAT
GV$ROWCACHE
GV$ROWCACHE_PARENT
GV$ROWCACHE_SUBORDINATE
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
GV$RSRC_CONS_GROUP_HISTORY
GV$RSRC_PLAN
GV$RSRC_PLAN_CPU_MTH
GV$RSRC_SESSION_INFO
GV$RULE
GV$RULE_SET
GV$RULE_SET_AGGREGATE_STATS
GV$SCHEDULER_RUNNING_JOBS
GV$SEGSTAT
GV$SEGSTAT_NAME
GV$SERVICEMETRIC
GV$SERVICEMETRIC_HISTORY
GV$SERVICES
GV$SERVICE_EVENT
GV$SERVICE_STATS
GV$SERVICE_WAIT_CLASS
GV$SERV_MOD_ACT_STATS
GV$SESSION
GV$SESSION_CONNECT_INFO
GV$SESSION_CURSOR_CACHE
GV$SESSION_EVENT
GV$SESSION_FIX_CONTROL
GV$SESSION_LONGOPS
GV$SESSION_OBJECT_CACHE
GV$SESSION_WAIT
GV$SESSION_WAIT_CLASS
GV$SESSION_WAIT_HISTORY
GV$SESSMETRIC
GV$SESSTAT
GV$SESS_IO
GV$SESS_TIME_MODEL
GV$SES_OPTIMIZER_ENV
GV$SGA
GV$SGAINFO
GV$SGASTAT
GV$SGA_CURRENT_RESIZE_OPS
GV$SGA_DYNAMIC_COMPONENTS
GV$SGA_DYNAMIC_FREE_MEMORY
GV$SGA_RESIZE_OPS
GV$SGA_TARGET_ADVICE
GV$SHARED_POOL_ADVICE
GV$SHARED_POOL_RESERVED
GV$SHARED_SERVER
GV$SHARED_SERVER_MONITOR
GV$SORT_SEGMENT
GV$SORT_USAGE
GV$SPPARAMETER
GV$SQL
GV$SQLAREA
GV$SQLAREA_PLAN_HASH
GV$SQLSTATS
GV$SQLTEXT
GV$SQLTEXT_WITH_NEWLINES
GV$SQL_BIND_DATA
GV$SQL_BIND_METADATA
GV$SQL_CURSOR
GV$SQL_JOIN_FILTER
GV$SQL_OPTIMIZER_ENV
GV$SQL_PLAN
GV$SQL_PLAN_STATISTICS
GV$SQL_PLAN_STATISTICS_ALL
GV$SQL_REDIRECTION
GV$SQL_SHARED_CURSOR
GV$SQL_SHARED_MEMORY
GV$SQL_WORKAREA
GV$SQL_WORKAREA_ACTIVE
GV$SQL_WORKAREA_HISTOGRAM
GV$STANDBY_APPLY_SNAPSHOT
GV$STANDBY_LOG
GV$STATISTICS_LEVEL
GV$STATNAME
GV$STREAMS_APPLY_COORDINATOR
GV$STREAMS_APPLY_READER
GV$STREAMS_APPLY_SERVER
GV$STREAMS_POOL_ADVICE
GV$STREAMS_TRANSACTION
GV$SUBCACHE
GV$SYSAUX_OCCUPANTS
GV$SYSMETRIC
GV$SYSMETRIC_HISTORY
GV$SYSMETRIC_SUMMARY
GV$SYSSTAT
GV$SYSTEM_CURSOR_CACHE
GV$SYSTEM_EVENT
GV$SYSTEM_FIX_CONTROL
GV$SYSTEM_PARAMETER2
GV$SYSTEM_PARAMETER
GV$SYSTEM_WAIT_CLASS
GV$SYS_OPTIMIZER_ENV
GV$SYS_TIME_MODEL
GV$TABLESPACE
GV$TEMPFILE
GV$TEMPORARY_LOBS
GV$TEMPSTAT
GV$TEMP_CACHE_TRANSFER
GV$TEMP_HISTOGRAM
GV$TEMP_PING
GV$THREAD
GV$THRESHOLD_TYPES
GV$TIMER
GV$TIMEZONE_FILE
GV$TIMEZONE_NAMES
GV$TRANSACTION
GV$TRANSACTION_ENQUEUE
GV$TRANSPORTABLE_PLATFORM
GV$TSM_SESSIONS
GV$TYPE_SIZE
GV$UNDOSTAT
GV$VERSION
GV$VPD_POLICY
GV$WAITCLASSMETRIC
GV$WAITCLASSMETRIC_HISTORY
GV$WAITSTAT
GV$WALLET
GV$XML_AUDIT_TRAIL
GV$_LOCK1
GV$_LOCK
GV$_RESUMABLE2
GV$_SEQUENCES
V$ACCESS
V$ACTIVE_INSTANCES
V$ACTIVE_SERVICES
V$ACTIVE_SESSION_HISTORY
V$ACTIVE_SESS_POOL_MTH
V$ADVISOR_PROGRESS
V$ALERT_TYPES
V$ARCHIVE
V$ARCHIVED_LOG
V$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP
V$ARCHIVE_PROCESSES
V$ASM_ALIAS
V$ASM_CLIENT
V$ASM_DISK
V$ASM_DISKGROUP
V$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT
V$ASM_FILE
V$ASM_OPERATION
V$ASM_TEMPLATE
V$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP
V$AW_CALC
V$AW_LONGOPS
V$AW_OLAP
V$AW_SESSION_INFO
V$BACKUP
V$BACKUP_ASYNC_IO
V$BACKUP_CORRUPTION
V$BACKUP_DATAFILE
V$BACKUP_DEVICE
V$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$BACKUP_SPFILE
V$BACKUP_SYNC_IO
V$BGPROCESS
V$BH
V$BLOCKING_QUIESCE
V$BLOCK_CHANGE_TRACKING
V$BSP
V$BUFFERED_PUBLISHERS
V$BUFFERED_QUEUES
V$BUFFERED_SUBSCRIBERS
V$BUFFER_POOL
V$BUFFER_POOL_STATISTICS
V$CIRCUIT
V$CLASS_CACHE_TRANSFER
V$CLASS_PING
V$CLIENT_STATS
V$CLUSTER_INTERCONNECTS
V$CONFIGURED_INTERCONNECTS
V$CONTEXT
V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION
V$CR_BLOCK_SERVER
V$CURRENT_BLOCK_SERVER
V$DATABASE
V$DATABASE_BLOCK_CORRUPTION
V$DATABASE_INCARNATION
V$DATAFILE
V$DATAFILE_COPY
V$DATAFILE_HEADER
V$DATAGUARD_CONFIG
V$DATAGUARD_STATS
V$DATAGUARD_STATUS
V$DATAPUMP_JOB
V$DATAPUMP_SESSION
V$DBFILE
V$DBLINK
V$DB_CACHE_ADVICE
V$DB_OBJECT_CACHE
V$DB_PIPES
V$DB_TRANSPORTABLE_PLATFORM
V$DELETED_OBJECT
V$DISPATCHER
V$DISPATCHER_CONFIG
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$ENCRYPTION_WALLET
V$ENQUEUE_LOCK
V$ENQUEUE_STAT
V$ENQUEUE_STATISTICS
V$EVENTMETRIC
V$EVENT_HISTOGRAM
V$EVENT_NAME
V$EXECUTION
V$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS
V$FILEMETRIC
V$FILEMETRIC_HISTORY
V$FILESPACE_USAGE
V$FILESTAT
V$FILE_CACHE_TRANSFER
V$FILE_HISTOGRAM
V$FILE_PING
V$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_LOGFILE
V$FLASHBACK_DATABASE_STAT
V$FLASH_RECOVERY_AREA_USAGE
V$GCSHVMASTER_INFO
V$GCSPFMASTER_INFO
V$GC_ELEMENT
V$GC_ELEMENTS_WITH_COLLISIONS
V$GES_BLOCKING_ENQUEUE
V$GES_ENQUEUE
V$GLOBALCONTEXT
V$GLOBAL_BLOCKED_LOCKS
V$GLOBAL_TRANSACTION
V$HS_AGENT
V$HS_PARAMETER
V$HS_SESSION
V$HVMASTER_INFO
V$INDEXED_FIXED_COLUMN
V$INSTANCE
V$INSTANCE_CACHE_TRANSFER
V$INSTANCE_LOG_GROUP
V$INSTANCE_RECOVERY
V$JAVAPOOL
V$JAVA_LIBRARY_CACHE_MEMORY
V$JAVA_POOL_ADVICE
V$LATCH
V$LATCHHOLDER
V$LATCHNAME
V$LATCH_CHILDREN
V$LATCH_MISSES
V$LATCH_PARENT
V$LIBRARYCACHE
V$LIBRARY_CACHE_MEMORY
V$LICENSE
V$LOADISTAT
V$LOADPSTAT
V$LOCK
V$LOCKED_OBJECT
V$LOCKS_WITH_COLLISIONS
V$LOCK_ACTIVITY
V$LOCK_ELEMENT
V$LOCK_TYPE
V$LOG
V$LOGFILE
V$LOGHIST
V$LOGMNR_CALLBACK
V$LOGMNR_DICTIONARY
V$LOGMNR_DICTIONARY_LOAD
V$LOGMNR_LATCH
V$LOGMNR_LOGFILE
V$LOGMNR_LOGS
V$LOGMNR_PARAMETERS
V$LOGMNR_PROCESS
V$LOGMNR_SESSION
V$LOGMNR_STATS
V$LOGMNR_TRANSACTION
V$LOGSTDBY
V$LOGSTDBY_PROCESS
V$LOGSTDBY_STATS
V$LOGSTDBY_TRANSACTION
V$LOG_HISTORY
V$MANAGED_STANDBY
V$MAP_COMP_LIST
V$MAP_ELEMENT
V$MAP_EXT_ELEMENT
V$MAP_FILE
V$MAP_FILE_EXTENT
V$MAP_FILE_IO_STACK
V$MAP_LIBRARY
V$MAP_SUBELEMENT
V$MAX_ACTIVE_SESS_TARGET_MTH
V$METRIC
V$METRICGROUP
V$METRICNAME
V$METRIC_HISTORY
V$MTTR_TARGET_ADVICE
V$MUTEX_SLEEP
V$MUTEX_SLEEP_HISTORY
V$MVREFRESH
V$MYSTAT
V$NLS_PARAMETERS
V$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY
V$OBSOLETE_PARAMETER
V$OFFLINE_RANGE
V$OPEN_CURSOR
V$OPTION
V$OSSTAT
V$PARALLEL_DEGREE_LIMIT_MTH
V$PARAMETER2
V$PARAMETER
V$PARAMETER_VALID_VALUES
V$PGASTAT
V$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE_HISTOGRAM
V$PQ_SESSTAT
V$PQ_SLAVE
V$PQ_SYSSTAT
V$PQ_TQSTAT
V$PROCESS
V$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER
V$PROXY_ARCHIVEDLOG
V$PROXY_DATAFILE
V$PWFILE_USERS
V$PX_BUFFER_ADVICE
V$PX_PROCESS
V$PX_PROCESS_SYSSTAT
V$PX_SESSION
V$PX_SESSTAT
V$QUEUE
V$QUEUEING_MTH
V$RECOVERY_FILE_DEST
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_PROGRESS
V$RECOVERY_STATUS
V$RECOVER_FILE
V$REPLPROP
V$REPLQUEUE
V$REQDIST
V$RESERVED_WORDS
V$RESOURCE
V$RESOURCE_LIMIT
V$RESTORE_POINT
V$RESUMABLE
V$RFS_THREAD
V$RMAN_BACKUP_TYPE
V$RMAN_CONFIGURATION
V$RMAN_ENCRYPTION_ALGORITHMS
V$RMAN_OUTPUT
V$RMAN_STATUS
V$ROLLSTAT
V$ROWCACHE
V$ROWCACHE_PARENT
V$ROWCACHE_SUBORDINATE
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH
V$RSRC_SESSION_INFO
V$RULE
V$RULE_SET
V$RULE_SET_AGGREGATE_STATS
V$SCHEDULER_RUNNING_JOBS
V$SEGSTAT
V$SEGSTAT_NAME
V$SERVICEMETRIC
V$SERVICEMETRIC_HISTORY
V$SERVICES
V$SERVICE_EVENT
V$SERVICE_STATS
V$SERVICE_WAIT_CLASS
V$SERV_MOD_ACT_STATS
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSION_CURSOR_CACHE
V$SESSION_EVENT
V$SESSION_FIX_CONTROL
V$SESSION_LONGOPS
V$SESSION_OBJECT_CACHE
V$SESSION_WAIT
V$SESSION_WAIT_CLASS
V$SESSION_WAIT_HISTORY
V$SESSMETRIC
V$SESSTAT
V$SESS_IO
V$SESS_TIME_MODEL
V$SES_OPTIMIZER_ENV
V$SGA
V$SGAINFO
V$SGASTAT
V$SGA_CURRENT_RESIZE_OPS
V$SGA_DYNAMIC_COMPONENTS
V$SGA_DYNAMIC_FREE_MEMORY
V$SGA_RESIZE_OPS
V$SGA_TARGET_ADVICE
V$SHARED_POOL_ADVICE
V$SHARED_POOL_RESERVED
V$SHARED_SERVER
V$SHARED_SERVER_MONITOR
V$SORT_SEGMENT
V$SORT_USAGE
V$SPPARAMETER
V$SQL
V$SQLAREA
V$SQLAREA_PLAN_HASH
V$SQLSTATS
V$SQLTEXT
V$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_DATA
V$SQL_BIND_METADATA
V$SQL_CURSOR
V$SQL_JOIN_FILTER
V$SQL_OPTIMIZER_ENV
V$SQL_PLAN
V$SQL_PLAN_STATISTICS
V$SQL_PLAN_STATISTICS_ALL
V$SQL_REDIRECTION
V$SQL_SHARED_CURSOR
V$SQL_SHARED_MEMORY
V$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE
V$SQL_WORKAREA_HISTOGRAM
V$STANDBY_APPLY_SNAPSHOT
V$STANDBY_LOG
V$STATISTICS_LEVEL
V$STATNAME
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER
V$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION
V$SUBCACHE
V$SYSAUX_OCCUPANTS
V$SYSMETRIC
V$SYSMETRIC_HISTORY
V$SYSMETRIC_SUMMARY
V$SYSSTAT
V$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT
V$SYSTEM_FIX_CONTROL
V$SYSTEM_PARAMETER2
V$SYSTEM_PARAMETER
V$SYSTEM_WAIT_CLASS
V$SYS_OPTIMIZER_ENV
V$SYS_TIME_MODEL
V$TABLESPACE
V$TEMPFILE
V$TEMPORARY_LOBS
V$TEMPSTAT
V$TEMP_CACHE_TRANSFER
V$TEMP_HISTOGRAM
V$TEMP_PING
V$THREAD
V$THRESHOLD_TYPES
V$TIMER
V$TIMEZONE_FILE
V$TIMEZONE_NAMES
V$TRANSACTION
V$TRANSACTION_ENQUEUE
V$TRANSPORTABLE_PLATFORM
V$TSM_SESSIONS
V$TYPE_SIZE
V$UNDOSTAT
V$VERSION
V$VPD_POLICY
V$WAITCLASSMETRIC
V$WAITCLASSMETRIC_HISTORY
V$WAITSTAT
V$WALLET
V$XML_AUDIT_TRAIL


Regards
Michel

[Updated on: Wed, 04 May 2011 01:26]

Report message to a moderator

Previous Topic: extract tablespace privilege
Next Topic: need to reopen & drop the database
Goto Forum:
  


Current Time: Fri Nov 29 06:47:26 CST 2024