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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109
|
SQL_ID gwfry9f9jv77m, child number 0
-------------------------------------
SELECT /*+gather_plan_statistics*/ 'A' tab , t.appreciation_globale AS appreciation_globale, t.code_cours
, t.code_offre_de_cours , t.contenu_cours AS contenu_cours , t.departement_cours ,
t.departement_intervenant , t.enseignant , t.evaluation_terminee AS evaluation_terminee , t.groupe_intervenant
, t.heures_physiques AS heures_physiques , t.libelle_du_cours , t.moyenne_generale AS moyenne_generale
, t.nb_eleves AS nb_eleves , t.nb_eval AS nb_eval , t.periode ,
t.periode_academic_cours , t.promotion , t.qualite_outils AS qualite_outils , t
Plan hash value: 2516877017
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | Writes | OMem | 1Mem | Used-Mem | Used-Tmp|
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|* 1 | FILTER | | 1 | | 71 |00:01:57.48 | 7371K| 12163 | 5400 | | | | |
| 2 | HASH GROUP BY | | 1 | 1 | 84 |00:01:57.48 | 7371K| 12163 | 5400 | | | | |
|* 3 | HASH JOIN | | 1 | 1 | 12320 |00:01:57.57 | 7371K| 12163 | 5400 | 3077K| 929K| 3498K (0)| |
| 4 | VIEW | AVI_EVAL_ELEVE | 1 | 1 | 12392 |00:01:52.17 | 7172K| 8930 | 5400 | | | | |
| 5 | HASH GROUP BY | | 1 | 1 | 12392 |00:01:52.06 | 7172K| 8930 | 5400 | | | | |
|* 6 | HASH JOIN | | 1 | 1 | 150K|00:01:52.19 | 7172K| 8525 | 4995 | 42M| 3684K| 39M (1)| 43008 |
|* 7 | TABLE ACCESS BY INDEX ROWID | AEMSERVTIMEBLK | 1 | 9 | 150K|00:01:50.31 | 7172K| 3269 | 0 | | | | |
| 8 | NESTED LOOPS | | 1 | 1 | 163K|03:49:47.51 | 7150K| 3156 | 0 | | | | |
| 9 | NESTED LOOPS | | 1 | 1 | 12392 |00:01:49.06 | 7137K| 3125 | 0 | | | | |
| 10 | NESTED LOOPS | | 1 | 1 | 12392 |00:01:48.44 | 7113K| 2916 | 0 | | | | |
|* 11 | HASH JOIN | | 1 | 1 | 12392 |00:01:47.82 | 7088K| 2702 | 0 | 3411K| 925K| 3492K (0)| |
| 12 | NESTED LOOPS | | 1 | 1 | 12392 |00:01:01.11 | 7088K| 2688 | 0 | | | | |
| 13 | NESTED LOOPS | | 1 | 1 | 18588 |00:00:01.21 | 7057K| 2643 | 0 | | | | |
| 14 | NESTED LOOPS | | 1 | 1 | 2634K|00:00:47.52 | 1777K| 804 | 0 | | | | |
| 15 | NESTED LOOPS OUTER | | 1 | 1 | 135K|00:00:09.34 | 434K| 283 | 0 | | | | |
| 16 | NESTED LOOPS | | 1 | 1 | 135K|00:00:01.87 | 27111 | 282 | 0 | | | | |
| 17 | NESTED LOOPS | | 1 | 1 | 58 |00:00:00.06 | 2577 | 268 | 0 | | | | |
| 18 | NESTED LOOPS | | 1 | 1 | 250 |00:00:00.08 | 1825 | 268 | 0 | | | | |
| 19 | NESTED LOOPS | | 1 | 1 | 245 |00:00:00.07 | 1320 | 164 | 0 | | | | |
| 20 | NESTED LOOPS OUTER | | 1 | 1 | 245 |00:00:00.06 | 828 | 70 | 0 | | | | |
| 21 | NESTED LOOPS | | 1 | 1 | 245 |00:00:00.04 | 91 | 70 | 0 | | | | |
|* 22 | TABLE ACCESS BY INDEX ROWID| AGLDIMVALUE | 1 | 1 | 4 |00:00:00.02 | 16 | 9 | 0 | | | | |
|* 23 | INDEX RANGE SCAN | AIAGLDIMVALUE1 | 1 | 1 | 15 |00:00:00.02 | 3 | 2 | 0 | | | | |
|* 24 | TABLE ACCESS BY INDEX ROWID| AHSRELVALUE | 4 | 1 | 245 |00:00:00.03 | 75 | 61 | 0 | | | | |
|* 25 | INDEX RANGE SCAN | AIAHSRELVALUE2 | 4 | 21 | 252 |00:00:00.01 | 7 | 5 | 0 | | | | |
| 26 | TABLE ACCESS BY INDEX ROWID | AGLDIMVALUE | 245 | 1 | 245 |00:00:00.01 | 737 | 0 | 0 | | | | |
|* 27 | INDEX RANGE SCAN | AIAGLDIMVALUE1 | 245 | 1 | 245 |00:00:00.01 | 492 | 0 | 0 | | | | |
| 28 | TABLE ACCESS BY INDEX ROWID | AHSRESOURCES | 245 | 1 | 245 |00:00:00.02 | 492 | 94 | 0 | | | | |
|* 29 | INDEX UNIQUE SCAN | AIAHSRESOURCES1 | 245 | 1 | 245 |00:00:00.01 | 247 | 8 | 0 | | | | |
|* 30 | TABLE ACCESS BY INDEX ROWID | AHSRELVALUE | 245 | 1 | 250 |00:00:00.02 | 505 | 104 | 0 | | | | |
|* 31 | INDEX RANGE SCAN | AIAHSRELVALUE1 | 245 | 1 | 257 |00:00:00.01 | 248 | 78 | 0 | | | | |
|* 32 | TABLE ACCESS BY INDEX ROWID | AGLDIMVALUE | 250 | 1 | 58 |00:00:00.01 | 752 | 0 | 0 | | | | |
|* 33 | INDEX RANGE SCAN | AIAGLDIMVALUE1 | 250 | 1 | 250 |00:00:00.01 | 502 | 0 | 0 | | | | |
|* 34 | TABLE ACCESS FULL | AEMSERVICEOFF | 58 | 1 | 135K|00:00:01.39 | 24534 | 14 | 0 | | | | |
| 35 | TABLE ACCESS BY INDEX ROWID | AGLDIMVALUE | 135K| 1 | 135K|00:00:04.71 | 407K| 1 | 0 | | | | |
|* 36 | INDEX RANGE SCAN | AIAGLDIMVALUE1 | 135K| 1 | 135K|00:00:02.80 | 271K| 0 | 0 | | | | |
|* 37 | TABLE ACCESS BY INDEX ROWID | AEMENROLLMENT | 135K| 1 | 2634K|00:00:35.41 | 1343K| 521 | 0 | | | | |
|* 38 | INDEX RANGE SCAN | AIAEMENROLLMENT3 | 135K| 1 | 3082K|00:00:17.31 | 289K| 265 | 0 | | | | |
| 39 | TABLE ACCESS BY INDEX ROWID | AEWEVALRESP | 2634K| 1 | 18588 |00:01:13.05 | 5279K| 1839 | 0 | | | | |
|* 40 | INDEX RANGE SCAN | AIAEWEVALRESP3 | 2634K| 1 | 18588 |00:00:38.85 | 5276K| 368 | 0 | | | | |
| 41 | TABLE ACCESS BY INDEX ROWID | AEWEVALQUEST | 18588 | 1 | 12392 |00:00:00.61 | 30982 | 45 | 0 | | | | |
|* 42 | INDEX UNIQUE SCAN | AIAEWEVALQUEST1 | 18588 | 1 | 12392 |00:00:00.27 | 18590 | 19 | 0 | | | | |
|* 43 | TABLE ACCESS FULL | AEWTITLES | 1 | 1 | 4 |00:00:00.01 | 15 | 14 | 0 | | | | |
| 44 | TABLE ACCESS BY INDEX ROWID | AEMEPISODE | 12392 | 1 | 12392 |00:00:00.48 | 24786 | 214 | 0 | | | | |
|* 45 | INDEX UNIQUE SCAN | AIAEMEPISODE1 | 12392 | 1 | 12392 |00:00:00.21 | 12394 | 29 | 0 | | | | |
|* 46 | TABLE ACCESS BY INDEX ROWID | AEMSTUDENT | 12392 | 1 | 12392 |00:00:00.49 | 24786 | 209 | 0 | | | | |
|* 47 | INDEX UNIQUE SCAN | AIAEMSTUDENT2 | 12392 | 1 | 12392 |00:00:00.20 | 12394 | 21 | 0 | | | | |
|* 48 | INDEX RANGE SCAN | AIAEMSERVTIMEBLK2 | 12392 | 9 | 151K|00:00:00.78 | 12734 | 31 | 0 | | | | |
| 49 | TABLE ACCESS FULL | AEMSERVTIMELIST | 1 | 52580 | 52580 |00:00:00.21 | 264 | 261 | 0 | | | | |
| 50 | VIEW | AVI_EVAL_EFFECTIFS | 1 | 460 | 4643 |00:00:05.42 | 198K| 3233 | 0 | | | | |
|* 51 | FILTER | | 1 | | 4643 |00:00:05.39 | 198K| 3233 | 0 | | | | |
| 52 | HASH GROUP BY | | 1 | 460 | 5870 |00:00:05.39 | 198K| 3233 | 0 | | | | |
| 53 | NESTED LOOPS | | 1 | 9191 | 192K|00:00:07.89 | 198K| 3233 | 0 | | | | |
|* 54 | HASH JOIN | | 1 | 9191 | 192K|00:00:02.51 | 6029 | 3232 | 0 | 1088K| 1088K| 1368K (0)| |
|* 55 | TABLE ACCESS FULL | AEMSERVICEOFF | 1 | 10781 | 10781 |00:00:00.05 | 423 | 0 | 0 | | | | |
|* 56 | TABLE ACCESS FULL | AEMENROLLMENT | 1 | 193K| 192K|00:00:01.16 | 5606 | 3232 | 0 | | | | |
|* 57 | INDEX UNIQUE SCAN | AIAEMEPISODE1 | 192K| 1 | 192K|00:00:03.09 | 192K| 1 | 0 | | | | |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter(ROUND(SUM(TO_NUMBER("A"."QUALITE_PEDAGOGIQUE"))/COUNT(TO_NUMBER("A"."QUALITE_PEDAGOGIQUE")),2)>=3)
3 - access("A"."SERVICE_ID"="B"."SERVICE_ID" AND "A"."SERVICEOFF_ID"="B"."SERVICEOFF_ID")
6 - access("TBK"."SERVTIMEBLK_FK"="BLK"."SERVTIMEBLK_PK")
7 - filter(("BLK"."CLIENT"='P1' AND NVL("BLK"."DISABLED",0)<>1))
11 - access("TI"."TITLE_ID"="Q"."TITLE_CODE")
22 - filter("GL42"."REL_VALUE" LIKE '%P%')
23 - access("GL42"."CLIENT"='P1' AND "GL42"."ATTRIBUTE_ID"='C2')
24 - filter(("HS"."STATUS"='N' AND "HS"."CLIENT"='P1'))
25 - access("HS"."REL_ATTR_ID"='C2' AND "GL42"."DIM_VALUE"="HS"."REL_VALUE")
27 - access("GL22"."CLIENT"='P1' AND "GL22"."ATTRIBUTE_ID"='C2' AND "GL22"."DIM_VALUE"="HS"."REL_VALUE")
29 - access("RS"."CLIENT"='P1' AND "HS"."RESOURCE_ID"="RS"."RESOURCE_ID")
30 - filter("HS2"."STATUS"='N')
31 - access("HS2"."CLIENT"='P1' AND "HS2"."RESOURCE_ID"="RS"."RESOURCE_ID" AND "HS2"."REL_ATTR_ID"='32')
32 - filter(UPPER("GL32"."DESCRIPTION") LIKE '%FINANCE%')
33 - access("GL32"."CLIENT"='P1' AND "GL32"."ATTRIBUTE_ID"='32' AND "GL32"."DIM_VALUE"="HS2"."REL_VALUE")
34 - filter((SUBSTR("SO"."SERVICEOFF_ID",0,4)>='0910' AND "SO"."STATUS"='N' AND "SO"."CLIENT"='P1' AND "SO"."APP_PERIOD_FROM"<="HS2"."DATE_TO" AND
"SO"."APP_PERIOD_FROM">="HS2"."DATE_FROM" AND "SO"."APP_PERIOD_FROM"<="HS"."DATE_TO" AND "SO"."APP_PERIOD_FROM">="HS"."DATE_FROM"))
36 - access("GL2"."CLIENT"='P1' AND "GL2"."ATTRIBUTE_ID"='32' AND "GL2"."DIM_VALUE"="SO"."ED_DEPT")
37 - filter("RO"."STATUS"='N')
38 - access("RO"."CLIENT"='P1' AND "SO"."SERVICE_ID"="RO"."SERVICE_ID" AND "SO"."SERVICEOFF_ID"="RO"."SERVICEOFF_ID")
40 - access("RP"."CLIENT"='P1' AND "RO"."ENROLLMENT_PK"="RP"."ENROLLMENT_FK" AND "RS"."RESOURCE_ID"="RP"."RESOURCE_ID")
42 - access("RP"."QUESTION_FK"="Q"."QUESTION_PK" AND "Q"."QUESTION_TYPE"='R')
43 - filter((UPPER("TI"."CULTURE")='FR' AND INTERNAL_FUNCTION("TI"."TITLE")))
45 - access("EP"."CLIENT"='P1' AND "EP"."EPISODE_PK"="RO"."EPISODE_FK")
46 - filter("ST"."CLIENT"='P1')
47 - access("ST"."STUDENT_PK"="EP"."STUDENT_FK")
48 - access("BLK"."SERVICEOFF_FK"="SO"."SERVICEOFF_PK")
51 - filter(TO_NUMBER(TO_CHAR(COUNT(*)))>=15)
54 - access("SO"."SERVICE_ID"="RO"."SERVICE_ID" AND "SO"."SERVICEOFF_ID"="RO"."SERVICEOFF_ID")
55 - filter(("SO"."STATUS"='N' AND "SO"."CLIENT"='P1'))
56 - filter(("RO"."STATUS"='N' AND "RO"."CLIENT"='P1'))
57 - access("EP"."CLIENT"='P1' AND "EP"."EPISODE_PK"="RO"."EPISODE_FK") |
Partager