Skip to Main Content

RAC requires huge TEMP and UNDO

390379Jun 14 2007 — edited Jun 15 2007
We recently migrated our 9iRAC (500GB) database to 4 node 9iRAC on Sun T2000.
Earlier we had 60GB TEMP and 80GB UNDO.
We are frequently getting unable to extend TEMP and also I see the UNDO is not properly sharing across the instances.

I had to increase the size of TEMP to 100GB and UNDO to 120GB .
Looks like, if we were to go 8 nodes, TEMP, UNDO & REDO will count more than the database size ;-?
Does anybody else had similar problems ?

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jul 13 2007
Added on Jun 14 2007