Re: move from UNDO_MANAGMENT=AUTO to MANUAL
Date: Mon, 24 Nov 2008 11:39:19 +0000 (UTC)
Message-ID: <gge3p7$cvt$1@solani.org>
On Thu, 20 Nov 2008 00:14:27 -0800, Ismael wrote:
> Hi,
> Oracle 10.2.0.3 on Win 2003 Server
> We have an Oracle database running in automatic undo management. An
> application provider has to upgrade his application and needs the
> database running in manual undo management. I've never gone back to
> manual from auto ... could you give me any advice? Do you know the best
> way to success?
>
> Thank you very much for your help?
>
> Best Regards,
> Ismael
Why is the application server even concerned with the undo management? That not something that an application server should address? My advice is to change the app server. What is it trying to do? To address rollback segments directly with "SET TRANSACTION USE ROLLBACK SEGMENT"? That has been slightly deprecated for some time now.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Mon Nov 24 2008 - 05:39:19 CST