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
