Oracle-L: RE: Fav. Urban Legend...

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Tue, 19 Mar 2002 08:18:28 -0800
Message-ID: <F001.0042D2B7.20020319081828@fatcity.com>

9i Release 2 has a newer setting

_MAKE_SQL_RUN_FASTER= 0 to 100
unlimited
Ludicrous speed

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

-----Original Message-----
Sent: Monday, March 18, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L

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: Joseph S Testa
INET: jtesta_at_dmc-it.com

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: ListGuru_at_fatcity.com (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------