RE: ORDER BY ..

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 08 Nov 2000 08:15:43 -0400
Message-Id: <10674.121411@fatcity.com>

I was away on an Oracle8i course for a week, and when I came back there = were
over 600 messages on this list. I didn't take time to carefully read = the
joke thread, you can imagine why.

Flaming does not, in my opinion, add anything to the list. Especially = if the
humour is at other people's expense. There is enough traffic on the = list as
it is, without padding it. Sometimes it is busier than others (e.g. September was a bit slow), but things are picking up again. =20

Writing in capital letters is like shouting in e-mails, it looked like = a
flame to me and I reacted accordingly.

I have been on this list for over a year, I have no problems with = spending
time on this list. I see it as a useful resource regarding Oracle administration.

Setting sort_area_size is probably right, but usually Oracle recommends tuning database design, tuning SQL, then tuning memory, then I/O, then contention. Did anyone ask her to verify in her stats whether disk = sorts
were taking place, before increasing the size of her SGA?

I started with the SQL because I can't see the db design, and sometimes = if
it's designed improperly there is not much you can do by the time it = lands
on your lap.

So that one e-mail generated at least five more, so far. For what = purpose?

Probably I could have left it alone, and let Jared decide whether to intervene.

Todd, if you didn't mean it as a flame, I apologize, but please = remember
that some people rely on the list during work hours.

Satar you did get the spelling right, it's a male French name.

I think maybe from now on I will just ignore the jokes. Too bad I = can't set
my in-box assistant to delete them all automatically.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Satar Naghshineh
[SMTP:Satar.Naghshineh_at_irvine.mellesgriot.com]
	Sent:	Tuesday, November 07, 2000 7:36 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: ORDER BY ..

	Ditto, Lee didn't do anything wrong. Also, if Patrice (spelling?)

wants to answer questions like that, she'll spend all her time on the = list.
By the way, Patrice (spelling?) wouldn't be able to help the original = poster
by getting a copy of the original poster's script. Patrice will have to = have
the ERD and the knowledge of the business requirements.

        As funny as it seems, there is a parameter that can make an ORDER BY clause run faster. Although I do not recommend it as the answer, but = one
could set SORT_AREA_SIZE to a high number so all the sorting is done in memory.

	Regards,
	Satar=20

	-----Original Message-----=20
	From:   Dennis Taylor [SMTP:ismgr_at_pctc.com]=20
	Sent:   Tuesday, November 07, 2000 9:33 PM=20
	To:     Multiple recipients of list ORACLE-L=20
	Subject:        RE: ORDER BY ..=20

	That was what  I got as well.=20

	At 11:07 AM 11/7/00 -0800, you wrote:=20


	>I may be wrong here but I was thinking that Lee was=20

	>daring someone to reply to the list with that parameter=20

	>that was going around as a joke before.  I think=20

	>it was _make_sql_run_faster.  Hardly a cause for removing=20

	>someone from the list.=20

	>=20


	---=20
	Dennis Taylor=20
	---=20
	Don't worry about people stealing your ideas.  If your ideas=20
	are any good,=20
	you'll have to ram them down people's throats.=20
	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com> =20
	--=20
	Author: Dennis Taylor=20
	  INET: ismgr_at_pctc.com=20

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

	To REMOVE yourself from this mailing list, send an E-Mail message=20
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
	the message BODY, include a line containing: UNSUB ORACLE-L=20
	(or the name of mailing list you want to be removed from).  You may=20

Received on Wed Nov 08 2000 - 06:15:43 CST