There are two database tasks DATABASE_SYS.EXECUTE_ANALYZE_SCHEMA__ and DATABASE_SYS.REBUILD_INDEXES__ that should be scheduled.
These are not automatically scheduled in the installations i have (IFS Cloud 21R2). Should they have been automatically scheduled on install of the environment?
What is the recommended settings for these two scheduled tasks when scheduling them?
Hi,
No, they should not be scheduled by default as there is a danger that they might start at the wrong time. If a customer has a professional DBA, they probably prefer to do the analyze and rebuild using their own tools or scripts.
But index should be rebuild if needed (in fact it is hard to say when that is… the validate index BG job will probably be more aggressive than necessary)- the frequency depends a bit on transaction rates in the DB or rather the update and delete rate as it often updates and deletes that skews indexes.
Important to consider is that both analyze and rebuild will partly lock the indexes when analyzing and rebuilding them. Therefor the BG jobs preferable should run then there is very low load on the system.
/Henrik
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.