|
."SERV_ID"=3751994561 OR "C"."SERV_ID"=3753622431 OR "C"."SERV_ID"=3753633921 OR
"C"."SERV_ID"=3753633981 OR "C"."SERV_ID"=3753634021 OR "C"."SERV_ID"=3753634041 OR "C"."SERV_ID"=3753634111 OR
"C"."SERV_ID"=3753634271 OR "C"."SERV_ID"=3753644141 OR "C"."SERV_ID"=3753645051 OR "C"."SERV_ID"=3753645261 OR
"C"."SERV_ID"=3753647021)
8 - access("STAT"='S0C' AND "STATUS_DATE">=TO_DATE(' 2014-11-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
10 - access("ORDER_ITEM_ID"="B"."SUBS_ID")
11 - filter("D"."ACTION_TYPE"='NEW' AND "B"."ACTION_ID"<>14030 AND "B"."ACTION_ID"<>14266 AND "B"."ACTION_ID"<>7021 OR
"B"."ACTION_ID"=6448 OR "B"."ACTION_ID"=14099 OR "B"."ACTION_ID"=14260)
12 - access("B"."ACTION_ID"="D"."ACTION_ID" AND "D"."CITY_ID"='200')
13 - filter("MODI_DATE"(+)>=TO_DATE(' 2014-11-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
14 - access("ORDER_ITEM_ID"="TB_BA_CHANNELSTAFF"."SUBS_ID"(+))
16 - access("ORDER_ITEM_ID"="C"."SUBS_ID")
--再查下相关的对象情况
......getting segment size......
OWNER SEGMENT_NAME SEGMENT_TYPE Size(Mb)
-------------------- ------------------------------ -------------------- ----------
CRM2_PUB PK_PM_ACTION INDEX 3
CRM_GZ PK_CHANNELSTAFF_SUBS_ID INDEX 1993
CRM_GZ IX_BA_ACT_SUBSID_HIST INDEX 8644.5
CRM_GZ IX_BA_SERVSUBSID_HIST INDEX PARTITION 3779.75
CRM_GZ IXH_ORDERITEM_STATDATE INDEX PARTITION 7927.5625
CRM2_PUB TB_PM_ACTION TABLE 34
CRM_GZ TB_BA_CHANNELSTAFF TABLE 9961
CRM_GZ TB_BA_ACTION_HIST TABLE 29305
CRM_GZ TB_BA_SERV_HIST TABLE PARTITION 30768.25
CRM_GZ ORDER_ITEM_HIST TABLE PARTITION 58503.625
10 rows selected.
Elapsed: 00:00:00.34
......getting table infomation......
OWNER TABLE_NAME Size(Mb) PAR DEGREE NUM_ROWS GLO STATS GATHER TIME
-------------------- ------------------------------ ---------- --- ---------- ---------- --- ------------------
CRM2_PUB *TB_PM_ACTION 26.6463165 NO 1 120434 YES 78.6312153
CRM2_PUB TB_PM_ACTION 26.6463165 NO 1 120434 YES 78.6312153
CRM_GZ *TB_BA_CHANNELSTAFF 7909.30271 NO 1 94244375 YES 23.6510532
CRM_GZ TB_BA_CHANNELSTAFF 7909.30271 NO 1 94244375 YES 23.6510532
CRM_GZ *TB_BA_SERV_HIST 23083.6036 YES 1 129438036 YES 78.5309028
CRM_GZ TB_BA_SERV_HIST 23083.6036 YES 1 129438036 YES 78.5309028
CRM_GZ *ORDER_ITEM_HIST 43997.6631 YES 1 212603196 YES 78.6465972
CRM_GZ ORDER_ITEM_HIST 43997.6631 YES 1 212603196 YES 78.6465972
CRM_GZ *TB_BA_ACTION_HIST 22367.6905 NO 1 279216946 YES 78.6315972
CRM_GZ TB_BA_ACTION_HIST 22367.6905 NO 1 279216946 YES 78.6315972
10 rows selected.
Elapsed: 00:00:00.12
......getting index infomation......
OWNER INDEX_NAME TABLE_NAME PAR UNIQUENES DEGREE INDEX_TYPE LEAF_BLOCKS BLEVEL CLUSTERING_FACTOR
-------------------- ------------------------------ ------------------------------ --- --------- ---------- ---------- ----------- ---------- ----------------- -----
CRM_GZ IX_BA_ACT_SUBSID_HIST TB_BA_ACTION_HIST NO NONUNIQUE 1 NORMAL 492002 2 220159998 100
CRM_GZ IX_BA_SERVSUBSID_HIST TB_BA_SERV_HIST YES NONUNIQUE 1 NORMAL 196468 2 97894132 100
CRM_GZ IXH_ORDERITEM_STATDATE ORDER_ITEM_HIST YES NONUNIQUE 1 NORMAL 433702 2 153506102 17.3428035
CRM_GZ PK_CHANNELSTAFF_SUBS_ID TB_BA_CHANNELSTAFF NO UNIQUE 1 NORMAL 116755 2 83251565 100
CRM2_PUB PK_PM_ACTION TB_PM_ACTION NO UNIQUE 1 NORMAL 155 |