Further modification... Of course I'd add error checking here too ... ;) Guess I could put this all in a while (patch_not_applied == TRUE) while loop too.... if [ doubt == TRUE ] then go read the documentation. else still read the documentation. fi while [ still_not_clear == TRUE ] loop call support if [ think_i_know_what_im_doing == TRUE ] then break fi end loop if [ you_think_your_clear_now == TRUE ] then try_it(environment=>DEVELOPMENT) fi if [ it_went_well_in_dev == TRUE ] then backup(environment=>PROD) do_or_do_not_there_is_no_try(environment=>PROD); validate(environment=>PROD) fi Robert G. Freeman Master Principal Consultant, Oracle Corporation Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles Blog: http://robertgfreeman.blogspot.com ________________________________ From: Jared Still <jkstill@xxxxxxxxx> To: jack@xxxxxxxxxxxx Cc: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx> Sent: Tue, May 18, 2010 9:47:48 AM Subject: Re: Is it true that view_recompile_jan2008cpu.sql can be run only once during a database's lifetime On Mon, May 17, 2010 at 7:33 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: > > > >When in doubt: >It is better to run a very quick select aginst the registry$history table >(select statement is in the patch install guide so you can just cut and paste >it) I would modify this a bit: When in doubt, go read the documentation. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com