Hi All,
I am new to the Oracle Forum and I have a question with the Tablespace Usage:
When I query from dba_free_space for a particular tablespace:
select * from dba_free_space where tablespace_name = '<tablespacename>';
SQL>
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
SQL>
I get the output with no records displayed. Does it mean that the tablespace is full and either datafile needs to be resized or added?
Additional Info:
Oracle Version: 9.2.0.5
select * from dba_data_files where tablespace_name = '<tablespacename>';
SQL>
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
/u03/oradata/<folder>/<file01>.dbf 12 <tablespacename> 889192448 108544 AVAILABLE 12 YES 3435972198 4194302 1 888143872 108416
SQL>
Also when I query it to find the %used :
TABLESPACE SIZE DETAILS
========================
-----------------
ORACLE SID :DBname
-----------------
TABLESPACE Size (MB) Free Space (MB) Used Space (MB) %Used
SYSTEM 760 628 132 17%
UNDOTBS1 2860 2809 51 2%
TOOLS 8 6 2 25%
Tablespacename 848 848 100%
Here too the freespace(MB) is empty with no records.
Can anyone help me with what actually this mean?
Thanks in advance.
Edited by: 805324 on Oct 26, 2010 7:59 AM