| Datafile Free Size [message #194630] |
Sat, 23 September 2006 02:34  |
thiyagaraj
Messages: 41
Registered: August 2006
|
Member |
|
|
Hi
Is there anyway to perfectly calculate the free space available in datafiles?
Can i consider the bytes that shows in dba_free_space and also dba_free_space_coalesce views as free space avilable to my datafile?
If i issue this below query:
SQL> select TABLESPACE_NAME,FILE_ID,BYTES from dba_free_space;
the output is:
TABLESPACE_NAME FILE_ID BYTES
----------------- - --------- ----------
XXX 11 655360
XXX 11 2031616
But i have only one tablespace name called XXX and have onlyone datafile in that named YYY. Then why this query fetches two rows that has same file-id with different bytes?
can i consider that 655360 as freespace available in my datafile?then what is 2031616 ? please clear my doubt.
If i issue this query:
SQL> select FILE_NAME,BYTES,AUTOEXTENSIBLE,MAXBYTES,INCREMENT_BY from dba_data_files where TABLESPACE_NAME='XXX';
output is:
FILE_NAME BYTES AUT MAXBYTES INCREMENT_BY
------------------------------------------------------------------------------------------------------------
/u01/oradata/AAA/YYY.dbf 454033408 YES 3.4360E+10 256
What is this increment_by will do?but, i know the bytes shows the total bytes allocated to datafile. Then what is that MAXBYTES values says.
Please let me know.
Thanks
Raaj
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
