Home
|
Previous Page
|
Next Page
Utility Reference
>
onstat: Monitor Database Server Operations
In This Chapter
Syntax
Statistics Culled from Source File
Interactive Execution
Continuous onstat Execution
Statistics Culled From Source File
Interactive Execution
Continuous onstat Execution
Onstat Output Header
Logs Full Subheader
No Options
The onstat -- Option
The onstat -a Option
The onstat -b Option
Example Output
Example Description
The onstat -c Options
The onstat -d Option
Example Output
Output Description
The onstat -D Option
Example Output
Output Description
The onstat -f Option
Output Description
The onstat -F Option
Example Output
Output Description
The onstat -g Monitoring Options
onstat -g act
Example Output
Output Description
onstat -g afr
pool name
|
session name
Example Output
Output Description
onstat -g all
onstat -g ath
Example Output
Output Description
onstat -g bus
Example Output
onstat -g bus_sm
Example Output
onstat -g con
Example Output
Output Description
onstat -g dic
table
Example Output
Output Description
onstat -g dll
Example Output
Output Description
onstat -g dsc
Example Output
Output Description
onstat -g env
Example Output
onstat -g ffr
pool name
|
session id
Example Output
Output Description
onstat -g glo
Example Output
Output Description
onstat -g hwm
Example output
Output Description
onstat -g ioa
Example Output
Output Description
onstat -g iob
Example Output
Output Description
onstat -g iof
Example Output
Output Description
onstat -g iog
Example Output
onstat -g ioq
queue name
Example Output
Output Description
onstat -g iov
Example Output
Output Description
onstat -g lmx
Example Output
Output Description
onstat -g mem
pool name
|
session id
Example Output
Output Description
onstat -g mut
session id
Example Output
Output Description
onstat -g nbm
Example Output
Output Description
onstat -g nsc
client_id
Example Output
Output Description
onstat -g nsd
Example Output
onstat -g nss
session id
onstat -g ntd
Example Output
onstat -g ntm
Example Output
onstat -g ntt
Example Output
onstat -g ntu
Example Output
onstat -g pos
Example Output
onstat -g ppf
partition number
| 0
onstat -g prc
Example Output
onstat -g rbm
Example Output
onstat -g rea
Example Output
onstat -g rgm
Example Output
onstat -g sch
Example Output
onstat -g seg
Example Output
onstat -g ses
session id
Example Output
Output Description
onstat -g sle
Example Output
onstat -g spi
onstat -g sql
session id
Example Output
Output Description
onstat -g stk
tid
Example Output
onstat -g sts
Example Output
onstat -g tmp
Example Output
onstat -g wmx
Example Output
onstat -g wst
onstat -g xmf
Example Output
onstat -g xmp [
query_id
]
Example Output
Output Description - XMP Query Segments
Output Description - XMP Query Operators
onstat -g xqs
query_id
Example Output
Output Description
The onstat -G Option
Example Output
Output Description
The onstat -i Option
The onstat -k Option
Example Output
Output Description
The onstat -K Option
The onstat -l Option
Example Output
Output Description
The onstat -m Option
Example Output
Output Description
The onstat -p Option
Example Output
Output Description
The onstat -P Option
Example Output
Output Description
The onstat -R Option
Example Output
Output Description
The onstat -s Option
Example Output
Output Description
The onstat -t Option
Example Output
Output Description
The onstat -u Option
Example Output
Output Description
The onstat -x Option
Example Output
Output Description
Using onstat -x With onstat-G and onmode -Z
The onstat -X Option
Example Output
Output Description
The onstat -z Option
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]