RE: check high wate mark on tables??
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 12:38:48 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of dba1 mcc
Sent: Thursday, May 17, 2007 10:54 AM
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
