RE: Sort_multiblock_read

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Fri, 15 Jun 2001 04:50:53 -0700
Message-ID: <F001.0032B148.20010615043556@fatcity.com>

Because it is very possible and likely to have a sort area size much larger than the max io of the OS. Most os can only do 64-128k in a single io, not 10-20m.

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
Sent: Thursday, June 14, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L

Hi All,

Reading about the SORT_MULTIBLOCK_READ_COUNT init.ora parameter, I am wondering why it should ever be anything smaller or larger than the SORT_AREA_SIZE. Has anyone changed the default setting of this parameter for the better?

Johnson Job

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
--

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

Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.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: Christopher Spence
INET: cspence_at_FuelSpot.com

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

RE: Sort_multiblock_read_count