Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does shrinking huge tablespace improves performance

supersenFeb 16 2022

Hi
Recently we have deleted multiple records from db which is 1TB size.
I ran segment advisor and i got almost 200GB free if i shrinking tablespace.
( Oracle version is 19c and exadata env)
Please advise does shrinking tablespace of 1TB and we get 200gb space really have any performance improvement in the db
Please advise

SUpersen

Comments
Post Details
Added on Feb 16 2022
2 comments
373 views