how to free and used space in individual data files

[younusdba]

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

[davey23uk]

look at dba_free_space

[vnktummala]

allocated space can see in - dba_data_files
free space can see in - dba_free_space

so you need write a join query to get what you want. If you have no time to write a query google for it.

Thanks,

[mahajanakhil198]

allocated space can see in - dba_data_files
free space can see in - dba_free_space

so you need write a join query to get what you want. If you have no time to write a query google for it.

Thanks,

allocated space in dba_extents.
free space in dba_free_space.
total space in dba_data_files.

[vnktummala]

Hi Maha,

I mean to say total size of the each datafile in dba_data_files. Anyway, thanks for correcting me.

Thanks,