ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1

[kbhanu]

Hi All,

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

[tabreaz]

Show us the queries which is utilize so much temporary tablespace,
better u tune those queries rather than going on increasing the RAM

[mike9]

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.

[tamilselvan]

==
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.

Tamil

[kssekhar]

Check the following to tune db

v$sqlarea
v$filestat
v$system_event

Also genarate a statspack for 1hr to get a fair idea.
______
Sekhar

[marist89]

Just throwing more hardware will not solve your problem.

or even make it worse.