Shrink Datafiles – Adjusting HWM This below example is derived from “Shrinking datafiles” scripts from asktom.oracle.com Scenario:- Lets suppose the datafile size is 100m with autoexted upto maxsize 32gb. 1) Created a table 2) Inserted 50millions of rows with commit — Data file size extended from 100mb to 20gb. 3) performed so many DML’s — … Continue reading How to Shrink Datafiles – Adjusting HWM