Database Tuning (MOSC)

MOSC Banner

Cache Buffer chains on Index

edited Nov 2, 2017 5:01AM in Database Tuning (MOSC) 2 commentsAnswered

Hi Team,

During peak business hours I am getting cache buffer chains issue.

I did some R&D and found that each of the session and sqlid is leading me to one index which is a normal BTree index.

How can I resolve the issue?

During non business hours the query is executing in seconds.

Output

STATE                            BLOCK_CLASS                      OBJECT_TYPE         object                                          TCH  MODE_HELD DIRTY                            TEMP                             PING

-------------------------------- -------------------------------- ------------------- ---------------------------------------- ---------- ---------- -------------------------------- -------------------------------- --------------------------------

STALE                            DIRECT

-------------------------------- --------------------------------

FLG_LRUFLG

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

        DQ

----------

scur                             data block                       INDEX               USERNAME.INDEX_NAME   31          0 N                                N                                N

N                                N

0:8

Thank you

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