Thursday, March 27, 2008

Shared Server Status

The STATUS column of the V$SHARED_SERVER column gives useful informationabout WAIT status.

WAIT(ENQ) status tells the DBA that the user is waiting for a lockresource, and in rare cases, acts as an alert for a deadlock situation.

WAIT(COMMON) indicated the shared servers running on this instance arewaiting for requests to process. Hence, this servers is not busy.

WAIT(RECEIVE) indicates the shared server becomes dedicated