And here I am trying to make things so complicated ;-) And for repeat billings, create an invisible DBMS_JOB (_invisible_jobs = TRUE) that calls a routine that resets the value to 1. Schedule to run 6 months once your contract ends. Sure to get a call.
Larry > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph S > Testa > Sent: Monday, March 18, 2002 4:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Fav. Urban Legend... > > > init.ora parm: _MAKE_SQL_RUN_FASTER= > > valid values: > > 8.0 = true/false > 8.1 = x where x is a number between 1 and 100 > 9.0 = x or unlimited <-- this gives you the ultimate speed in queries > > joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).