Re: Three is the number, the number shall be three ...

Hi Paul,

There are exactly 42 letters (a-z) in:
execute immediate 'alter system flush shared_pool';

They were hoping someone would notice. ;-)

Regards,

Mike


On Tue, 30 Nov 2004 14:13:11 +0800, Sinardy Xing
<sinardyxing@xxxxxxxxxxxxx> wrote:
> Their bonus is 5 cents/letter=20
> 
> 
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paul Drake
> Sent: 30 November 2004 03:46
> To: Oracle-L (E-mail)
> Subject: Three is the number, the number shall be three ...
> 
> Might anyone care to wager why a developer at Oracle would use 3
> iterations of flushing the shared_pool during execution of the
> jserver.sql script in creation of the JServer subsequent to database
> creation?
> 
> Possible reasons:
> 
> 1. Developer is a Huge Monty Python fan.
> 2. 4 isn't prime
> 3. 42 was deemed to be excessive
> 4. 1 and 2 iterations were simply no enough - tested and 4th iteration
> gained nothing.
> 
> Its not like its a routine where the code examines v$sgastat or =
> anything.
> Its just 3 statements.
> 
> 158  dbms_output.put_line('flush shared_pool');
> 159  execute immediate 'alter system flush shared_pool';
> 160  execute immediate 'alter system flush shared_pool';
> 161  execute immediate 'alter system flush shared_pool';
> 
> humorous comments appreciated.
> 
> Paul
> 
> btw - 10.1.0.3 Std Ed / w2k adv svr sp4
> --
> http://www.freelists.org/webpage/oracle-l
> 
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: