Spatial DBA - Oracle and ArcSDE

Oracle DBA Tips

2010-12-11T14:24:00.000-08:00

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.

SESSIONS

2010-07-29T14:10:00.001-07:00

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.

Property	Description
Parameter type	Integer
Default value	Derived: (1.1 * PROCESSES) + 5
Modifiable	No
Range of values	1 to 2³¹
Basic	Yes

SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.

Oracle uses the default value of this parameter as its minimum. Values between 1 and the default do not trigger errors, but Oracle ignores them and uses the default instead.

The default values of the ENQUEUE_RESOURCES and TRANSACTIONS parameters are derived from SESSIONS. Therefore, if you increase the value of SESSIONS, you should consider whether to adjust the values of ENQUEUE_RESOURCES and TRANSACTIONS as well. (Note that ENQUEUE_RESOURCES is obsolete as of Oracle Database 10g release 2 (10.2).)

In a shared server environment, the value of PROCESSES can be quite small. Therefore, Oracle recommends that you adjust the value of SESSIONS to approximately 1.1 * total number of connections.

Oracle initializatoin parameters

V$TRANSACTION_ENQUEUE

2010-07-29T14:09:00.000-07:00

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$TRANSACTION_ENQUEUE displays locks owned by transaction state objects.

Column	Datatype	Description
ADDR	RAW(4 \| 8)	Address of lock state object
KADDR	RAW(4 \| 8)	Address of lock
SID	NUMBER	Identifier for session holding or acquiring the lock
TYPE	VARCHAR2(2)	Type of lock. TX indicates transaction enqueue.
ID1	NUMBER	Lock identifier #1 (depends on type)
ID2	NUMBER	Lock identifier #2 (depends on type)
LMODE	NUMBER	Lock mode in which the session holds the lock: 0 - none 1 - null (NULL) 2 - row-S (SS) 3 - row-X (SX) 4 - share (S) 5 - S/Row-X (SSX) 6 - exclusive (X)
REQUEST	NUMBER	Lock mode in which the process requests the lock: 0 - none 1 - null (NULL) 2 - row-S (SS) 3 - row-X (SX) 4 - share (S) 5 - S/Row-X (SSX) 6 - exclusive (X)
CTIME	NUMBER	Time since current mode was granted
BLOCK	NUMBER	The lock is blocking another lock

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)

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

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

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

Spatial DBA - Oracle and ArcSDE

Oracle DBA Tips

SESSIONS

V$TRANSACTION_ENQUEUE

How to read Unix file /etc/group

How to read UNIX file /etc/passwd

/etc/passwd file permission

Your password is stored in /etc/shadow file

V$DISPATCHER_CONFIG

V$ENCRYPTION_WALLET

V$FILE_HISTOGRAM

V$DB_PIPES

V$FILEMETRIC

V$FILEMETRIC_HISTORY

V$BACKUP_REDOLOG

1. The corresponding RMAN catalog view is RC_BACKUP_REDOLOG.

V$BACKUP_PIECE_DETAILS

1. The corresponding RMAN catalog view is RC_BACKUP_PIECE_DETAILS.

V$BACKUP_SET_SUMMARY

1. The corresponding RMAN catalog view is RC_BACKUP_SET_SUMMARY.

V$BACKUP_SET_DETAILS

1. The corresponding RMAN catalog view is RC_BACKUP_SET_DETAILS.

V$BACKUP_SET

1. The corresponding RMAN catalog view is RC_BACKUP_SET.

V$BACKUP_DATAFILE_SUMMARY

1. The corresponding RMAN catalog view is RC_BACKUP_DATAFILE_SUMMARY.

V$BACKUP_DATAFILE_DETAILS

1. The corresponding RMAN catalog view is RC_BACKUP_DATAFILE_DETAILS.

V$BACKUP_COPY_SUMMARY

1. The corresponding RMAN catalog view is RC_BACKUP_COPY_SUMMARY.