I was wondering with greater amounts of RAM available these days, why can the Rollback Segments and the Temporary
Segment be part of the RAM.
I have about 3.5 Gig of RAM on the Server, I dont see why all Rollback and sorts should be written to Disk.
There is this Sort Segment but it has got its own limitations of sizing.
Rollback in memory? Sounds like a pretty bad idea to me. What happens if your server reboots and you have 1200 transactions in memory?
Are'nt the transaction in the Redolog ?
What about temporaty segment ?
You need to learn more about what heppens when an instance fails and how oracle recovers itself to point of failure to understand why rbs is not stored in memmory.
As far as temporary tablespace is concerned. If you got enough memmory, you don't have to use it.
set a large value for sort_area_size and monitor v$systat so that sorts(disk) is equal to 0.