Hello Everyone,
We are facing intermittent performance issue with one of our database. ProTop screen indicates "Latch Waits" to be large (around 4000). Reads on one table are also huge. Please advice.
Details:
Version 9.1E / -B 250000 / -spin 30000 / -aibufs & -bibufs 100 each / AIW & BIW running / APW 14
Tried increasing -spin but no improvement.
Thank You,
Vageesh
We are facing intermittent performance issue with one of our database. ProTop screen indicates "Latch Waits" to be large (around 4000). Reads on one table are also huge. Please advice.
Details:
Version 9.1E / -B 250000 / -spin 30000 / -aibufs & -bibufs 100 each / AIW & BIW running / APW 14
Tried increasing -spin but no improvement.
Thank You,
Vageesh