On 6/27/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> wrote:
However, (Not from Oracle), I have heard oracle has gotten a lot better with abort – as in not as dangerous or fearsome. I just like synchronizing all the file headers etc…. Does killing the session stop the rollback? If not, then monitoring the alert log for the offending user is nice but doesn't save very many minutes.
See http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist