| TEMP Tablespace Space [message #140815] |
Wed, 05 October 2005 14:03  |
sarahzen
Messages: 3
Registered: October 2005
Location: Bethesda
|
Junior Member |
|
|
Our application got an error because Oracle could not extend the TEMP tablespace. I deleted disk space, but that didn't help. I then used Enterprise Manager to increase the size of the datafile for the TEMP tablespace. That resolved the problem.
My question is, 'Why was that necessary?' It's a temp tablespace. Shouldn't the data within it get deleted and therefore it not need to keep increasing in size? I found a question about increasing the temp tablespace size on this forum dated last September. The response there was to tell the user how to increase the size, but also to say that they shouldn't need to do so because Oracle would do so for you.
So, I'm thinking we must have something set up wrong. This is a test system only used by a few users, so we're not adding a lot of data. Is there some setup of the TEMP tablespace that we should configure so that it cleans up regularly and doesn't keep needing to be expanded?
Thanks for your help.
|
|
|
|
|
|
|
|
| Re: TEMP Tablespace Space [message #140908 is a reply to message #140883] |
Thu, 06 October 2005 02:46  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
sarahzen... well temp tablespace is used for sorting purpose when oracle is not able to allocate space in pga for sorting then it shift its sorting in to temp tablespace. Once the sorting is over oracle free the temp tablespace.
Now the question arises y we need to increase temp tablespace?
This is b'coz the sorting require more sapace then the temp size so we have to increase the size of temp tablespace.
Note:- temp stand for temporary tablespace used for temporary storage of data.
I hope above explanation will help u
Regards
Always Friend Sunilkumar.
|
|
|
|
| Re: TEMP Tablespace Space [message #140985 is a reply to message #140908] |
Thu, 06 October 2005 08:35 |
sarahzen
Messages: 3
Registered: October 2005
Location: Bethesda
|
Junior Member |
|
|
|
Thank you for the good information.. I think my next step is to review v$sql. This is a test system. The second time we had to increase the temp tablespace, there had only been one user using the database! I'm thinking there must be some sorry SQL in the application to cause such sorting that one person can use up all the space available for sorting!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
