Oracle SQL Forum
May I know that Is it recommended to do the mdf Shrink in production environment.
Kindly share your valuable views here.
Thanks in advance.
Shrinking the database is not recommended as it will lead to the fragmentation.
If it is needed then you can do it in non_business hours. see how much is allocated and how much actually is being used based on this you can set size to shrink file.
1. Please check the version first.2. Make sure whether there's LOB 3. Go by chunks,never do shrink in one shot.. 4. Purge any old data if present before shrink. purging data will also leads to ldf file growth, so be careful on it, if you have logshipping configured make sure there is enough space on secondary server for the trn files.
Rebuild after shrink without fail. This should be done in non business hours.
Sign up for STechies
Ask Question From Our Experts