Bonjour,
Je suis sous Oracle 8.1.7.3.
Comment interpréter que mon nombre de parse soit plus grand que mon nombre d'execution et de fetch ?
Merci de vos suggestion.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 SELECT Dept_rayon.iddepartement_rayon AS iddepartement_rayon , Dept_rayon.Memo_structure AS Memo_structure , Departement.IDdepartement AS IDdepartement , Departement.Departement AS Departement , Rayon.IDRayon AS IDRayon , Rayon.libelle_rayon AS libelle_rayon , Dept_rayon.idholding AS idholding , Dept_rayon.idsociete AS idsociete , Dept_rayon.IDenseigne AS IDenseigne , Dept_rayon.IDEnseigne_departement AS IDEnseigne_departement , Affect_Achet.IDacheteur AS IDacheteur FROM Departement , Dept_rayon , Rayon , Enseigne_depart , Affect_Achet WHERE ( ( ( ( Departement.IDdepartement = Dept_rayon.IDdepartement ) AND ( Rayon.IDRayon = Dept_rayon.IDRayon ) ) AND ( Enseigne_depart.IDEnseigne_departement = Dept_rayon.IDEnseigne_departement ) ) AND ( Affect_Achet.iddepartement_rayon = Dept_rayon.iddepartement_rayon ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 1.72 1.72 6 314 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 1.72 1.72 6 314 0 0 SELECT ALL_IND_COLUMNS.INDEX_NAME, ALL_IND_COLUMNS.COLUMN_NAME, ALL_IND_COLUMNS.COLUMN_POSITION, ALL_INDEXES.UNIQUENESS FROM SYS.ALL_IND_COLUMNS,SYS.ALL_INDEXES WHERE ALL_IND_COLUMNS.INDEX_NAME= ALL_INDEXES.INDEX_NAME AND ALL_IND_COLUMNS.INDEX_OWNER=ALL_INDEXES.OWNER AND ALL_IND_COLUMNS.TABLE_OWNER='magali' AND ALL_IND_COLUMNS.TABLE_NAME= 'Magali_service' ORDER BY INDEX_NAME,COLUMN_POSITION DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 34 0.60 0.61 0 8 0 0 Execute 17 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.00 0 17 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 68 0.60 0.61 0 25 0 0
Partager