oracleclub : Message: Reg: Oracle not releasing memory after dropping temporary tablespace

oracleclub · Oracle Club

Yahoo! Groups Tips

Did you know...

Show off your group to the world. Share a photo of your group with us.

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 #1073 of 1112 |

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!

Mon May 4, 2009 8:50 pm

Show Message Option

guna dev <guna_dev@...>

guna_dev

Offline

Send Email

Forward

Message #1073 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	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	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	May 5, 2009 12:57 pm

< Prev Topic | Next Topic >

Advanced

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages