Enterprise Edition Home |
Express Edition Home |
Previous Page | Next Page Performance Monitoring and the Tools You Use > Monitoring Database Server Resources >
The following database server resources impact CPU utilization:
- Threads
- Network communications
- Virtual processors
Use the following onstat -g arguments to monitor
threads.
- Argument
- Description
- act
- Displays active threads
- ath
- Displays all threads
The sqlexec threads
represent portions of client sessions; the rstcb value corresponds
to the user field of the onstat -u command.
- rea
- Displays ready threads
- sle
- Displays all sleeping threads
- sts
- Displays maximum and current stack use per thread
- tpf tid
- Displays a thread profile for tid
If tid is 0, this argument displays profiles for all threads.
- wai
- Displays waiting threads, including all threads waiting on mutex or condition, or yielding
Use the following onstat -g arguments to monitor the
network.
- Argument
- Description
- ntd
- Displays network statistics by service
- ntt
- Displays network user times
- ntu
- Displays network user statistics
- qst
- Displays queue statistics
Use the following onstat -g arguments to monitor virtual
processors.
- Argument
- Description
- glo
- Displays global multithreading information, including CPU-use information
about virtual processors, the total number of sessions, and other
multithreading global counters
- sch
- Displays the number of semaphore operations, spins, and busy
waits for each VP
- spi
- Displays longspins, which are spin locks acquired by virtual processors
after they have spun more than 10,000 times.
To reduce longspins, reduce the number of virtual processors, reduce
the load on the computer, or, on some platforms, use the no-age or processor affinity features.
- wst
- Displays wait statistics
Enterprise Edition Home |
Express Edition Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]