Hello Everyone,
We are observing Flushes during Checkpoint. Tried increasing APW but no improvement.
The BI cluster size is 48MB and the time difference between checkpoints is around 4 Mins.
Should Increasing the BI Cluster size resolve the issue?
Thank you,
Vageesh
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...
Hello Everyone,
Is there is way of identifying the User / Process causing BKSH?
Thank You Tom for PROTOP
From _connect-wait1 we have the users waiting for BKSH. If we could get information about the User causing one, then the query can be tuned to avoid Large Waits for other users.
Thanks...
Hello Everyone,
Yesterday one of our DB was brought down abnormally. The following information was present in the LOG file:
SYSTEM ERROR: Memory Violation
User 650 Died with holding Latch id 2
Begin Abnormal ShutDown
Scanning through the LOG file shows that User 650 had logged in at...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.