-
ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1
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
Bhanu Msc
-
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.
Tamil
-
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
-
Originally Posted by tamilselvan
Just throwing more hardware will not solve your problem.
or even make it worse.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|