This Oracle behavior is called "block cleanout," and makes it unnecessary for a transaction to touch all effected blocks when it commits or rolls back - some fu

This Oracle behavior is called "block cleanout," and makes it unnecessary for a transaction to touch all effected blocks when it commits or rolls back - some future transaction will do this. Oracle also has two init.ora parameters, SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE, that are similar to the WORK_MEM mentioned in the subject article. As far as I know, SORT_AREA_SIZE is global, and differing values cannot be assigned to roles.