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
| SQL ordered by Executions for DB: PRISM Instance: prism Snaps: 9 -10
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
29,229,583 29,229,583 1.0 0.00 0.00 1905443809
Module: 01@ ././chgt_data.sql
SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME = UPPER(:B1
)
28,466,730 28,466,260 1.0 0.00 0.00 750253613
Module: 01@ ././chgt_data.sql
SELECT COUNT(*),DATA_TYPE,DATA_LENGTH,LENGTH(:B3 ) FROM USER_TAB
_COLUMNS WHERE TABLE_NAME = UPPER(:B2 ) AND COLUMN_NAME = UPPER(
:B1 ) GROUP BY DATA_TYPE,DATA_LENGTH
28,466,132 28,466,132 1.0 0.00 0.00 3306030551
Module: 01@ ././chgt_data.sql
SELECT DECODE(:B1 ,0,0,1) FROM DUAL
25,486,811 25,486,811 1.0 0.00 0.00 535965182
Module: 01@ ././chgt_data.sql
SELECT TO_DATE(:B2 ,:B1 ) FROM DUAL
18,829,158 18,829,158 1.0 0.00 0.00 2210046719
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'EUR'
9,441,513 9,441,513 1.0 0.00 0.00 1039060515
Module: 01@ ././chgt_data.sql
INSERT INTO TECHEANCIER_OPE ( OPE_CODE, EOP_LIGNE, EOP_ECHEANCE,
DEV_CODE, EOP_MNT ) VALUES ( :B9 , :B8 , TO_DATE(:B7 ,:B6 ), :B
5 , DECODE(:B4 , :B3 , :B1 , :B2 ,:B1 * -1, NULL ) )
9,275,684 9,275,684 1.0 0.00 0.00 3985980093
Module: 01@ ././chgt_data.sql
INSERT INTO TTAB_AMO ( CNC_ID, LTA_LIGNE, DEV_CODE, LTA_ECHEANCE
, LTA_MNT ) VALUES ( :B9 , :B8 , :B7 , TO_DATE(:B6 ,:B5 ), DECOD
E(:B4 , :B3 , :B1 , :B2 ,:B1 * -1, NULL ) )
2,658,922 2,658,922 1.0 0.00 0.00 1542652291
Module: 01@ ././chgt_data.sql
SELECT DEV_TX_DER_VAL FROM TDEVISE WHERE DEV_CODE = :B1
1,819,206 1,819,206 1.0 0.00 0.00 7799848
Module: 01@ ././chgt_data.sql
SELECT COUNT(*) FROM TTRANSACTION WHERE TRS_ID = :B1
1,819,206 1,819,206 1.0 0.00 0.00 3709267795
Module: 01@ ././chgt_data.sql
SELECT NUM_TRS_OPE.NEXTVAL FROM DUAL
1,053,246 1,053,246 1.0 0.00 0.00 2648372150
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'MAD'
974,311 932,902 1.0 0.00 0.00 406529650
Module: 01@ ././chgt_data.sql
SELECT PRD_CODE FROM TLIEN_CNC_PRD WHERE CNC_ID = :B2 AND LCP_NU
SQL ordered by Executions for DB: PRISM Instance: prism Snaps: 9 -10
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
M_ORDRE = :B1
956,553 956,426 1.0 0.00 0.00 3342429262
Module: 01@ ././chgt_data.sql
SELECT CLI_CODE FROM TLIEN_CNC_CLI WHERE CNC_ID = :B2 AND LCC_NU
M_ORDRE = :B1
850,636 850,636 1.0 0.00 0.00 4279462716
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'CZK'
749,258 749,258 1.0 0.00 0.00 1264812682
Module: 01@ ././chgt_data.sql
INSERT INTO TANO_OPERATION ( ANO_CODE, OPE_CODE, OBJET_CONCERNE
) VALUES ( :B3 , :B2 , :B1 )
199,868 199,868 1.0 0.00 0.00 566828053
SELECT CLI_CODE FROM TCLIENT WHERE CLI_SPM = UPPER(:B1 )
144,036 144,036 1.0 0.01 0.01 232652308
SELECT DISTINCT(LMS_NOM) FROM TMAT_TRANSITION_ST WHERE LMS_NOM =
:B1
144,036 144,036 1.0 0.00 0.00 483926244
SELECT CLI_CODE FROM TCLIENT WHERE CLI_CODE = :B2 AND ((CLI_STK_
MENSUEL = 'S' AND AGE_MATRICULE = :B1 ) OR CLI_STK_MENSUEL = 'M'
)
144,036 144,036 1.0 0.00 0.00 610255423
SELECT DECODE(:B6 , NULL,CLI.SEA_CODE_NAE, :B6 ), DECODE(:B5 , N
ULL, CLI.NES_CODE, :B5 ), DECODE(:B3 , NULL, :B4 , :B3 ), DECODE
(:B2 , NULL, CLI.PAY_CODE,:B2 ), CLI_POID FROM TCLIENT CLI WHERE
CLI.CLI_CODE = :B1
144,036 112,180 0.8 0.00 0.00 2320446532
SELECT VRA_VALEUR FROM TNOT_CLI WHERE CLI_CODE = :B1 AND RAR_COD
E = 'F' AND NAC_IND_LAST = 'O'
143,840 143,840 1.0 0.00 0.00 1240434274
SELECT PAY_VALIDE FROM TPAYS WHERE PAY_CODE = UPPER(:B1 )
143,840 143,840 1.0 0.00 0.00 2142121516
SELECT P.ZNC_CODE FROM TPAYS P WHERE P.PAY_CODE = UPPER(:B1 )
143,840 143,840 1.0 0.00 0.00 2429470646
SELECT PAR_VAL FROM TPARAM_IMPORT WHERE PAR_ID = :B1
142,484 142,484 1.0 0.00 0.00 729620379
SELECT COUNT(*) FROM TLIAISON_NESSG WHERE NES_CODE = :B1
134,099 134,099 1.0 0.00 0.00 3510666704
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'USD'
SQL ordered by Executions for DB: PRISM Instance: prism Snaps: 9 -10
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
120,085 120,085 1.0 0.00 0.00 3306580469
Module: 01@ ././chgt_data.sql
INSERT INTO TTAB_DEC_PREVISIONNEL ( CNC_ID, EOP_LIGNE, EOP_ECHEA
NCE, DEV_CODE, EOP_MNT ) VALUES ( :B9 , :B8 , TO_DATE(:B7 ,:B6 )
, :B5 , DECODE(:B4 , :B3 , :B1 , :B2 ,:B1 * -1, NULL ) )
119,503 119,503 1.0 0.00 0.00 1150157760
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'GBP'
93,967 93,967 1.0 0.00 0.00 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1
73,489 73,489 1.0 0.00 0.00 1629880597
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'XOF'
73,470 73,470 1.0 0.00 0.00 3964047003
Module: 01@ ././chgt_data.sql
SELECT count(*) FROM TDEVISE WHERE DEV_CODE = 'EGP'
73,165 60,072 0.8 0.00 0.00 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
72,018 55,832 0.8 0.01 0.01 1207495168
BEGIN pck_simulation.INSERT_PARAM_SIM_CLI_ST(:1,:2,:3,:4,:5, :6,
:7,:8,:9); END;
72,018 55,832 0.8 0.01 0.01 3110109129
BEGIN pck_simulation.pVerif_Param_Sim_Cli_ST(:1,:2,:3,:4,:5, :6,
:7,:8); END;
62,483 165,829 2.7 0.00 0.00 4259837204
Module: exp@PRPDEF501 (TNS V1-V3)
SELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_
RAW(ENDPTVAL) ENDPTVAL_RAW FROM SYS.EXU8HST WHERE P
OBJID = :1 AND INTCOL = :2 ORDER BY BUCKET
55,832 55,832 1.0 0.00 0.00 3076559786
SELECT COUNT(*) FROM TPARAM_SIM_CLI_ST WHERE SIM_ID = :B2 AND CL
I_CODE = :B1 |
Partager