Re: move from UNDO_MANAGMENT=AUTO to MANUAL
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Nov 2008 22:21:38 +0100
Message-ID: <4925d4ea$0$190$e4fe514c@news.xs4all.nl>
>
> The obvious solution is of course to take the documentation and to
> read up on undo management,
> and to notice you only need to create rollback segments and change the
> undo_management parameter.
> As this would have required you to do work, which you rather avoid,
> you are asking a volunteer to abstract the docs.
> Current DBA mentality is so sad....
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Date: Thu, 20 Nov 2008 22:21:38 +0100
Message-ID: <4925d4ea$0$190$e4fe514c@news.xs4all.nl>
sybrandb schreef:
> On 20 nov, 11:21, Ismael <isma.sanc..._at_gmail.com> wrote:
>> On Nov 20, 10:14 am, sybrandb <sybra..._at_gmail.com> wrote: >> >> >> >> >> >>> On 20 nov, 09:14, Ismael <isma.sanc..._at_gmail.com> 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 >>> I would request the 'application' provider to send his 'developers' to >>> a course, so the 'application' doesn't need to walk on one leg and one >>> crutch. >>> -- >>> Sybrand Bakker >>> Senior Oracle DBA >> One of the migration steps is the repository upgrade (the repository >> is stored in the oracle database). For this step, they advise us to >> change de undo management to MANUAL before running the processes that >> are involved. It's not an application requirement, we can change to >> AUTO after upgrading ... >> Changing undo management to MANUAL is ONLY for the upgrade. >> Could you help me?- Tekst uit oorspronkelijk bericht niet weergeven - >> >> - Tekst uit oorspronkelijk bericht weergeven -
>
> The obvious solution is of course to take the documentation and to
> read up on undo management,
> and to notice you only need to create rollback segments and change the
> undo_management parameter.
> As this would have required you to do work, which you rather avoid,
> you are asking a volunteer to abstract the docs.
> Current DBA mentality is so sad....
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Luckily we still have our senior DBA's.....
Shakespare
What's in a RAID??
Received on Thu Nov 20 2008 - 15:21:38 CST