OraFAQ Forum: Server Administration » to know free and used spaces in datafiles

Home » RDBMS Server » Server Administration » to know free and used spaces in datafiles (oracle 10.1.0.2.0,IBM-AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

to know free and used spaces in datafiles [message #424052]

Wed, 30 September 2009 01:57

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

Report message to a moderator

Re: to know free and used spaces in datafiles [message #424055 is a reply to message #424052]

Wed, 30 September 2009 02:04

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

Report message to a moderator

Re: to know free and used spaces in datafiles [message #424056 is a reply to message #424052]

Wed, 30 September 2009 02:04

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

Report message to a moderator

Re: to know free and used spaces in datafiles [message #424140 is a reply to message #424056]

Wed, 30 September 2009 05:47

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi Dear

thanks a lot for quick response.this query is very helpful for me.

Report message to a moderator

Re: to know free and used spaces in datafiles [message #424176 is a reply to message #424052]

Wed, 30 September 2009 07:27

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	DBA (merged 3)
Next Topic:	Cannot reclaim space after running "alter Shrink table ... shrink space"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 23:22:06 CST 2025