Re: sort area size - 8.1.5

Oracle9i...? Is it available already ...? I'm moving from 8.1.5 to 8.1.7 this weekend. sooooo ..... next weekend?

George Barbour.

"Mark Townsend" <markbtownsend_at_home.com> wrote in message news:B6CD8D50.4A13%markbtownsend_at_home.com...
> MTS is a possible solution - another (depending on your timeframe) is
> Oracle9i, which automates tuning of sort_area_size (and other PGA memory
> parameters)
>
> > From: "Howard J. Rogers" <howardjr_at_www.com>
> > Organization: CWO Customer - reports relating to abuse should be sent to
> > abuse_at_cwo.net.au
> > Newsgroups: comp.databases.oracle.server
> > Date: Fri, 9 Mar 2001 06:45:14 +1100
> > Subject: Re: sort area size - 8.1.5
> >
> > At least 640K (otherwise sort_direct_writes don't happen automatically).
> >
> > Retained size can be quite small if memory is tight.
> >
> > Otherwise, there is no real easy answer. You should take a look at
> > report.txt produced by utlbstat and utlestat, and check that the
 percentage
> > of sorts(disk) to sorts(memory) is lower than 1%. If it is, then the
 PGA is
> > big enough. If it isn't, it isn't.
> >
> > As you indicate, it's the number of *concurrent* Users that's the load
> > factor to watch, not the number of Users in total. And, given that
 inserts
> > and loads and updates don't use much by way of the PGA, I wouldn't have
> > thought you'd have too much of a problem: it's sorts that cause the PGA
 to
> > grow up to the sort_area_size, not updates or inserts.
> >
> > If you have 90 concurrent Users doing huge reports that require lots of
> > sorts, then you might have trouble: at which point it's time to consider
> > implementing multi-threaded server.
> >
> > Regards
> > HJR
> >
> >
> > "Naushi Hussain" <naushi.hussain_at_alliedsignal.com> wrote in message
> > news:3AA7DD26.A69CABBC_at_alliedsignal.com...
> >> can any one tell if there are any guide lines for setting the sort area
> >> size and retain size parameter in init file.
> >> we have a 20 gb database and 2000 users (90 concurrent) and heavy batch
> >> loads and updates throughout the day - oracle 8.1.5
> >>
> >>
> >
> >
>
Received on Fri Mar 09 2001 - 03:10:33 CST