Re: Enqueue wait
Originally posted by simply_dba
. . . or give up the rollback?? What could be the consequence of this?
This as davey says is frightening. There seems to be an idea that rollback is a kind of "optional extra".
Oracle can write "dirty" blocks to the data files before a transaction is complete. This means that in terms of transactional integrity, your data files contain CRAP.
Rollback/Undo is Oracle's way of keeping track of the CRAP in your data files. "give up" the rollback and you have a CRAP database.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman