Hi All,
one expdp performance issue for last 2 weeks ..
One cron job will take expdp of full db daily
Previously it was taking less than 4hours to complete
Last two months it is running more than 9 hours to complete app team informed this recently
Total db size is 165 gb DB version 12.1.0.2
One schema with 140 gb out of which it contains 130gb lob data
we use parallel 4 but Parallel wont work for lob objects
All table stats were up to date
Seen awr before run during run and after run but it is normal