Re: How to kill? (Full rollback segment)

>A user has a transaction that's stuck because of a full
>rollback-segment.
>->1: Are there anything like a 'Kill transaction'-statement?
>
>I tried to kill the users session, but the kill statement waits for the
>transaction to finish. (ORA-00031: session marked for kill)
>->2: Are there anything like a 'Kill session immediate'-statement, that
>will roll back the transaction?
>

We had the same exact situation. You may find a shutdown immediate will hang, or when you bring the database back up, that the active trasaction will still be in there, believe it or not.  

You can try this:  

in the init.ora, put this exactly:  

_offline_rollback_segments=( name of rollback segment)  

and comment out the line with the rollback_segments parameter listed.  

Bring up the database, drop the segment. Ours was even worse than what you have. It filled, and then corrupted. We had to use _corrupted_rollback_segments=

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html