Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling in the Cavalry - Hanging 8i database
>As in your case, bouncing the DB clears out all the sessions in
>ENQUEUE wait and business as usual resumes; until the next time
>somebody started a UPDATE transaction & then went off to a meeting
>without any ROLLBACK or COMMIT.
>My fix was to "reorg" heavily updated tables while specifying
INITRANS=15.
>After that, the hangs never returned
Thanks, I'll definitely investigate this. Received on Sun May 15 2005 - 08:29:26 CDT