ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1
we are facing severe problem with temp tablesapce.. once we got the error we adder more space to temptablespace, and bounced the database also. there is no impact on this. again we droped the temp tablespace and recreated the temptablespace... no change..
we added more RAM to the server also..we are getting the very slow performance problem.. please suggest how to proceed
Show us the queries which is utilize so much temporary tablespace,
better u tune those queries rather than going on increasing the RAM
would be interesting to get some more details about your application, system, DB and hardware.
also it may help to see what kind of query generates this error.
we added more RAM to the server also..we are getting the very slow performance problem..
I think you did not identify the root cause of the problem. Just throwing more hardware will not solve your problem.
My guess is your system is doing more hash join or parallel processing.
Check the following to tune db
Also genarate a statspack for 1hr to get a fair idea.
or even make it worse.
Originally Posted by tamilselvan
Click Here to Expand Forum to Full Width