Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8PLZNR29440 for ; Thu, 25 Sep 2003 16:35:23 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8PLZMc29430 for ; Thu, 25 Sep 2003 16:35:22 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8PHtW008235 for oracle-l@orafaq.net; Thu, 25 Sep 2003 10:55:32 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D1112; Thu, 25 Sep 2003 10:54:43 -0800 Message-ID: Date: Thu, 25 Sep 2003 10:54:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jared.Still@radisys.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jared.Still@radisys.com Subject: RE: guidance Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 0061FF7188256DAC_=" --=_alternative 0061FF7188256DAC_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable PGA=5FAGGREGATE=5FTARGET "Jesse, Rich" Sent by: ml-errors@fatcity.com 09/25/2003 09:34 AM Please respond to ORACLE-L =20 To: Multiple recipients of list ORACLE-L cc:=20 Subject: RE: guidance OK, I'll bite: If SORT=5FAREA=5FSIZE isn't to be set, then what is? Are y= ou referring to the automagic PGA management? Rich Rich Jesse System/Database Administrator rjesse@qtiworld.com Quad/Tech Inc, Sussex, WI USA 10:30 AM CST =3D 5:30 PM CEST. Rats! Now I'll have to wait until tomorrow for an answer... :) > -----Original Message----- > From: Mogens N=F8rgaard [mailto:mln@miracleas.dk] > Sent: Wednesday, September 24, 2003 6:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: guidance >=20 >=20 > Just talked to Jonathan Lewis from Helsinki. He went through=20 > some of the=20 > examples given in the latest issue of Oracle Magazine, and they were=20 > just plain wrong. >=20 > I can't recall them in detail, but I think one of the questions were=20 > which parameter to set in order to let a user do large sorts.=20 > In 9i you=20 > shouldn't set sort=5Farea=5Fsize, but that was the correct answer. And so= =20 > on, and so forth. >=20 > So the important advise is to do what you think they would=20 > like to hear :). >=20 > Mogens >=20 > bulbultyagi@now-india.net.in wrote: >=20 > >List , I am planning to give my 9i performance tuning exam=20 > on the first . > >Any advice you all want to give me ? Pretty nervous about=20 > it. Sure would > >appreciate your guidance. > >........ --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: Jesse, Rich INET: Rich.Jesse@qtiworld.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). --=_alternative 0061FF7188256DAC_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
PGA=5FAGGREGATE=5FTARGET

"Jesse, Rich" <Rich.= Jesse@qtiworld.com>
Sent by: ml-errors@fatcity.com

09/25/2003 09:34 AM
Please respond to ORACLE-L

To: &nbs= p; Multiple recipients of list ORACLE-L <ORACLE-L@fa= tcity.com>
cc: &nbs= p;
Subject:= RE: guidance

OK, I'll bite: If SORT=5FAREA= =5FSIZE isn't to be set, then what is? Are you
referring to the automagic PGA management?

Rich

Rich Jesse &= nbsp; System/Database Administrator
rjesse@qtiworld.com = Quad/Tech Inc, Sussex, WI USA

10:30 AM CST =3D 5:30 PM CEST. Rats! Now I'll have to wait unti= l tomorrow
for an answer... :)

> -----Original Message-----
> From: Mogens N=F8rgaard [mailto:mln@miracleas.dk]
> Sent: Wednesday, September 24, 2003 6:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: guidance
>
>
> Just talked to Jonathan Lewis from Helsinki. He went through
> some of the
> examples given in the latest issue of Oracle Magazine, and they were <= br> > just plain wrong.
>
> I can't recall them in detail, but I think one of the questions were <= br> > which parameter to set in order to let a user do large sorts.
> In 9i you
> shouldn't set sort=5Farea=5Fsize, but that was the correct answer. And= so
> on, and so forth.
>
> So the important advise is to do what you think they would
> like to hear :).
>
> Mogens
>
> bulbultyagi@now-india.net.in wrote:
>
> >List , I am planning to give my 9i performance tuning exam
> on the first .
> >Any advice you all want to give me ? Pretty nervous about
> it. Sure would
> >appreciate your guidance.
> >........
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: Rich.Jesse@qtiworld.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.c= om
San Diego, California -- Mailing list and web ho= sting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).

--=_alternative 0061FF7188256DAC_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still@radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).