| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Locally-managed temp tablespace question
Oracle 8173 on Solaris 2.8:
bash-2.03$ pwd
/oracle/u02/oradata/YPD
bash-2.03$ df -k|grep /oracle/u02
/dev/dsk/c1t2d0s0 70592505 45549803 22924927 67% /oracle/u02
bash-2.03$ ls -l templmt*
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:40 templmt01.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt02.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt03.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt04.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt05.dbf
bash-2.03$ rm templmt*
bash-2.03$ df -k|grep /oracle/u02
/dev/dsk/c1t2d0s0 70592505 44244651 24230079 65% /oracle/u02
I thought I should get 10GB (2097160192 x 5) back, but instead I got only 1.3MB ( 24230079 - 22924927) released. Could someone explain? BTW, when I created the temp files (templmt0[1-5]) for locally-managed temp tablespace, I found they were created extremely fast, so I suspected that not real disk space were allocated. But the "ls -l" command still showed 10GB were allocated.
TIA. Guang Mei
guangmei_at_yahoo.com
http://www.geocities.com/guangmei/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: zlmei_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 20 2002 - 11:04:42 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |