OraFAQ Forum: Server Administration » TO KNOW USED SPACE OF DATA FILE

Home » RDBMS Server » Server Administration » TO KNOW USED SPACE OF DATA FILE (ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes)

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

TO KNOW USED SPACE OF DATA FILE [message #548292]

Wed, 21 March 2012 04:48

janakors
Messages: 232
Registered: September 2009

Senior Member

HI,
Can anyone post some script which will find out the used space of a specific datafile

Regards

Report message to a moderator

Re: TO KNOW USED SPACE OF DATA FILE [message #548296 is a reply to message #548292]

Wed, 21 March 2012 04:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Can you just search a little bit? This has already been posted at least several hundred times.

And do NOT post your title in UPPER case.

Regards
Michel

Report message to a moderator

Re: TO KNOW USED SPACE OF DATA FILE [message #548299 is a reply to message #548296]

Wed, 21 March 2012 04:57

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

Hi,

SELECT SUBSTR (df.NAME, 1, 40) file_name, df.bytes / 1024 / 1024 allocated_mb,
((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0))
used_mb,
NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb
FROM v$datafile df, dba_free_space dfs
WHERE df.file# = dfs.file_id(+)
GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes
ORDER BY file_name;

Regards
Sathish

Report message to a moderator

Re: TO KNOW USED SPACE OF DATA FILE [message #548347 is a reply to message #548299]

Wed, 21 March 2012 09:13

janakors
Messages: 232
Registered: September 2009

Senior Member

@Michel, i always use Google before posting and found some scripts but didn't work, then i ask for it

Thanks Sathish16787, i will try it

Regards

Report message to a moderator

Re: TO KNOW USED SPACE OF DATA FILE [message #548349 is a reply to message #548347]

Wed, 21 March 2012 09:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

found some scripts but didn't work

Didn't work is meaningless.
You should post what you found and tried as required in the forum guide.
And if you didn't find the query that has been posted then you didn't search very well.

Regards
Michel

Report message to a moderator

Re: TO KNOW USED SPACE OF DATA FILE [message #548350 is a reply to message #548347]

Wed, 21 March 2012 09:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

janakors wrote on Wed, 21 March 2012 07:13

@Michel, i always use Google before posting and found some scripts but didn't work, then i ask for it

Thanks Sathish16787, i will try it

Regards

SEARCH here produces the following!

http://www.orafaq.com/wiki/Scripts#Space_Management_Scripts

Report message to a moderator

Previous Topic:	CREATE TABLESPACE AND ORA-03214
Next Topic:	update props$　set value$

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 06:38:34 CST 2025