SQL Performance (MOSC)

MOSC Banner

Set of SQL statements are slow/hung -- Going into endless loop with wait event : latch: cache buffer

edited Dec 22, 2021 4:46PM in SQL Performance (MOSC) 6 commentsAnswered

DB Version:11.2.0.3

Platform : Red Hat Enterprise Linux Server release 5.8 (Tikanga)

A particular set of SQL statements are slow/hung in the database. These statements differentiates from each other in terms of number of columns selection from front end by the customer and the values of the bind variables.

Below is the one of the example of the SQL statement which is not returning data back to application..

SQL Text  : SELECT

          T21.CONFLICT_ID,

          T21.LAST_UPD,

          T21.CREATED,

          T21.LAST_UPD_BY,

          T21.CREATED_BY,

          T21.MODIFICATION_NUM,

          T21.ROW_ID,

          T21.LAST_UPD,

          T21.DOCNUM_GNRTD_FLG,

          T21.X_NEW_SUBMIT_DT,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center