Databases Reference
In-Depth Information
F
WRITES
: The number of bytes written to the rollback segment
F
XACTS
: The number of active transactions
F
GETS
The number of header gets
F
WAITS
: The number of header waits
F
STATUS
: The rollback segment status, it can be
ONLINE
,
OFFLINE
,
PENDING
OFFLINE
, or
FULL
V$ROWCACHE
This view displays statistics about the data dictionary activity.
Fields
The most relevant view fields are as follows:
F
PARAMETER
: The name of the initialization parameter that determines
the number of entries in the data dictionary cache
F
GETS
: The total number of requests for information on the data object
F
GETMISSES
: The number of data requests resulting in cache misses
F
MODIFICATIONS
: The number of inserts, updates, and deletions
F
FLUSHES
: The number of times flushed to disk
V$SESSION
This view displays information on each current session.
Fields
The most relevant view fields are as follows:
F
SID
: The session identifier
F
SADDR
: The session address
F
SERIAL#
: The session serial number
F
PROCESS
: The operating system client process ID
F
PADDR
: The address of the process that owns this session
F
AUDSID
: The auditing session ID