Oracle DB performance issues since 16.0_MP1

Products

• Data Loss Prevention Core Package

Issue/Introduction

We are seeing billions of transactions in our DB since upgrading to 16.0_MP1 yesterday, and our DBA is very concerned.

Environment

Release : 16.0 MP1

Cause

This is the statement that is running on the Oracle side:

DELETE FROM AgentEvent WHERE EventDate <= timestamp'2022-12-23 10:04:31.463'

 

Resolution

From Dev

16.0 MP1 has optimized agent deletion code, and the removal of these records should be much faster now to prevent the disk from filling with stagnant records. 

If the customer had a large backlog of events you could see an above-average load until Oracle catches up.

 

In this case, it took approximately 4 days to catch up.

Now you can see daily agent events build, and nightly they delete, but it has leveled out since the backlog was caught up./