Can the task "process_flow log cleanup" be made flexible, instead of being started every 5 minutes.
If the cleanup has run and the tables have been cleaned, this does not have to happen again after 5 minutes, this can also be done once a day. In our situation, it is a comparatively expensive query.
+23As a potential solution, you could consider rebuilding indexes as discussed here:
I read the article "High database resource usage for process flow log cleanup" and we also do automatic maintenance on it.We have several IAMs (10) running on a server and want to relieve the system as much as possible and find it pointless to start this task every 5 minutes.Below is a 1-day capture by our performance analyzer, which tops the list of busiest wait times
+23
+5+23+23+23From 2024.3, you will be able to view all IAM system flows and create custom schedules for some.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
