Home » RDBMS Server » Server Administration » How to increase dba_free_space
How to increase dba_free_space [message #276485] Thu, 25 October 2007 05:01 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

How do I increase the freespace volume the fast way?
I saw some of the articles by adding new datafile or resize to bigger size.

I tested to resize one of the datafiles, the size did increase but when I resize another datafile, it wouldn't increase, why ah? I added new datafiles into the tablespace, the size also didn't increase.

SELECT max(bytes)/1024/1024 from dba_free_space where tablespace_name='tablespace';
Re: How to increase dba_free_space [message #276489 is a reply to message #276485] Thu, 25 October 2007 05:13 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

SQL> SELECT max(bytes)/1024/1024 from dba_free_space where tablespace_name='DATA01';

MAX(BYTES)/1024/1024
--------------------
           1017.9375
SQL> alter tablespace data01 add datafile '/oradata1/test01.dbf' size 10M;

Tablespace altered.

SQL> SELECT max(bytes)/1024/1024 from dba_free_space where tablespace_name='DATA01';

MAX(BYTES)/1024/1024
--------------------
           1017.9375

SQL> select file_id from dba_free_space where tablespace_name='DATA01';

   FILE_ID
----------
         5
        12
SQL> SELECT max(bytes)/1024/1024 from dba_free_space where file_id=5;

MAX(BYTES)/1024/1024
--------------------
           1017.9375

SQL> SELECT max(bytes)/1024/1024 from dba_free_space where file_id=12;

MAX(BYTES)/1024/1024
--------------------
              9.9375



Your max function did the things.

SQL> select bytes/1024/1024 from dba_free_space where tablespace_name='DATA01';

BYTES/1024/1024
---------------
      1017.9375
         9.9375
SQL> select sum(bytes)/1024/1024 from dba_free_space where tablespace_name='DATA01';

SUM(BYTES)/1024/1024
--------------------
            1027.875



[Updated on: Thu, 25 October 2007 05:16]

Report message to a moderator

Previous Topic: ORA-04030: out of process memory
Next Topic: PGA Aggregate Target File Location
Goto Forum:
  


Current Time: Thu Dec 08 20:01:18 CST 2016

Total time taken to generate the page: 0.08974 seconds