Home | Previous Page | Next Page   Monitoring Database Server Performance > Monitoring Database Server Resources >

Monitoring Virtual Processor Activity

For information about using monitoring information to tune virtual processors, see the following sections:

View virtual-processor thread information from ISA or execute the following onstat command options.

onstat -g Option
Description
xctl onstat -g sch
Lists the number of semaphore operations, spins, and busy waits for each VP.
xctl onstat -g spi
Lists longspins, which are spin locks that virtual processors have spun more than 10,000 times in order to acquire a lock.

To reduce longspins, reduce the number of virtual processors or reduce the load on the computer. On some platforms, you can use the no-age or processor affinity features.

xctl onstat -g wst
Displays wait statistics.
xctl onstat -g iov
Displays statistics for disk I/O by virtual processor.

The higher the number in the wakeups column, the busier the AIO virtual processors are.

xctl onstat -g glo
Lists global multithreading information.

This listing includes CPU-use information about virtual processors, the total number of sessions, and other multithreading global counters.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]