Search the web
Sign In
New User? Sign Up
oracleclub · Oracle Club
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Reg: Oracle not releasing memory after dropping temporary tablespace   Message List  
Reply | Forward Message #1074 of 1112 |
Re: [oracleclub] Reg: Oracle not releasing memory after dropping temporary tablespace


post your error details

--
Thanks & Regards

Babu B
http://babudba.blogspot.com
http://babuappsdba.blogspot.com

--- On Tue, 5/5/09, guna dev <guna_dev@...> wrote:

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!


Cricket on your mind? Visit the ultimate cricket website. Enter now!

Tue May 5, 2009 7:15 am

ind_babu05
Offline Offline
Send Email Send Email

Forward
Message #1074 of 1112 |
Expand Messages Author Sort by Date

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...
guna dev
guna_dev
Offline Send Email
May 4, 2009
8:54 pm

post your error details -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From: guna dev <guna_dev@...> Subject:...
Babu B
ind_babu05
Offline Send Email
May 5, 2009
7:15 am

Babu, i didnt get any error. The actual problem was we had 2 partitions for oracle /oradata and /orasoft. We had a temporary tablespace temp containing 2 temp...
guna dev
guna_dev
Offline Send Email
May 5, 2009
12:57 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help