Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: script for table extent space used
Tim,
Sorry. I overlooked you are mentioning table-level.
Reid
Reid Lai wrote:
> DBA_FREE_SPACE
>
> Tim_at_nospam.com wrote:
>
>> Where can I get a script that will tell me how much of the extent in a >> table (not tablespace) is being used, e.g. if I have a 6gb USER_1 >> tablespace which has a table named JOBS of only 1 extent of 100mb then >> how much of 100mb is being used up? TIA >>