Re: Which dict. table stores the Block usage details for every segment (w/o. analyze table/index) ?

Hi Mehul,

   Actually it's pretty simple.

   I thought of two ways which I listed below:

1. Check the rowid of each row in your table. That tells u straightaway the file number which u join with v$datafile and find out in which file/disk your row is.
2. The other way is to go through dba_segments to find out the segment details and then check against dba_extents which gives you the file number (again join with v$datafile) and the starting and ending block numbers for that extent.

Hope this helps,
Chetan
DBA,
Cambridge Technology Partners,
Bangalore, India

The views expressed here are my personal views and do not reflect those of Cambridge Technology Partners.

Mehul Zaveri wrote in message <7s7ag5$6c28_at_news.emirates.net.ae>...
>Hai all,
>Can we find out w/o. using analyze command, exact block usage of segment?
>Based on output, we can make decision of reorganizing BIG tables. Any
ideas?
>
>Kind regards,
>Mehul Zaveri,
>Oracle DBA
>
>
>
Received on Tue Sep 21 1999 - 06:47:36 CDT