3.2 Practical tuning ---------------- To tune your existing system you should [STUN72]: 1. Tune OS hardware and software (see chapter 5 below). 2. Identify performance bottelneck by querying the V$SESSION_WAIT view. This view lists events that cause session to wait: what each session is currently waiting for or what the session last waited for. 3. Determine teh cause of the bottleneck by analyzing the data in V$SESSION_WAIT. 4. Correct the problem.