Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sort_read_fac

Re: sort_read_fac

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Mon, 27 Sep 1999 20:47:14 +0200
Message-ID: <37EFBBB2.439894F7@informatik.uni-jena.de>


Sorry, I have no experiencees. But I would test this parameter in Oracle8i and got this message (by starting the server manager):

        SORT_READ_FAC parameter has been made obsolet

It seems, that is not worth to use this;-)

Jan

Connor McDonald wrote:
>
> Does anyone have any experience with modifications to this
> parameter...The tuning manual (quoted below) describes the following
> with regard to improving sort performance, but I've never seen it
> modified from its default at any site...
>
> Server Tuning:
> "Change the SORT_READ_FAC parameter, which is a ratio describing the
> amount of time necessary to read a single database block divided by the
> block transfer rate. The value is operating system specific; the default
> value is typically 5, but the parameter should usually be set to 16 or
> 32"
>
> Any views to share ?
>
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."

--



Jan Nowitzky
Friedrich-Schiller-Universität o Institut für Informatik
D-07740 Jena o Tel. +49/3641/9-46363 
E-Mail nowitzky_at_informatik.uni-jena.de
--------------------------------------------------------------
Received on Mon Sep 27 1999 - 13:47:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US