Dear all,
We have a problem with a query .. query takes 20 minutes in 10g RAC DB where as the same query is taking 3 hours in 11g RAC with out any output.. same sructure of objects in both the db.stats are up to date.
d: 10.2.0.4.0
11.1.0.7.0
solaris 5.10
Original query :
11g explain plan
SQL> select * from table(dbms_xplan.display);
---------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 108K| 40M| 2647 (1)| 00:00:38 |
| 1 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 32 | 4 (0)| 00:00:01 |
|* 2 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 3 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 14 | 3 (0)| 00:00:01 |
|* 4 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 2 (0)| 00:00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 35 | 3 (0)| 00:00:01 |
|* 6 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 2 (0)| 00:00:01 |
| 7 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 15 | 3 (0)| 00:00:01 |
|* 8 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 2 (0)| 00:00:01 |
| 9 | SORT GROUP BY NOSORT | | 4 | 128 | 18 (6)| 00:00:01 |
| 10 | VIEW | | 4 | 128 | 18 (6)| 00:00:01 |
| 11 | UNION-ALL | | | | | |
|* 12 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 3 (0)| 00:00:01 |
|* 13 | FILTER | | | | | |
| 14 | SORT GROUP BY | | 1 | 48 | 8 (13)| 00:00:01 |
| 15 | NESTED LOOPS | | | | | |
| 16 | NESTED LOOPS | | 1 | 48 | 7 (0)| 00:00:01 |
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------------------------------
| 17 | TABLE ACCESS BY INDEX ROWID| IVM_INVOICE_RECORD | 1 | 26 | 4 (0)| 00:00:01 |
|* 18 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 3 (0)| 00:00:01 |
|* 19 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 2 (0)| 00:00:01 |
| 20 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 3 (0)| 00:00:01 |
|* 21 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 3 (0)| 00:00:01 |
|* 22 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 4 (0)| 00:00:01 |
|* 23 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 3 (0)| 00:00:01 |
| 24 | SORT GROUP BY NOSORT | | 4 | 128 | 18 (6)| 00:00:01 |
| 25 | VIEW | | 4 | 128 | 18 (6)| 00:00:01 |
| 26 | UNION-ALL | | | | | |
|* 27 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 3 (0)| 00:00:01 |
|* 28 | FILTER | | | | | |
| 29 | SORT GROUP BY | | 1 | 48 | 8 (13)| 00:00:01 |
| 30 | NESTED LOOPS | | | | | |
| 31 | NESTED LOOPS | | 1 | 48 | 7 (0)| 00:00:01 |
| 32 | TABLE ACCESS BY INDEX ROWID| IVM_INVOICE_RECORD | 1 | 26 | 4 (0)| 00:00:01 |
|* 33 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 3 (0)| 00:00:01 |
|* 34 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 2 (0)| 00:00:01 |
| 35 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 3 (0)| 00:00:01 |
|* 36 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 3 (0)| 00:00:01 |
|* 37 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 4 (0)| 00:00:01 |
|* 38 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 3 (0)| 00:00:01 |
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------------------------------
| 39 | SORT GROUP BY NOSORT | | 4 | 232 | 18 (6)| 00:00:01 |
| 40 | VIEW | | 4 | 232 | 18 (6)| 00:00:01 |
| 41 | UNION-ALL | | | | | |
|* 42 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 3 (0)| 00:00:01 |
|* 43 | FILTER | | | | | |
| 44 | SORT GROUP BY | | 1 | 48 | 8 (13)| 00:00:01 |
| 45 | NESTED LOOPS | | | | | |
| 46 | NESTED LOOPS | | 1 | 48 | 7 (0)| 00:00:01 |
| 47 | TABLE ACCESS BY INDEX ROWID| IVM_INVOICE_RECORD | 1 | 26 | 4 (0)| 00:00:01 |
|* 48 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 3 (0)| 00:00:01 |
|* 49 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 2 (0)| 00:00:01 |
| 50 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 3 (0)| 00:00:01 |
|* 51 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 3 (0)| 00:00:01 |
|* 52 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 4 (0)| 00:00:01 |
|* 53 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 3 (0)| 00:00:01 |
| 54 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 12 | 4 (0)| 00:00:01 |
|* 55 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 56 | TABLE ACCESS BY INDEX ROWID | CRM_FREE_NUMBERS_04DEC2008_LOG | 1 | 15 | 4 (0)| 00:00:01 |
|* 57 | INDEX RANGE SCAN | SUBNO_IDX1 | 1 | | 3 (0)| 00:00:01 |
| 58 | SORT AGGREGATE | | 1 | 31 | | |
|* 59 | TABLE ACCESS BY INDEX ROWID | CRM_ACTION_HISTORY | 1 | 31 | 8 (0)| 00:00:01 |
|* 60 | INDEX RANGE SCAN | CRM_SOHIST_PK | 4 | | 3 (0)| 00:00:01 |
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------------------------------
| 61 | TABLE ACCESS BY USER ROWID | CRM_ACTION_HISTORY | 1 | 19 | 1 (0)| 00:00:01 |
| 62 | SORT AGGREGATE | | 1 | 35 | | |
|* 63 | TABLE ACCESS BY INDEX ROWID | CRM_ACTION_HISTORY | 1 | 35 | 8 (0)| 00:00:01 |
|* 64 | INDEX RANGE SCAN | CRM_SOHIST_PK | 4 | | 3 (0)| 00:00:01 |
| 65 | SORT AGGREGATE | | 1 | 37 | | |
|* 66 | TABLE ACCESS BY INDEX ROWID | CCM_LOG | 1 | 37 | 12 (0)| 00:00:01 |
|* 67 | INDEX RANGE SCAN | CCM_LOG_N1 | 12 | | 3 (0)| 00:00:01 |
| 68 | SORT AGGREGATE | | 1 | 34 | | |
|* 69 | TABLE ACCESS BY INDEX ROWID | CCM_LOG | 1 | 34 | 12 (0)| 00:00:01 |
|* 70 | INDEX RANGE SCAN | CCM_LOG_N1 | 12 | | 3 (0)| 00:00:01 |
| 71 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 11 | 4 (0)| 00:00:01 |
|* 72 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 73 | SORT AGGREGATE | | 1 | 34 | | |
|* 74 | TABLE ACCESS BY INDEX ROWID | CCM_LOG | 1 | 34 | 12 (0)| 00:00:01 |
|* 75 | INDEX RANGE SCAN | CCM_LOG_N1 | 12 | | 3 (0)| 00:00:01 |
| 76 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 3 (0)| 00:00:01 |
|* 77 | INDEX RANGE SCAN | CRM_MACODE_LANG_TEST | 1 | | 2 (0)| 00:00:01 |
| 78 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 2 (0)| 00:00:01 |
|* 79 | INDEX RANGE SCAN | CRM_MACODE_LANG_X1 | 1 | | 1 (0)| 00:00:01 |
| 80 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 11 | 4 (0)| 00:00:01 |
|* 81 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 82 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 15 | 4 (0)| 00:00:01 |
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------------------------------
|* 83 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 84 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 14 | 4 (0)| 00:00:01 |
|* 85 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 86 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 22 | 4 (0)| 00:00:01 |
|* 87 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 88 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 24 | 3 (0)| 00:00:01 |
|* 89 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 2 (0)| 00:00:01 |
| 90 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 36 | 4 (0)| 00:00:01 |
|* 91 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 3 (0)| 00:00:01 |
| 92 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 2 (0)| 00:00:01 |
|* 93 | INDEX RANGE SCAN | CRM_MACODE_LANG_X1 | 1 | | 1 (0)| 00:00:01 |
| 94 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 13 | 3 (0)| 00:00:01 |
|* 95 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 2 (0)| 00:00:01 |
| 96 | VIEW | | 108K| 40M| 2647 (1)| 00:00:38 |
|* 97 | TABLE ACCESS FULL | CCM_USER_INFO | 108K| 3390K| 2647 (1)| 00:00:38 |
---------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("U"."SUBNO"=:B1)
4 - access("D"."CONTRNO"=:B1)
6 - access("D"."CONTRNO"=:B1)
8 - access("D"."CONTRNO"=:B1)
12 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
13 - filter(SUM(NVL("AR_AM_LOC",0))<>0)
18 - access("H"."CONTRNO"=:B1)
filter(NVL("H"."SUBNO",'0000000')=:B1)
19 - access("R"."CONTRNO"=:B1 AND "R"."AR_REF"="H"."AR_REF")
filter("R"."CONTRNO"="H"."CONTRNO")
21 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
22 - filter(NVL("BILLED",'N')<>'Y')
23 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
27 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
28 - filter(SUM(NVL("AR_AM_LOC",0))<>0)
33 - access("H"."CONTRNO"=:B1)
filter(NVL("H"."SUBNO",'0000000')=:B1)
34 - access("R"."CONTRNO"=:B1 AND "R"."AR_REF"="H"."AR_REF")
filter("R"."CONTRNO"="H"."CONTRNO")
36 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
37 - filter(NVL("BILLED",'N')<>'Y')
38 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
42 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
43 - filter(SUM(NVL("AR_AM_LOC",0))<>0)
48 - access("H"."CONTRNO"=:B1)
filter(NVL("H"."SUBNO",'0000000')=:B1)
49 - access("R"."CONTRNO"=:B1 AND "R"."AR_REF"="H"."AR_REF")
filter("R"."CONTRNO"="H"."CONTRNO")
51 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
52 - filter(NVL("BILLED",'N')<>'Y')
53 - access("CONTRNO"=:B1 AND "SUBNO"=:B2)
55 - access("SUBNO"=:B1)
57 - access("SUBNO"=:B1)
59 - filter("H"."CONTRNO"=:B1 AND ("SOTYPE"=10 OR "SOTYPE"=80))
60 - access("H"."SUBNO"=:B1)
63 - filter("H"."CONTRNO"=:B1 AND ("SOTYPE"=10 OR "SOTYPE"=80))
64 - access("H"."SUBNO"=:B1)
66 - filter("ACTION_PARAM"='WARN' AND "ACTION"='ORDER' AND ("CCLOOP_STAGE"=1 OR "CCLOOP_STAGE"=10))
67 - access("USER_CODE"=:B1 AND "USER_TYPE"='SUB')
69 - filter("ACTION_PARAM"='DINP' AND "ACTION"='ORDER')
70 - access("USER_CODE"=:B1 AND "USER_TYPE"='SUB')
72 - access("U"."SUBNO"=:B1)
74 - filter("ACTION_PARAM"='DINP' AND "ACTION"='ORDER')
75 - access("USER_CODE"=:B1 AND "USER_TYPE"='SUB')
77 - access("CODENAME"='SUSTAT')
filter(TO_NUMBER("CODE")=:B1)
79 - access("CODENAME"='NUM_TYPE' AND "CODE"= (SELECT "NUM_TYPE" FROM "TABSRPT"."CRM_USER_INFO" "I" WHERE
"I"."SUBNO"=:B1))
81 - access("I"."SUBNO"=:B1)
83 - access("I"."SUBNO"=:B1)
85 - access("I"."SUBNO"=:B1)
87 - access("I"."SUBNO"=:B1)
89 - access("I"."CONTRNO"=:B1)
91 - access("I"."SUBNO"=:B1)
93 - access("CODENAME"='NATIONALLITY' AND "CODE"= (SELECT "NATIONALLITY" FROM "TABSRPT"."CRM_DEPARTEMENT"
"I" WHERE "I"."CONTRNO"=:B1))
95 - access("I"."CONTRNO"=:B1)
97 - filter("USER_TYPE"='SUB')
10g explain plan
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Pstart| Pstop |
---------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 110K| 41M| 2124 (1)| | |
| 1 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 12 | 1 (0)| | |
| 2 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 3 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 14 | 1 (0)| | |
| 4 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 1 (0)| | |
| 5 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 35 | 1 (0)| | |
| 6 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 1 (0)| | |
| 7 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 15 | 1 (0)| | |
| 8 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 1 (0)| | |
| 9 | SORT GROUP BY NOSORT | | 4 | 128 | 6 (17)| | |
| 10 | VIEW | | 4 | 128 | 6 (17)| | |
| 11 | UNION-ALL | | | | | | |
| 12 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 1 (0)| | |
| 13 | FILTER | | | | | | |
| 14 | SORT GROUP BY | | 1 | 48 | 3 (34)| | |
| 15 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 1 (0)| | |
| 16 | NESTED LOOPS | | 1 | 48 | 2 (0)| | |
| 17 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_RECORD | 1 | 26 | 1 (0)| | |
| 18 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 1 (0)| | |
| 19 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 1 (0)| | |
| 20 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 1 (0)| | |
| 21 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 1 (0)| | |
| 22 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 1 (0)| | |
| 23 | SORT GROUP BY NOSORT | | 4 | 128 | 6 (17)| | |
| 24 | VIEW | | 4 | 128 | 6 (17)| | |
| 25 | UNION-ALL | | | | | | |
| 26 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 1 (0)| | |
| 27 | FILTER | | | | | | |
| 28 | SORT GROUP BY | | 1 | 48 | 3 (34)| | |
| 29 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 1 (0)| | |
| 30 | NESTED LOOPS | | 1 | 48 | 2 (0)| | |
| 31 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_RECORD | 1 | 26 | 1 (0)| | |
| 32 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 1 (0)| | |
| 33 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 1 (0)| | |
| 34 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 1 (0)| | |
| 35 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 1 (0)| | |
| 36 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 1 (0)| | |
| 37 | SORT GROUP BY NOSORT | | 4 | 232 | 6 (17)| | |
| 38 | VIEW | | 4 | 232 | 6 (17)| | |
| 39 | UNION-ALL | | | | | | |
| 40 | INDEX RANGE SCAN | CRM_USER_INFO_N1 | 1 | 20 | 1 (0)| | |
| 41 | FILTER | | | | | | |
| 42 | SORT GROUP BY | | 1 | 48 | 3 (34)| | |
| 43 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_DETAIL | 1 | 22 | 1 (0)| | |
| 44 | NESTED LOOPS | | 1 | 48 | 2 (0)| | |
| 45 | TABLE ACCESS BY INDEX ROWID | IVM_INVOICE_RECORD | 1 | 26 | 1 (0)| | |
| 46 | INDEX RANGE SCAN | IVM_ARINV_HEAD_X1 | 1 | | 1 (0)| | |
| 47 | INDEX RANGE SCAN | IVM_ARINV_ROWS_X1 | 1 | | 1 (0)| | |
| 48 | INDEX RANGE SCAN | CRM_USER_EQUIPMENTS_N1 | 1 | 22 | 1 (0)| | |
| 49 | TABLE ACCESS BY INDEX ROWID | IVM_BILLING | 1 | 26 | 1 (0)| | |
| 50 | INDEX RANGE SCAN | IVM_BICHARGE_X2 | 1 | | 1 (0)| | |
| 51 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 12 | 1 (0)| | |
| 52 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 53 | TABLE ACCESS BY INDEX ROWID | CRM_FREE_NUMBERS_04DEC2008_LOG | 1 | 15 | 1 (0)| | |
| 54 | INDEX RANGE SCAN | SUBNO_IDX1 | 1 | | 1 (0)| | |
| 55 | SORT AGGREGATE | | 1 | 31 | | | |
| 56 | TABLE ACCESS BY INDEX ROWID | CRM_ACTION_HISTORY | 1 | 31 | 2 (0)| | |
| 57 | INDEX RANGE SCAN | CRM_SOHIST_PK | 4 | | 1 (0)| | |
| 58 | TABLE ACCESS BY USER ROWID | CRM_ACTION_HISTORY | 1 | 19 | 1 (0)| | |
| 59 | SORT AGGREGATE | | 1 | 35 | | | |
| 60 | TABLE ACCESS BY INDEX ROWID | CRM_ACTION_HISTORY | 1 | 35 | 2 (0)| | |
| 61 | INDEX RANGE SCAN | CRM_SOHIST_PK | 4 | | 1 (0)| | |
| 62 | SORT AGGREGATE | | 1 | 35 | | | |
| 63 | PARTITION RANGE ALL | | 1 | 35 | 12 (0)| 1 | 27 |
| 64 | TABLE ACCESS BY LOCAL INDEX ROWID| CCM_LOG | 1 | 35 | 12 (0)| 1 | 27 |
| 65 | INDEX RANGE SCAN | CCM_LOG_N1 | 17 | | 8 (0)| 1 | 27 |
| 66 | SORT AGGREGATE | | 1 | 32 | | | |
| 67 | PARTITION RANGE ALL | | 1 | 32 | 12 (0)| 1 | 27 |
| 68 | TABLE ACCESS BY LOCAL INDEX ROWID| CCM_LOG | 1 | 32 | 12 (0)| 1 | 27 |
| 69 | INDEX RANGE SCAN | CCM_LOG_N1 | 17 | | 8 (0)| 1 | 27 |
| 70 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 12 | 1 (0)| | |
| 71 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 72 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 11 | 1 (0)| | |
| 73 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 74 | SORT AGGREGATE | | 1 | 32 | | | |
| 75 | PARTITION RANGE ALL | | 1 | 32 | 12 (0)| 1 | 27 |
| 76 | TABLE ACCESS BY LOCAL INDEX ROWID| CCM_LOG | 1 | 32 | 12 (0)| 1 | 27 |
| 77 | INDEX RANGE SCAN | CCM_LOG_N1 | 17 | | 8 (0)| 1 | 27 |
| 78 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 1 (0)| | |
| 79 | INDEX RANGE SCAN | CRM_MACODE_LANG_TEST | 1 | | 1 (0)| | |
| 80 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 1 (0)| | |
| 81 | INDEX RANGE SCAN | CRM_MACODE_LANG_X1 | 1 | | 1 (0)| | |
| 82 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 11 | 1 (0)| | |
| 83 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 84 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 15 | 1 (0)| | |
| 85 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 86 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 14 | 1 (0)| | |
| 87 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 88 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 19 | 1 (0)| | |
| 89 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 90 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 24 | 1 (0)| | |
| 91 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 1 (0)| | |
| 92 | TABLE ACCESS BY INDEX ROWID | CRM_USER_INFO | 1 | 36 | 1 (0)| | |
| 93 | INDEX RANGE SCAN | CRM_USER_INFO_N3 | 1 | | 1 (0)| | |
| 94 | TABLE ACCESS BY INDEX ROWID | SOM_TABS_CODES | 1 | 33 | 1 (0)| | |
| 95 | INDEX RANGE SCAN | CRM_MACODE_LANG_X1 | 1 | | 1 (0)| | |
| 96 | TABLE ACCESS BY INDEX ROWID | CRM_DEPARTEMENT | 1 | 13 | 1 (0)| | |
| 97 | INDEX UNIQUE SCAN | CRM_CONTRACT_PK | 1 | | 1 (0)| | |
| 98 | VIEW | | 110K| 41M| 2124 (1)| | |
| 99 | TABLE ACCESS FULL | CCM_USER_INFO | 110K| 3441K| 2124 (1)| | |
---------------------------------------------------------------------------------------------------------------------------
Any ideas ?
Kai