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

To be sure, to be sure, to be sure

Was the developers name in the script? Does it look suspiciously Irish? It the database ever referred to as O'Oracle by chance?

|---------+----------------------------->


|         |           Paul Drake        |

|         |           <bdbafh_at_gmail.com>|

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           30/11/2004 06:45  |

|         |           Please respond to |

|         |           bdbafh            |

|---------+----------------------------->
  >-----------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                       |
  |       To:       "Oracle-L (E-mail)" <oracle-l_at_freelists.org>                                                          |
  |       cc:                                                                                                             |
  |       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




<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--
http://www.freelists.org/webpage/oracle-l