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
|
********************************************************************************
SELECT COUNT(*)
FROM
ACTPRO A,PROTDO P WHERE P.ID_PROF=A.ID_PROF AND A.ID_ACTR=:B2 AND
P.ID_TYPEDOSS=:B1 AND PACK_NOMENC.VALIDITE( A.DATEDEBU , A.DATEFIN ) = 'O'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 332149 8.13 13.98 0 0 0 0
Fetch 332149 17.13 30.62 23 2325043 0 332149
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 664299 25.26 44.61 23 2325043 0 332149
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 562 (recursive depth: 1)
********************************************************************************
********************************************************************************
Select A.DSOC,E.NOME,E.LIBL,A.DSOC,DECODE(C.INDSPRIN,'O','P',' '),
DECODE(D.DECE,'O','*',' '),D.NOM ||' '||D.PREN,nvl(lpad(D.JOURNAIS,2,'0'),
'__') ||'/'|| nvl(lpad(D.MOISNAIS,2,'0'),'__') ||'/'|| nvl(lpad(D.ANNENAIS,
4,'0'),'____'),H.NOM_PREN,C.APPADOSS,'',D.ID,A.ID
from
DOSSOC A,INDSOC C,NOMENC E,ACTEUR H,PORTEF G,BASES J,INDIVI D where D.NOM=
'BOUDOU' and A.NATU='F' AND D.INDI=C.INDI AND C.DSOC=A.DSOC AND E.ID=
A.ID_TYPEDOSS AND G.ID=A.ID_PORT AND H.ID = G.ID_ACTR AND A.ID_ACTRLOCA =
J.ID and pack_habi.habilist(328437,A.ID_TYPEDOSS,A.DSOC,'','')='O' order by
D.NOM,D.PREN,D.ANNENAIS,D.MOISNAIS,D.JOURNAIS,A.DSOC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 4 0.04 0.04 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 4 12.07 17.77 13606 858626 0 26
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10 12.11 17.82 13606 858626 0 26
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 561
******************************************************************************** |
Partager