Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center