Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Performance Monitoring and the Tools You Use > Monitoring Database Server Resources >

Monitoring Resources That Impact CPU Utilization

The following database server resources impact CPU utilization:

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 ]