You can find the asktom queries in the following link : http://www.oracle.com/technology/oramag/oracle/04-sep/o54asktom.html Go to the last paragraph. You also have a query to know what at the end of the datafile. But if you really need to shrink a datafile, you often have to do a reorg . HTH ________________________________________ On 03/05/2010 10:49, Stefano Cislaghi wrote: > Hi all, > > do you use any query or method to discover how much space you can save > on a datafile? I want to say...suppose to shrink your datafile, which > is the minimum size, according to the highest HWM position, you can > reach for your datafile? > > Which is the easiest way to achieve this? > > > Thanks > Ste > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l