RE: check high wate mark on tables??

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 17 May 2007 12:38:48 -0400
Message-ID: <01de01c798a1$d911af80$1100a8c0@rsiz.com>

you mean like:

select owner,segment_name, file_id, block_id from dba_extents
where file_id, block_id in (select file_id, max(block_id) from dba_extents group by file_id);

?
I think that will tell you which segment is preventing further shrinkage.

You might want to list all the extents where block_id > {value_of_interest} for an individual file together with the owner and segment_name.

By the way, are you releasing storage on those truncates?

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Thursday, May 17, 2007 10:54 AM
To: oracle-l_at_freelists.org
Subject: check high wate mark on tables??

we have ORACLE on version 9.2.0.8. after we truncate sever tables, we still can NOT shrink data file due to high water mark did not change.

Does there has way to check which table after truncate high water mark no chage?

Thanks.  

---

---

Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 17 2007 - 11:38:48 CDT