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)