| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Migration
--0__=JRbG0NQm9wemX1UIiPxV5xeuDf5aFklIXOCYeKCjtC0gJLexj9NyrDvC
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
Thanks gurus ...
About Performance tunning ...
not exist clause helps a lot , now it takes nearly a second (i've got a 133
Mhz Processor)
Another one.
We are planning to migrate from Oracle 8i on Windows NT (133 Mhz)
to Oracle 8i Release 2 on Windows 2000 Advanced Server ( 2 procesors 700 Mhz)
suggestions ?? experiences ?? tips ??? ideas ??
We use a lot Oracle Utilities ...
Markus.
pd. And again ....sorry about english ???
Javier Morales <Javier_at_infojobs.net> on 08/11/2000 01:40:32 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
cc: (bcc: Marcos Vera/M&S Consultores/51)
Subject: RE: Performance tuning
--0__=JRbG0NQm9wemX1UIiPxV5xeuDf5aFklIXOCYeKCjtC0gJLexj9NyrDvC
Content-type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-transfer-encoding: quoted-printable
ENGLISH: I will write in BILINGUAL english-spanish but, please, don't t=
ake
it too serious... It's just a nice joke ;-)
SPANISH: Voy a escribir en BILING=DCE ingles-espa=F1ol pero, por favor,=
no lo
tomeis demasiado en serio... s=F3lo es una co=F1a graciosa ;-)
E: As I see, the only difference is the DECODE comparation values
S: Tal y como veo, la =FAnica diferencia es la comparaci=F3n de valores=
en el
DECODE
E: What about if you mix the two select statements using that...
S: Que tal si unes las dos consultas en una usando lo siguiente...
ENGLISH SELECT: SELECT PLA_FOL_LOT,
PLA_FOL_PLA,PLA_PER_DEV_REM,PLA_IDE_EMP,PLA_FEC_CAJ,PLA_TOT_OBL_INF,
PLA_TOT_VOL_INF,PLA_TOT_APO_EMP_INF,
PLA_TOT_APO_SEG_INF,PLA_TOT_COM_POR_INF,
PLA_PER_DEV_REM,
decode(Pla_fol_lot,
'0', decode(lot_num_pro,'140','AC','PN'),
'12', decode(lot_num_pro,'140','AC','PN')
'13', decode(lot_num_pro,'140','AC','PN') ) status,
PLA_IND_TIP_PLA
FROM RECPLA, Suplot
SPANISH SELECT: SELECCIONA PLA_FOL_LOT,
PLA_FOL_PLA,PLA_PER_DEV_REM,PLA_IDE_EMP,PLA_FEC_CAJ,PLA_TOT_OBL_INF,
PLA_TOT_VOL_INF,PLA_TOT_APO_EMP_INF,
PLA_TOT_APO_SEG_INF,PLA_TOT_COM_POR_INF,
PLA_PER_DEV_REM,
decodifica(Pla_fol_lot,
'0', decodifica(lot_num_pro,'140','AC','PN'),
'12', decodifica(lot_num_pro,'140','AC','PN')
'13', decodifica(lot_num_pro,'140','AC','PN') ) estado,
PLA_IND_TIP_PLA
E: As my last advice... how about an index for PLA_IDE_EMP. S: Como =FAltimo consejo... que tal un =EDndice para PLA_IDE_EMP.
E: Don't worry, Marcos, I think your mistake was not lingual (but
conceptual)... and I think it's no need for so much discussion!! ;-)
S: No te preocupes, Marcos, Pienso que tu equivocaci=F3n no fu=E9 idiom=
=E1tica
(sin=F3 conceptual) ... y creo que no hay necesidad de tanta pol=E9mica=
!! ;-)
Regads,
-----Mensaje original-----
De: Marcos.Vera_at_msconsultores.com.pe
[mailto:Marcos.Vera_at_msconsultores.com.pe]
Enviado el: mi=E9rcoles 8 de noviembre de 2000 17:17
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Performance tuning
hi gurus ....sorry im trying to optimize this query ...
unfortunately it takes nearly 20 seconds .....(it's a lot) ...
recpla --> 800000 records
Suplot --> 100000 records ...
SELECT PLA_FOL_LOT,
PLA_FOL_PLA,PLA_PER_DEV_REM,PLA_IDE_EMP,PLA_FEC_CAJ,PLA_TOT_OBL_INF, PLA_TOT_VOL_INF,PLA_TOT_APO_EMP_INF, PLA_TOT_APO_SEG_INF,PLA_TOT_COM_POR_INF, PLA_PER_DEV_REM,decode(lot_num_pro,'140','AC','PN') status ,PLA_IND_TIP=_PLA
PLA_FOL_PLA,PLA_PER_DEV_REM,PLA_IDE_EMP,PLA_FEC_CAJ,PLA_TOT_OBL_INF, PLA_TOT_VOL_INF,PLA_TOT_APO_EMP_INF, PLA_TOT_APO_SEG_INF,PLA_TOT_COM_POR_INF, PLA_PER_DEV_REM,decode(pla_fol_lot,'0','PN','AC') status ,PLA_IND_TIP_P=LA
WHERE PLA_IDE_EMP =3D'10004918'
and ( Pla_fol_lot =3D '0' OR
Pla_fol_lot not in (select lot_fol_lot from suplot where (lot_tip=
_lot
);
sorry about english ....
Markus ...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Marcos.Vera_at_msconsultores.com.pe
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L Received on Thu Nov 09 2000 - 09:30:24 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |