Search results

  1. V

    Checkpoint Flushes

    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
  2. V

    DB Performance Issue - Latch Waits

    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...
  3. V

    User / Process Causing BKSH

    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...
  4. V

    Db abnormal shutdown

    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...
Top