| How to increase dba_free_space [message #276485] |
Thu, 25 October 2007 05:01  |
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  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
