From: guna dev <guna_dev@...>
Subject: [oracleclub] Reg: Oracle not releasing memory after dropping temporary tablespace
To: breaking_blocks@yahoogroups.com, oracleclub@yahoogroups.com
Date: Tuesday, 5 May, 2009, 2:20 AM

Hi All,

I face a problem with my temporary tablespace. After I drop my temporary tablespace from OEM and even through SQL*PLUS using the command "DROP TABLESPACE TEMP including contents and datafiles" memory occupied by temporary tablespaces are not released when i do df -h command in Linux. My oracle version is oracle 9i and OS is linux AS 4. Please help me solve this problem. Thanks in advance.

 

Thanks

Guna

---

Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Edition * Click here!