| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORDER BY ..
Actually Patrice is another one of those French names that are also =
spelled
the same in English but are usually Female.
I have a sister with the name of Patrice.
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Wednesday, November 08, 2000 07:26
To: Multiple recipients of list ORACLE-L
Subject: RE: ORDER BY ..
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.
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 also send the HELP command for other information (like subscribing).
=09
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca
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 Received on Wed Nov 08 2000 - 13:48:51 CST
 |
 |