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)
0