OraFAQ Forum: Server Administration » How the check the space used in datafile

Home » RDBMS Server » Server Administration » How the check the space used in datafile

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

How the check the space used in datafile [message #146379]

Thu, 10 November 2005 01:53

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

Hi All

I have a database and i wanted to check the space used in the datafiles and how much space is left so that i would be able to analyze the space required for daily activities. Its urgent..Plz tell me

Thanks

Gulshan

Report message to a moderator

Re: How the check the space used in datafile [message #146388 is a reply to message #146379]

Thu, 10 November 2005 02:46

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

TTI "Allocated, Used & Free space within datafiles"

COLUMN free_space_mb format 999999.90
COLUMN allocated_mb format 999999.90
COLUMN used_mb format 999999.90

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;

TTI off

Hope this helps!
Neil.

Report message to a moderator

Previous Topic:	ODP.NET install problem
Next Topic:	how to check the used space in datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:46:37 CST 2025