Database Administration (MOSC)

MOSC Banner

datapatch - slow scripts

For a long time we're looking at a datapatch which is running slow on our 19.15 databases (Solaris Sparc) and it seems that the scripts that run slow within this tool, are all related to datapump.

Now, datapump on itself also runs slow, and that is a separate issue, but it looks like these 2 issues have the same cause.


All separate scripts run max. 20 seconds, except:

for Root

>>> catmetviews.sql done (338 secs)

>>> catmetgrant1.sql done (196 secs)

>>> catmetgrant2.sql done (199 secs)

>>> catmet2.sql done (485 secs)

>>> entire dpload done (1275 secs)


for PDB:

>>> catmetviews.sql done (682 secs)

>>> catmetgrant1.sql done (255 secs)

>>> catmetgrant2.sql done (217 secs)

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