Re: Re: Enqueue wait
Originally posted by DaPi
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.
Ok I asked a silly question.
But do you have to be rude like that?
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA