Re: newbie question

To find the free space by file, use Nigel's query and add file_id. You can also find the filename by joining it with DBA_DATA_FILES by file_id.

Kenny Gump

ngroves_at_ndsuk.com wrote in message <7ih7fb$7e$1_at_nnrp1.deja.com>...
>In article <7ih2q2$sfr$1_at_nnrp1.deja.com>,
> barry_deevey_at_my-dejanews.com wrote:
>> Hi,
>>
>> I am running Oracle 7.3.4, and would like to find out if there is a
>> query that would allow me to find out how much space is actually being
>> used in both tablespaces and datafiles.
>>
>> Any replies will be greatly appreciated.
>>
>> Best Regards,
>>
>> Barry.
>>
>> --== Sent via Deja.com http://www.deja.com/ ==--
>> ---Share what you know. Learn what you don't.---
>>
>
>select tablespace_name,
>count(*) "pieces", max(blocks) "maximum", sum(blocks)
> "total" from sys.dba_free_space group by tablespace_name;
>
>tells you how much free space you have in a tablespace
>
>not sure how to find free space in a datafile, but it must be available
>as the enterprise manager gui shows it
>
>regards
>
>nigel groves
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 27 1999 - 09:25:25 CDT