Tuesday, December 22, 2009

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

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

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, ... < 221 ms, < 222 ms, and >= 222 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

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

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

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

Last updated: 2009-12-22 Tuesday