In its third annual report the Commission recommended a net salary scale for General Service staff at that duty station involving reductions averaging on a weighted basis 17.4 per cent (UN document A/32/30, Chapter IV and Annex III), and made a number of related recommendations.
V$PROCESS displays information about the currently active processes. While the LATCHWAIT column indicates what latch a process is waiting for, the LATCHSPIN column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.
V$ACTIVE_SESSION_HISTORY displays sampled session activity in the database. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class.Refer to the V$EVENT_NAME view for more information on wait classes.This view contains one row for each active session per sample and returns the latest session sample rows first. A majority of the columns describing the session in the active session history are present in the V$SESSION view. majority of the columns describing the session in the active session history are present in the V$SESSION view.