I think I am not clear in my question. I want block usage. i.e. How much %
of each block is free (remember pctfree, pctused) in a given segment and how
much room does it have (or doesn;t have) to fillup of more rows including
the deatils of chained/migrated rows if any.
Chetan Wagle <cwagle_at_ctp.com> wrote in message
news:7s7r5v$oqs$1_at_herald.ctp.com...
> 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 - 09:37:48 CDT
