Home » RDBMS Server » Server Administration » to know free and used spaces in datafiles (oracle 10.1.0.2.0,IBM-AIX 5.3)
to know free and used spaces in datafiles [message #424052] Wed, 30 September 2009 01:57 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member


Hi all,

how to know free space and used space in individual database files by sql quer or command not from oracle enterprise manager.please can any body tell me query.quick response will higly appreciated.thanks a lot in advance
Re: to know free and used spaces in datafiles [message #424055 is a reply to message #424052] Wed, 30 September 2009 02:04 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
Hi,

You can use dba_free_space it also has file_id column.Write a query according to your requirement.

Regards

Balakrishna
Re: to know free and used spaces in datafiles [message #424056 is a reply to message #424052] Wed, 30 September 2009 02:04 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

I've answered you over OTN Smile
http://forums.oracle.com/forums/message.jspa?messageID=3795785#3795785
Re: to know free and used spaces in datafiles [message #424140 is a reply to message #424056] Wed, 30 September 2009 05:47 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi Dear

thanks a lot for quick response.this query is very helpful for me.
Re: to know free and used spaces in datafiles [message #424176 is a reply to message #424052] Wed, 30 September 2009 07:27 Go to previous message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just search this forum/google before posting.
These questions are asked and answered too many times.
Previous Topic: DBA (merged 3)
Next Topic: Cannot reclaim space after running "alter Shrink table ... shrink space"
Goto Forum:
  


Current Time: Sun Sep 25 07:50:26 CDT 2016

Total time taken to generate the page: 0.12425 seconds