Quote:
Originally posted by tamilselvan
I feel Oracle's Rollback Tablespace ( segements) concept was not designed properly. Oracle should have been designed/developed to use /tmp (in Unix) or C:\TEMP (in NT) area for its internal activities such as maintaining read consistency, concurrency and sort activities.
I'm not sure I understand exactly what do you mean by this, could you elaborate your idea? Should the /tmp "structures" that would implement undo entries still be formated as database blocks? If yes, what would be the difference then? If no, how would Oracle suppose to load "pre-changed" image of db blocks into buffer cache for read consistency? And how would you backup those structures to be able to perform recovery?