Re: LMT not listed in DBA_FREE_SPACE

From: NoResult <dj_noresult_at_hotmail.com>
Date: 18 Feb 2003 19:09:28 GMT
Message-ID: <Xns9326CCDCF4643djnoresult@194.109.133.20>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in news:v54vhm7rit0440_at_corp.supernews.com:

>
> "charlie cs" <cs3526(no-spam)@yahoo.com> wrote in message
> news:zQu4a.24438$Yv2.9754_at_nwrddc02.gnilink.net...

>> For locally managed tablespace, how could we know how much is used,
>> and 

> how

>> much is still free for a Locally managed tablespace?
>>
>> Thanks
>>
>>
>>

>
> By using dba_free_space
> Please note: if the size of the datafile minus 64k is not an *EXACT*
> multiple of the extent size, you will 'loose' information. I once ran
> into that when there was only 1 extent left which didn't 'fit'
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>

Please note that this does not include auto extend. If a datafile is set you should look in dba_data_files for the maximum size of the data file. Also exents should fit entirely free blocks. In locally managed tablespaces the next extent of a segment (table, index, etc.) can grow up to 64 M.

Greetz, Arjan.
Assistant Oracle DBA Received on Tue Feb 18 2003 - 13:09:28 CST