V$DISPATCHER_CONFIG

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

V$DISPATCHER_CONFIG displays information about the dispatcher configurations and their attributes.

Column	Datatype	Description
CONF_INDX	NUMBER	Zero-based index of the DISPATCHERS configuration
NETWORK	VARCHAR2(128)	Network protocol or listening address of dispatchers (may be truncated)
DISPATCHERS	NUMBER	Number of dispatchers to maintain for the configuration
CONNECTIONS	NUMBER	Maximum number of concurrent connections per dispatcher
SESSIONS	NUMBER	Maximum number of concurrent sessions per dispatcher
POOL	VARCHAR2(4)	Indicates whether Connection Pooling is on: IN OUT BOTH OFF
TICKS	NUMBER	Tick size (in seconds) for Connection Pooling timeout
INBD_TIMOUT	NUMBER	Timeout duration (in ticks) for pooled inbound connections
OUTBD_TIMOUT	NUMBER	Timeout duration (in ticks) for pooled outbound connections
MULTIPLEX	VARCHAR2(4)	Indicates whether Session Multiplexing is on: IN OUT BOTH OFF
LISTENER	VARCHAR2(1200)	Listeners to register dispatchers with (may be truncated)
SERVICE	VARCHAR2(128)	Service names supported (may be truncated)

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday

V$ENCRYPTION_WALLET

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

V$ENCRYPTION_WALLET displays information on the status of the wallet and the wallet location for transparent data encryption.

Column	Datatype	Description
WRL_TYPE	VARCHAR2(20)	Type of the wallet resource locator (for example, FILE)
WRL_PARAMETER	VARCHAR2(4000)	Parameter of the wallet resource locator (for example, absolute filename if WRL_TYPE = FILE)
STATUS	VARCHAR2(9)	Status of the wallet: OPEN CLOSED UNDEFINED

Note:

1.       Is there any view to tell if wallet is opened or not? Use V$ENCRYPTION_WALLET, which is a feature available in 10.2.0.4 and 11g database versions.

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday

V$FILE_HISTOGRAM

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

V$FILE_HISTOGRAM displays a histogram of all synchronous single block reads on a per-file basis (for data files). The histogram has buckets of time intervals from < 1 ms, < 2 ms, < 4 ms, < 8 ms, ... < 2²¹ ms, < 2²² ms, and >= 2²² ms.

The histogram will not be filled unless the STATISTICS_LEVEL initialization parameter is set to ALL.

Column	Datatype	Description
FILE#	NUMBER	File number
SINGLEBLKRDTIM_MILLI	NUMBER	Amount of time the bucket represents (in milliseconds). If the duration = num, then this column represents waits of duration < num that are not included in any smaller bucket.
SINGLEBLKRDS	NUMBER	Number of waits of the duration belonging to the bucket of the histogram

Note:

The v$filestat view displays statistics per data file. This information can be skewed due to a couple of very large I/O waits, thus these waits might not be indicative of the system as a whole.

V$FILE_HISTOGRAM displays a histogram of all single block reads on a per-file basis. The histogram has buckets of time intervals from < 1 ms, < 2 ms, < 4 ms, < 8 ms, ... < 2^21 ms, < 2^22 ms, >= 2^22 ms. The histogram can be used to determine if the bottleneck is a regular or a unique problem. The frequency of each wait event versus the length of the wait events would be seen using the information in the v$file_histogram view.

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday

V$DB_PIPES

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

======================================================================

V$DB_PIPES displays the pipes that are currently represented in the shared pool for this instance.

Column	Datatype	Description
OWNERID	NUMBER	Owner ID of the owner (if this is a private pipe), else NULL
NAME	VARCHAR2(1000)	Name of the pipe (for example, SCOTT.PIPE)
TYPE	VARCHAR2(7)	Type of the pipe: PUBLIC PRIVATE
PIPE_SIZE	NUMBER	Amount of memory the pipe uses

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday

V$FILEMETRIC

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

V$FILEMETRIC displays values of file metrics for the most recent 10-minute interval. A history of the last one hour will be kept in the system.

Column	Datatype	Description
BEGIN_TIME	DATE	Begin time of the interval
END_TIME	DATE	End time of the interval
INTSIZE_CSEC	NUMBER	Interval size (in hundredths of a second)
FILE_ID	NUMBER	File number
CREATION_TIME	NUMBER	Timestamp of the file creation
AVERAGE_READ_TIME	NUMBER	Average file read time
AVERAGE_WRITE_TIME	NUMBER	Average file write time
PHYSICAL_READS	NUMBER	Number of physical reads
PHYSICAL_WRITES	NUMBER	Number of physical writes
PHYSICAL_BLOCK_READS	NUMBER	Number of physical block reads
PHYSICAL_BLOCK_WRITES	NUMBER	Number of physical block writes

Note:

1.       In Oracle10g metrics are automatically calculated based on basic statistics to track the rates of changes in the activity of the Database. Most of the metrics are calculated every 60 seconds. The following is a list of views to access metrics information:

·         V$SYSMETRIC

·         V$SESSMETRIC

·         V$FILEMETRIC

·         V$EVENTMETRIC

·         V$WAITCLASSMETRIC

·         V$METRICNAME

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday

V$FILEMETRIC_HISTORY

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


===============================================================

V$FILEMETRIC_HISTORY displays values of file metrics for all intervals in the last one hour.

Column	Datatype	Description
BEGIN_TIME	DATE	Begin time of the interval
END_TIME	DATE	End time of the interval
INTSIZE_CSEC	NUMBER	Interval size (in hundredths of a second)
FILE_ID	NUMBER	File number
CREATION_TIME	NUMBER	Timestamp of the file creation
AVERAGE_READ_TIME	NUMBER	Average file read time
AVERAGE_WRITE_TIME	NUMBER	Average file write time
PHYSICAL_READS	NUMBER	Number of physical reads
PHYSICAL_WRITES	NUMBER	Number of physical writes
PHYSICAL_BLOCK_READS	NUMBER	Number of physical block reads
PHYSICAL_BLOCK_WRITES	NUMBER	Number of physical block writes

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday