Compiling schema objects taking a long time
Hello
We are on 19.21 database in Exadata X7
During application deployments AFTER the deployment we compile schema objects for various application schemas using this
EXEC DBMS_UTILITY.compile_schema(schema => 'SCHEMA NAME',compile_all => FALSE);
we have noticed some of the schemas takes a long time (10 - 15 minutes) and some dont
What is oracle's recommendation to compile the application schema objects in the most effecient way. Should we use DBMS_UTILITY ? or something else?
If we should use DBMS_UTILITY.compile any suggestions on how to determine what is taking so long for a particular schema compile?
Thanks in advance for your kind guidance and help