RE: Is it true that view_recompile_jan2008cpu.sql can be run only once during a database's lifetime
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>, "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>, "jack@xxxxxxxxxxxx" <jack@xxxxxxxxxxxx>
- Date: Tue, 18 May 2010 12:19:42 -0400
I like it! :)
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Freeman
Sent: Tuesday, May 18, 2010 12:07 PM
To: jkstill@xxxxxxxxx; jack@xxxxxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Is it true that view_recompile_jan2008cpu.sql can be run only once
during a database's lifetime
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<mailto: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
Other related posts:
