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)
TO KNOW USED SPACE OF DATA FILE [message #548292] Wed, 21 March 2012 04:48 Go to next message
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
Re: TO KNOW USED SPACE OF DATA FILE [message #548296 is a reply to message #548292] Wed, 21 March 2012 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: TO KNOW USED SPACE OF DATA FILE [message #548299 is a reply to message #548296] Wed, 21 March 2012 04:57 Go to previous messageGo to next message
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
Re: TO KNOW USED SPACE OF DATA FILE [message #548347 is a reply to message #548299] Wed, 21 March 2012 09:13 Go to previous messageGo to next message
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
Re: TO KNOW USED SPACE OF DATA FILE [message #548349 is a reply to message #548347] Wed, 21 March 2012 09:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: TO KNOW USED SPACE OF DATA FILE [message #548350 is a reply to message #548347] Wed, 21 March 2012 09:17 Go to previous message
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
Previous Topic: CREATE TABLESPACE AND ORA-03214
Next Topic: update props$ set value$
Goto Forum:
  


Current Time: Thu Mar 28 12:53:54 CDT 2024