| Sudden degrade in Datapump performance [message #686787] |
Thu, 05 January 2023 19:26  |
sekharsomu
Messages: 72
Registered: December 2008
|
Member |
|
|
We have an issue with data pump performance until recently our Expdp used to take 20 min and impdp would take 5:30 hrs both happen in different schemas and the same database
but from a month or so we start to have bad days on and off where it started taking expdp for upto 45-50 min and impdp ran upto 9 hrs but from the last 9 days this has become standard
Please note that there are no significant changes to DB recently the last was on first week of oct even then the release cycle is a minor change. we already gather stats on a daily basis
So we approached oracle they point MML Backup piece waits are high on bad days compared to good day.
We have tried the export in a different time that doesn't overlap with tape backup but we still see the export taking around 45 min. We have been following up with Oracle
But can you guy please? let me know if there is elsewhere i need to look to get this problem fixed as this is impacting our downstream scheduled
Notes: Unfortunately i cannot put logs due to ND policies but these is regular impdp and expdp scripts nothing fancy and they always complete successfully it never fails only the time is impacted only thing noteworthy is we do is expdp using flashback_scn
[Updated on: Thu, 05 January 2023 19:27] Report message to a moderator |
|
|
|
| Re: Sudden degrade in Datapump performance [message #686788 is a reply to message #686787] |
Fri, 06 January 2023 01:47  |
John Watson
Messages: 8944
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you can post a few Statspack or AWR reports for good runs and bad runs, one might be able to see what is going on. Be sure to generate them now, before your snapshots get purged.
It seems that Support is suggesting that your backups are interfering with the export/import, which is unlikely but I suppose it could be possible.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
