Database Administration (MOSC)

MOSC Banner

many kqrCreateUsingSecondaryKey ocurrences

hi,

I have this RAC 4 nodes install, Oracle 19.16, and recently I have noticed many messages at alert.log file from 2 nodes :

2023-04-27T14:59:38.807803-03:00
PDBNSPRD(3):KQR: cid 8 bucket 27994 marked HOT (kqrCreateUsingSecondaryKey)
PDBNSPRD(3):KQR: cid 8 bucket 30658 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:39.457400-03:00
PDBNSPRD(3):KQR: cid 8 bucket 16509 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:39.704883-03:00
PDBNSPRD(3):KQR: cid 8 bucket 18928 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:39.711365-03:00
PDBNSPRD(3):KQR: cid 8 bucket 21739 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:40.573608-03:00
PDBNSPRD(3):KQR: cid 8 bucket  6373 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:41.194078-03:00
PDBNSPRD(3):KQR: cid 8 bucket  4635 marked HOT (kqrCreateUsingSecondaryKey)
2023-04-27T14:59:41.202595-03:00
PDBNSPRD(3):KQR: cid 8 bucket 29210 marked HOT (kqrCreateUsingSecondaryKey)

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