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
|
select v.SQL_TEXT, v.VERSION_COUNT, v.EXECUTIONS, v.PARSE_CALLS, v.MODULE
from v$sqlarea v
where sql_text like'call CLIENT.ENREGISTRER%'
order by v.VERSION_COUNT desc
1 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5,) 51 902 98 loader.exe
select v.SQL_TEXT, v.SHARABLE_MEM,v.EXECUTIONS,v.PARSE_CALLS,v.OPTIMIZER_MODE, v.OPTIMIZER_COST, v.PARSING_USER_ID, v.OBJECT_STATUS, v.LAST_LOAD_TIME
from v$sql v
where sql_text like'call CLIENT.ENREGISTRER%' order by 1 desc
SQL_TEXT HASH_VALUE SHARABLE_MEM
EXECUTIONS
PARSE_CALLS
PARSING_USER_ID
OBJECT_STATUS
LAST_LOAD_TIME
1 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
2 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
3 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
4 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
5 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
6 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
7 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
8 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
9 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
10 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
11 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
12 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
13 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
14 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
15 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
16 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
17 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
18 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
19 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
20 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
21 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
22 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
23 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
24 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
25 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
26 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
27 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
28 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
29 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
30 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
31 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
32 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
33 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
34 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
35 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
36 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
37 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
38 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
39 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
40 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
41 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
42 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
43 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
44 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
45 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
46 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
47 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
48 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
49 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 15655 324 63 CHOOSE 0 65 INVALID_UNAUTH 2005-09-13/13:55:19
50 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 6343 0 0 NONE 0
51 call CLIENT.ENREGISTRER (:1, :2, :3, :4, :5, :6) 2304951881 15955 581 37 CHOOSE 0 65 VALID 2005-09-13/23:19:49 |
Partager