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 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188
|
SQL ordered by CPU DB/Inst: GUF/guf Snaps: 131-133
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 10
-> Captured SQL accounts for 85.7% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
1.59 2 0.80 15.3 2.07 17,427 333476733
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1.05 71 0.01 10.1 1.28 160,031 231290128
Module: frmweb.exe
SELECT ROWID,DOS_GUF_CODE,DOS_NUMERO,ETAP_ACTE_CODE,ACTEUR_CODE,
ETAP_TRAI_CODE,ETAP_TA_CODE,ETAP_NUM_ORDRE,LD_NUM_LOT,DATE_DEBUT
,DATE_FIN,ETAT_ETAPE,MOTIF_REJET,OBSERVATION,DATE_DEBUT_REEL,DAT
E_FIN_REEL FROM ETAPE_DOSSIER WHERE dos_guf_code=:1 and dos_nume
ro=:2 and etap_acte_code=:3 and (DOS_GUF_CODE=:4) and (DOS_NUMER
0.91 42 0.02 8.8 1.08 15,792 976446690
Module: frmweb.exe
SELECT NVL(MAX (SUBSTR(LPAD(NUMERO , 20 , '0' ) , -20 , 10 ) )
, 0 ) + 1 FROM DOSSIER
0.54 55 0.01 5.2 0.69 12,148 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
0.45 36 0.01 4.3 0.60 13,318 2727156606
Module: frmweb.exe
select ROLE GRPNAME ,FLAG GRPFLG from FRM50_ENABLED_ROLES orde
r by ROLE desc
0.40 74 0.01 3.9 0.53 15,075 3785553856
Module: frmweb.exe
SELECT ROWID,AP_ACTE_CODE,DOS_GUF_CODE,DOS_NUMERO,AP_PIE_CODE,FO
URNIE FROM PIECE_FOURNIE WHERE AP_acte_code=:1 and dos_guf_code=
:2 and dos_numero=:3 and (AP_ACTE_CODE=:4) and (DOS_GUF_CODE=:5)
and (DOS_NUMERO=:6)
0.39 24 0.02 3.8 0.39 30,079 3873092949
Module: frmweb.exe
SELECT ALL DOSSIER.NUMERO, DOSSIER.GUF_CODE, DOSSIER.DATE_DEPOT,
DOSSIER.ETAT_DOSSIER, DOSSIER.TYPE_PARCELLE FROM DOSSIER WHERE
DOSSIER.ETAT_DOSSIER = 'ATTENTE' and DOSSIER.GUF_CODE = :1
0.33 8,661 0.00 3.2 0.33 51,865 3787173813
Module: javaw.exe
SELECT LIBELLE FROM NOMBRE WHERE CODE = :1
0.28 4,267 0.00 2.7 0.28 42,670 80611585
Module: javaw.exe
SELECT AG.NOM || ' ' || AG.PRENOM FROM AGENT AG WHERE UPPE
R(AG.CODE ) = (SELECT UPPER(AGENT_CODE ) FROM SESSION_CAISSE
SQL ordered by CPU DB/Inst: GUF/guf Snaps: 131-133
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 10
-> Captured SQL accounts for 85.7% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
WHERE CODE = :1 )
0.23 44 0.01 2.2 0.23 26,856 297487287
Module: frmweb.exe
SELECT CODE FROM PARCELLE WHERE NUMERO = :1 AND LOT_NUMERO =
:1 AND SECTION_NUMERO = :1
0.23 16 0.01 2.2 0.23 103,446 1531467468
Module: javaw.exe
SELECT ALL PAIEMENT.NUM_QUITTANCE, PAIEMENT.DATE_PAI, PAIEMENT.M
ODE_PAI, PAIEMENT.BANQUE, PAIEMENT.INFO_CHEQUE, PAIEMENT.NUM_RE
CU_CARTE, PAIEMENT.MONTANT_PAI, ACTE.LIBELLE ACTE, DOSSIER.NUME
RO dos_num, SECTEUR_VILLAGE.NUMERO secteur_nuM, SECTION.NUMERO s
ection_num, LOT.NUMERO lot_num, PARCELLE.NUMERO parcelle_numero
0.22 17 0.01 2.1 0.22 21,549 3633342607
Module: frmweb.exe
SELECT ALL COMMISSION.CODE, COMMISSION.LIBELLE commission, COMMI
SSION.GUF_CODE FROM COMMISSION WHERE code in (select comis_code
from dossier) and commission.guf_code=:1
0.20 19 0.01 1.9 0.26 24,133 368804450
Module: frmweb.exe
SELECT DOSSIER.NUMERO num_dossier, ACTE.LIBELLE ACTE_lib, DOSSIE
R.GUF_CODE FROM DOSSIER, ACTE WHERE ( (DOSSIER.ACTE_CODE = ACTE.
CODE) ) AND DOSSIER.GUF_CODE=:1 and TYPE_ACTE='CONSTAT' and doss
ier.comis_code= :2
0.19 20 0.01 1.9 0.26 24,879 3500326148
Module: frmweb.exe
SELECT COUNT (*) FROM DOSSIER WHERE PAR_CODE = :1 AND ETAT_D
OSSIER != 'ACCORDE'
0.16 249 0.00 1.6 0.18 6,618 1120568383
select parent_owner,parent_name,parent_link_name,parent_type,par
ent_timestamp,property from ora_kglr7_dependencies where owner=:
1 and name=:2 and type=:3 and obj#=:4 order by order_number
0.15 4,267 0.00 1.4 0.15 38,404 1755727275
Module: javaw.exe
SELECT 'Secteur ' || SECTEUR_VILLAGE.NUMERO || ' Section '
|| SECTION.NUMERO || ' Lot ' || LOT.NUMERO || ' Parcell
e ' || PARCELLE.NUMERO FROM PARCELLE , LOT , SECTEUR_VILLAGE
, SECTION WHERE ( ( PARCELLE.LOT_NUMERO = LOT.NUMERO ) AND
( PARCELLE.SECTION_NUMERO = LOT.SECTION_NUMERO ) AND ( LOT.SEC
0.12 4,267 0.00 1.1 0.12 12,801 808444546
Module: javaw.exe
SELECT DECODE(PERS_TYPE , 'P' , TITRE || ' ' || NOM || DECO
DE(NOM_JF , NULL , '' , ' Nee ' || NOM_JF ) || ' ' || P
SQL ordered by CPU DB/Inst: GUF/guf Snaps: 131-133
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 10
-> Captured SQL accounts for 85.7% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
Instance Activity Stats DB/Inst: GUF/guf Snaps: 131-133
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 740 0.2 1.4
CPU used when call started 499 0.1 0.9
CR blocks created 234 0.1 0.4
Cached Commit SCN referenced 272 0.1 0.5
Commit SCN cached 1 0.0 0.0
DB time 1,227,916 340.4 2,253.1
DBWR checkpoint buffers written 1,930 0.5 3.5
DBWR checkpoints 0 0.0 0.0
DBWR transaction table writes 120 0.0 0.2
DBWR undo block writes 349 0.1 0.6
IMU CR rollbacks 216 0.1 0.4
IMU Flushes 159 0.0 0.3
IMU Redo allocation size 332,288 92.1 609.7
IMU commits 373 0.1 0.7
IMU contention 31 0.0 0.1
IMU recursive-transaction flush 3 0.0 0.0
IMU undo allocation size 1,284,472 356.1 2,356.8
PX local messages recv'd 0 0.0 0.0
PX local messages sent 0 0.0 0.0
SMON posted for undo segment shri 1 0.0 0.0
SQL*Net roundtrips to/from client 48,359 13.4 88.7
active txn count during cleanout 396 0.1 0.7
application wait time 1,028,632 285.2 1,887.4
background timeouts 11,542 3.2 21.2
buffer is not pinned count 308,045 85.4 565.2
buffer is pinned count 4,332,628 1,201.2 7,949.8
bytes received via SQL*Net from c 6,828,241 1,893.1 12,528.9
bytes sent via SQL*Net to client 13,655,874 3,785.9 25,056.7
calls to get snapshot scn: kcmgss 76,934 21.3 141.2
calls to kcmgas 1,538 0.4 2.8
calls to kcmgcs 80 0.0 0.2
change write time 20 0.0 0.0
cleanout - number of ktugct calls 382 0.1 0.7
cleanouts and rollbacks - consist 226 0.1 0.4
cleanouts only - consistent read 7 0.0 0.0
cluster key scan block gets 6,449 1.8 11.8
cluster key scans 1,771 0.5 3.3
commit batch/immediate performed 6 0.0 0.0
commit batch/immediate requested 6 0.0 0.0
commit cleanout failures: callbac 24 0.0 0.0
commit cleanout failures: cannot 2 0.0 0.0
commit cleanouts 2,696 0.8 5.0
commit cleanouts successfully com 2,670 0.7 4.9
commit immediate performed 6 0.0 0.0
commit immediate requested 6 0.0 0.0
commit txn count during cleanout 86 0.0 0.2
concurrency wait time 113 0.0 0.2
consistent changes 376 0.1 0.7
consistent gets 673,503 186.7 1,235.8
consistent gets - examination 157,418 43.6 288.8
consistent gets from cache 673,503 186.7 1,235.8
cursor authentications 229 0.1 0.4
data blocks consistent reads - un 318 0.1 0.6
db block changes 14,031 3.9 25.7
db block gets 14,909 4.1 27.4
db block gets direct 18 0.0 0.0 |
Partager