Shared Flashcard Set

Details

Onstat Second Tier Performance Checks
Onstat Second Tier Performance Checks
8
Internet/New Media
Graduate
03/07/2012

Additional Internet/New Media Flashcards

 


 

Cards

Term
Prints active buffers.
Definition
onstat -b
Term
Prints active threads.
Definition
onstat -g act
Term
Prints virtual processors and their operating system processes (oninit processes). Prints virtual processor CPU use. On Windows, the virtual processors are operating system threads, and the values in the pid field are thread IDs.
Definition
onstat -g glo
Term
Prints Memory Grant Manager resource information.
Definition
onstat -g mgm
Term
Prints threads in the ready queue waiting for CPU resources.
Definition
onstat -g rea
Term
Prints shared-memory-segment statistics. This option shows
the number and size of shared-memory segments allocated to the database server.
Definition
onstat -g seg
Term
Prints waiting threads; all threads waiting on mutex, condition, or yielding.
Definition
onstat -g wai
Term
Prints active locks.
Definition
onstat -k
Supporting users have an ad free experience!