AIX 6.1 : Adding tempfiles for TEMP tablespace ( 11gr2)
Hi,
I have added 2 tempfiles (15Go for each one) to have finally 50Go for TEMP tablespace.
ALTER TABLESPACE TEMP ADD TEMPFILE '/apps/data/CARPROJ/osys3/tmp03.dbf' SIZE 15G REUSE;
ALTER TABLESPACE TEMP ADD TEMPFILE '/apps/data/CARPROJ/osys3/tmp04.dbf' SIZE 15G REUSE;
but df -g . command displays only 28G as allocated space in /apps/data/CARPROJ/osys3 directory !
Is it normal?
AIX-6.1:/apps/data/CARPROJ/osys3]df -g .
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/lvCARPROJosys3 28.00 1.84 94% 15 1% /apps/data/CARPROJ/osys3
AIX-6.1:/apps/data/CARPROJ/osys3]ls -l *tmp*
-rw-r--r-- 1 oracle dba 10737426432 Sep 16 12:07 tmp01.dbf
0