Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie question

Re: newbie question

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Thu, 27 May 1999 10:25:25 -0400
Message-ID: <374d55ca.0@news.mountain.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US