| 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: Snapshot performance issue
I forgot to tell you that I'm working on release 8.1.7 and if I'm not mistaken indexes like 'SNAP_$' do no more exist. Please, correct me if I'm mistaken.
-----Message d'origine-----
De : Mike J Kurth [mailto:Mike.J.Kurth_at_aexp.com]
Envoyé : mardi 11 septembre 2001 08:25
À : Multiple recipients of list ORACLE-L
Objet : Re: Snapshot performance issue
It may be that the name of your index has changed. It is probably something like I_snap$_E I_REF_EMETTEUR.
You will need to change the hint to reflect the change.
01 01:40
AM PST Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:
I have a view based on the query below which is executed in a reasonable
way
on the master site but this same view takes hours on the snapshot site.
Any
idea
CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS
select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E
I_REF_EMETTEUR)
*/
E.COMP_EMETTEUR, E.NOM_STATION, E.REF_EMETTEUR, E.PIRE, E.PIRE_CALCULEE,
E.HAUT_SOL_ANT, E.AZIMUT, E.ELEVATION, E.OWNER, E.CODE_INTERNE_TS,
E.CODE_INTERNE_TC, E.DEP_CODE_GESTION, SY.COMP_SYSTEME, SY.NOM_SYSTEME,
O.COMP_OPERATEUR, O.CODE_OPERATEUR, SI.COMP_SITE, SI.REF_SITE,
SI.NOM_SITE,
A.COMP_ANTENNE, A.NOM_ANT, MO.REF_MODU, AM.REF_AMPLI, MR.REF_MAT_RECEPT,
LF.CODE_ETAT, ST.CODE
from t_station E, t_antena A, t_site SI, t_system SY, t_operator O,
t_lf_states LF,
v_station_modu MO, v_station_ampli AM, v_station_recept MR, t_status ST
where E.COMP_SYSTEME = SY.COMP_SYSTEME and E.COMP_OPERATEUR =
O.COMP_OPERATEUR
and E.COMP_SYSTEME = O.COMP_SYSTEME and E.COMP_SITE = SI.COMP_SITE
and E.COMP_ANTENNE = A.COMP_ANTENNE and E.COMP_EMETTEUR =
MO.COMP_EMETTEUR
(+)
and E.COMP_EMETTEUR = AM.COMP_EMETTEUR(+) and E.COMP_EMETTEUR =
MR.COMP_EMETTEUR(+)
and not (E.SUPPR_A_ANALYSER_FAE is not null and E.SUPPR_A_ANALYSER_FAE
= 'O')
and E.TYPE_STATION = LF.COMP_ETATS and E.COMP_STATUS = ST.COMP_STATUS(+)
and exists (select 1 from v_mygroup_users
where E.owner=user_name and rownum<=1);
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: Mike.J.Kurth_at_aexp.com 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 (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: abiy.alemu_at_criltelecom.com 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 (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Sep 11 2001 - 01:35:55 CDT
 |
 |