-
how to free and used space in individual data files
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
-
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
 Originally Posted by 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,
allocated space in dba_extents.
free space in dba_free_space.
total space in dba_data_files.
lucky
-
Hi Maha,
I mean to say total size of the each datafile in dba_data_files. Anyway, thanks for correcting me.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|