执行计划问题请教

显示全部楼层 · 2007-9-26 18:42:10

最近库做了迁移，旧库是WINDOWS2003+ORACLE11GR（32位），新库是LINUXRHEL5UP4+ORACLE11GR2（64位）
同样的查询语句，执行计划差别太大了
Select a.Cell_Name,
a.Cycle_Index,
a.Transf_Date Transf_Time,
a.Charge_Capacity,
a.Discharge_Capacity,
c.Channel_Index,
b.Machine_No,
b.test_name,
b.Schedule,
b.End_Time
From format.Cycle_Data1 a, format.Test_Files1 b, format.Test_Cells1 c
Where a.Test_Type = 'AG'
and a.Cell_Name in
('B91035062381', 'B910350623A0', 'B91035062399', 'B9103506237F',
'B91035062394', 'B91035062393', 'B91035062389', 'B910350623A2',
'B910350623A4', 'B910350623A1', 'B910350623A8', 'B910350623A5',
'B910350623A6', 'B91035062387', 'B910350623A7', 'B9103506238A',
'B910350623A9', 'B910350623AD', 'B910350623AA', 'B91035062388',
'B9103506238F', 'B9103506238D', 'B9103506238E', 'B910350623A3',
'B9103506237D', 'B91035062385', 'B9103506237E', 'B9103506237B',
'B91035062391', 'B91035062384', 'B9103506237C', 'B91035062386',
'B91035062392', 'B9103506238B', 'B91035062397', 'B91035062390',
'B91035062395', 'B91035062398', 'B9103506239D', 'B91035062396',
'B910350623AC', 'B910350623AB', 'B910350623B7', 'B910350623BC',
'B910350623B6', 'B910350623B4', 'B910350623C3', 'B910350623C2',
'B910350623CC', 'B910350623C4', 'B910350623C1', 'B910350623CB',
'B910350623CA', 'B910350623C9', 'B910350623DF', 'B910350623E0',
'B910350623CD', 'B910350623CF', 'B910350623B0', 'B910350623D2',
'B910350623B1', 'B910350623B8', 'B910350623D0', 'B910350623AE',
'B910350623CE', 'B910350623AF', 'B910350623B9', 'B910350623DC',
'B910350623BA', 'B910350623BD', 'B910350623B2', 'B910350623C0',
'B910350623D4', 'B910350623BE', 'B910350623D1', 'B910350623C8',
'B910350623BF', 'B910350623C5', 'B910350623C6', 'B910350623D7',
'B910350623D5', 'B910350623D3', 'B910350623C7', 'B910350623D8',
'B910350623D6', 'B910350623DA', 'B910350623DB', 'B910350623D9',
'B91035062317', 'B91035062318', 'B91035062316', 'B91035062322',
'B91035062323', 'B91035062319', 'B91035062346', 'B91035062324',
'B91035062344', 'B91035062343', 'B9103506232C', 'B91035062341')
and a.Cell_Name = c.Cell_Name
and c.File_Name = b.File_Name
and a.Transf_Date = c.Transf_Date
Order by Cell_Name, Transf_Time
旧库上的执行计划：
未选定行
已用时间:00: 00: 00.01
执行计划
----------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------
| Id| Operation
| Name
| Rows| By
tes | Cost| Pstart| Pstop |
--------------------------------------------------------------------------------
-----------------------------
| 0 | SELECT STATEMENT
|
|64 |9
856 | 389 | | |
| 1 |NESTED LOOPS
|
| |
| | | |
| 2 | NESTED LOOPS
|
|64 |9
856 | 389 | | |
| 3 |NESTED LOOPS
|
|64 |5
568 | 197 | | |
| 4 | INLIST ITERATOR
|
| |
| | | |
| 5 |TABLE ACCESS BY GLOBAL INDEX ROWID| CYCLE_DATA1|65 |2
535 | 131 | ROWID | ROWID |
| 6 | INDEX RANGE SCAN
| UNIQUE_CYCLE_DATA1 |65 |
| 103 | | |
| 7 | TABLE ACCESS BY INDEX ROWID| TEST_CELLS1| 1 |
48 | 3 | | |
| 8 |INDEX UNIQUE SCAN
| UNIQUE_TEST_CELLS1 | 1 |
| 2 | | |
| 9 |INDEX UNIQUE SCAN
| UNIQUE_TEST_FILES1 | 1 |
| 2 | | |
|10 | TABLE ACCESS BY INDEX ROWID
| TEST_FILES1| 1 |
67 | 3 | | |
--------------------------------------------------------------------------------
-----------------------------
Note
-----
- 'PLAN_TABLE' is old version

统计信息
----------------------------------------------------------

0recursive calls

0db block gets
18consistent gets

0physical reads

0redo size
839bytes sent via SQL*Net to client
405bytes received via SQL*Net from client

1SQL*Net roundtrips to/from client

0sorts (memory)

0sorts (disk)

0rows processed
新库上的执行计划

600 rows selected.
Elapsed: 00:13:16.66
Execution Plan
----------------------------------------------------------

Plan hash value: 48782431

--------------------------------------------------------------------------------
------------------------------------------

| Id| Operation
| Name | Rows| Bytes | Cost (%CPU)| Time | Pstart| Pstop |

--------------------------------------------------------------------------------
------------------------------------------

| 0 | SELECT STATEMENT
|
| 218 | 33572 |1214 (1)| 00:00:15 | | |

| 1 |NESTED LOOPS
|
| | |
|
| | |

| 2 | NESTED LOOPS
|
| 218 | 33572 |1214 (1)| 00:00:15 | | |

| 3 |MERGE JOIN
|
| 218 | 18966 | 559 (1)| 00:00:07 | | |

| 4 | TABLE ACCESS BY GLOBAL INDEX ROWID| CYCLE_DATA1| 318 | 12402 | 240 (0)| 00:00:03 | ROWID | ROWID |

|*5 |INDEX RANGE SCAN
| UQ_CYCLE_DATA1 | 318 | | 103 (0)| 00:00:02 | | |

|*6 | SORT JOIN
|
| 219 | 10512 | 319 (1)| 00:00:04 | | |

| 7 |INLIST ITERATOR
|
| | |
|
| | |

| 8 | TABLE ACCESS BY GLOBAL INDEX ROWID| TEST_CELLS1| 219 | 10512 | 318 (0)| 00:00:04 | ROWID | ROWID |

|*9 |INDEX RANGE SCAN
| UQ_TEST_CELLS1 | 219 | | 103 (0)| 00:00:02 | | |

|* 10 |INDEX UNIQUE SCAN
| UQ_TEST_FILES1 | 1 | | 1 (0)| 00:00:01 | | |

|11 | TABLE ACCESS BY INDEX ROWID | TEST_FILES1| 1 |67 | 1 (0)| 00:00:01 | | |

--------------------------------------------------------------------------------
------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

5 - access("A"."TEST_TYPE"='AG')

filter("A"."CELL_NAME"='B91035062316' OR "A"."CELL_NAME"='B91035062317' OR "A"."CELL_NAME"='B91035062318'
OR "A"."CELL_NAME"='B91035062319' OR "A"."CELL_NAME"='B91035062322' OR "A"."CELL_NAME"='B91035062323' OR
"A"."CELL_NAME"='B91035062324' OR "A"."CELL_NAME"='B9103506232C' OR "A"."CELL_NAME"='B91035062341' OR
"A"."CELL_NAME"='B91035062343' OR "A"."CELL_NAME"='B91035062344' OR "A"."CELL_NAME"='B91035062346' OR
"A"."CELL_NAME"='B9103506237B' OR "A"."CELL_NAME"='B9103506237C' OR "A"."CELL_NAME"='B9103506237D' OR
"A"."CELL_NAME"='B9103506237E' OR "A"."CELL_NAME"='B9103506237F' OR "A"."CELL_NAME"='B91035062381' OR
"A"."CELL_NAME"='B91035062384' OR "A"."CELL_NAME"='B91035062385' OR "A"."CELL_NAME"='B91035062386' OR
"A"."CELL_NAME"='B91035062387' OR "A"."CELL_NAME"='B91035062388' OR "A"."CELL_NAME"='B91035062389' OR
"A"."CELL_NAME"='B9103506238A' OR "A"."CELL_NAME"='B9103506238B' OR "A"."CELL_NAME"='B9103506238D' OR

"A"."CELL_NAME"='B9103506238E' OR "A"."CELL_NAME"='B9103506238F' OR "A"."CELL_NAME"='B91035062390' OR

"A"."CELL_NAME"='B91035062391' OR "A"."CELL_NAME"='B91035062392' OR "A"."CELL_NAME"='B91035062393' OR
"A"."CELL_NAME"='B91035062394' OR "A"."CELL_NAME"='B91035062395' OR "A"."CELL_NAME"='B91035062396' OR
"A"."CELL_NAME"='B91035062397' OR "A"."CELL_NAME"='B91035062398' OR "A"."CELL_NAME"='B91035062399' OR
"A"."CELL_NAME"='B9103506239D' OR "A"."CELL_NAME"='B910350623A0' OR "A"."CELL_NAME"='B910350623A1' OR
"A"."CELL_NAME"='B910350623A2' OR "A"."CELL_NAME"='B910350623A3' OR "A"."CELL_NAME"='B910350623A4' OR
"A"."CELL_NAME"='B910350623A5' OR "A"."CELL_NAME"='B910350623A6' OR "A"."CELL_NAME"='B910350623A7' OR
"A"."CELL_NAME"='B910350623A8' OR "A"."CELL_NAME"='B910350623A9' OR "A"."CELL_NAME"='B910350623AA' OR
"A"."CELL_NAME"='B910350623AB' OR "A"."CELL_NAME"='B910350623AC' OR "A"."CELL_NAME"='B910350623AD' OR
"A"."CELL_NAME"='B910350623AE' OR "A"."CELL_NAME"='B910350623AF' OR "A"."CELL_NAME"='B910350623B0' OR

"A"."CELL_NAME"='B910350623B1' OR "A"."CELL_NAME"='B910350623B2' OR "A"."CELL_NAME"='B910350623B4' OR

"A"."CELL_NAME"='B910350623B6' OR "A"."CELL_NAME"='B910350623B7' OR "A"."CELL_NAME"='B910350623B8' OR

"A"."CELL_NAME"='B910350623B9' OR "A"."CELL_NAME"='B910350623BA' OR "A"."CELL_NAME"='B910350623BC' OR
"A"."CELL_NAME"='B910350623BD' OR "A"."CELL_NAME"='B910350623BE' OR "A"."CELL_NAME"='B910350623BF' OR

"A"."CELL_NAME"='B910350623C0' OR "A"."CELL_NAME"='B910350623C1' OR "A"."CELL_NAME"='B910350623C2' OR
"A"."CELL_NAME"='B910350623C3' OR "A"."CELL_NAME"='B910350623C4' OR "A"."CELL_NAME"='B910350623C5' OR
"A"."CELL_NAME"='B910350623C6' OR "A"."CELL_NAME"='B910350623C7' OR "A"."CELL_NAME"='B910350623C8' OR

"A"."CELL_NAME"='B910350623C9' OR "A"."CELL_NAME"='B910350623CA' OR "A"."CELL_NAME"='B910350623CB' OR
"A"."CELL_NAME"='B910350623CC' OR "A"."CELL_NAME"='B910350623CD' OR "A"."CELL_NAME"='B910350623CE' OR
"A"."CELL_NAME"='B910350623CF' OR "A"."CELL_NAME"='B910350623D0' OR "A"."CELL_NAME"='B910350623D1' OR
"A"."CELL_NAME"='B910350623D2' OR "A"."CELL_NAME"='B910350623D3' OR "A"."CELL_NAME"='B910350623D4' OR
"A"."CELL_NAME"='B910350623D5' OR "A"."CELL_NAME"='B910350623D6' OR "A"."CELL_NAME"='B910350623D7' OR
"A"."CELL_NAME"='B910350623D8' OR "A"."CELL_NAME"='B910350623D9' OR "A"."CELL_NAME"='B910350623DA' OR
"A"."CELL_NAME"='B910350623DB' OR "A"."CELL_NAME"='B910350623DC' OR "A"."CELL_NAME"='B910350623DF' OR
"A"."CELL_NAME"='B910350623E0')

6 - access("A"."CELL_NAME"="C"."CELL_NAME" AND "A"."TRANSF_DATE"="C"."TRANSF_DATE")
filter("A"."TRANSF_DATE"="C"."TRANSF_DATE" AND "A"."CELL_NAME"="C"."CELL_NAME")
9 - access("C"."CELL_NAME"='B91035062316' OR "C"."CELL_NAME"='B91035062317' OR "C"."CELL_NAME"='B91035062318'
OR "C"."CELL_NAME"='B91035062319' OR "C"."CELL_NAME"='B91035062322' OR "C"."CELL_NAME"='B91035062323' OR
"C"."CELL_NAME"='B91035062324' OR "C"."CELL_NAME"='B9103506232C' OR "C"."CELL_NAME"='B91035062341' OR
"C"."CELL_NAME"='B91035062343' OR "C"."CELL_NAME"='B91035062344' OR "C"."CELL_NAME"='B91035062346' OR
"C"."CELL_NAME"='B9103506237B' OR "C"."CELL_NAME"='B9103506237C' OR "C"."CELL_NAME"='B9103506237D' OR
"C"."CELL_NAME"='B9103506237E' OR "C"."CELL_NAME"='B9103506237F' OR "C"."CELL_NAME"='B91035062381' OR
"C"."CELL_NAME"='B91035062384' OR "C"."CELL_NAME"='B91035062385' OR "C"."CELL_NAME"='B91035062386' OR
"C"."CELL_NAME"='B91035062387' OR "C"."CELL_NAME"='B91035062388' OR "C"."CELL_NAME"='B91035062389' OR
"C"."CELL_NAME"='B9103506238A' OR "C"."CELL_NAME"='B9103506238B' OR "C"."CELL_NAME"='B9103506238D' OR
"C"."CELL_NAME"='B9103506238E' OR "C"."CELL_NAME"='B9103506238F' OR "C"."CELL_NAME"='B91035062390' OR

"C"."CELL_NAME"='B91035062391' OR "C"."CELL_NAME"='B91035062392' OR "C"."CELL_NAME"='B91035062393' OR

"C"."CELL_NAME"='B91035062394' OR "C"."CELL_NAME"='B91035062395' OR "C"."CELL_NAME"='B91035062396' OR

"C"."CELL_NAME"='B91035062397' OR "C"."CELL_NAME"='B91035062398' OR "C"."CELL_NAME"='B91035062399' OR
"C"."CELL_NAME"='B9103506239D' OR "C"."CELL_NAME"='B910350623A0' OR "C"."CELL_NAME"='B910350623A1' OR
"C"."CELL_NAME"='B910350623A2' OR "C"."CELL_NAME"='B910350623A3' OR "C"."CELL_NAME"='B910350623A4' OR
"C"."CELL_NAME"='B910350623A5' OR "C"."CELL_NAME"='B910350623A6' OR "C"."CELL_NAME"='B910350623A7' OR
"C"."CELL_NAME"='B910350623A8' OR "C"."CELL_NAME"='B910350623A9' OR "C"."CELL_NAME"='B910350623AA' OR
"C"."CELL_NAME"='B910350623AB' OR "C"."CELL_NAME"='B910350623AC' OR "C"."CELL_NAME"='B910350623AD' OR

"C"."CELL_NAME"='B910350623AE' OR "C"."CELL_NAME"='B910350623AF' OR "C"."CELL_NAME"='B910350623B0' OR
"C"."CELL_NAME"='B910350623B1' OR "C"."CELL_NAME"='B910350623B2' OR "C"."CELL_NAME"='B910350623B4' OR
"C"."CELL_NAME"='B910350623B6' OR "C"."CELL_NAME"='B910350623B7' OR "C"."CELL_NAME"='B910350623B8' OR

"C"."CELL_NAME"='B910350623B9' OR "C"."CELL_NAME"='B910350623BA' OR "C"."CELL_NAME"='B910350623BC' OR

"C"."CELL_NAME"='B910350623BD' OR "C"."CELL_NAME"='B910350623BE' OR "C"."CELL_NAME"='B910350623BF' OR
"C"."CELL_NAME"='B910350623C0' OR "C"."CELL_NAME"='B910350623C1' OR "C"."CELL_NAME"='B910350623C2' OR
"C"."CELL_NAME"='B910350623C3' OR "C"."CELL_NAME"='B910350623C4' OR "C"."CELL_NAME"='B910350623C5' OR
"C"."CELL_NAME"='B910350623C6' OR "C"."CELL_NAME"='B910350623C7' OR "C"."CELL_NAME"='B910350623C8' OR
"C"."CELL_NAME"='B910350623C9' OR "C"."CELL_NAME"='B910350623CA' OR "C"."CELL_NAME"='B910350623CB' OR
"C"."CELL_NAME"='B910350623CC' OR "C"."CELL_NAME"='B910350623CD' OR "C"."CELL_NAME"='B910350623CE' OR
"C"."CELL_NAME"='B910350623CF' OR "C"."CELL_NAME"='B910350623D0' OR "C"."CELL_NAME"='B910350623D1' OR
"C"."CELL_NAME"='B910350623D2' OR "C"."CELL_NAME"='B910350623D3' OR "C"."CELL_NAME"='B910350623D4' OR
"C"."CELL_NAME"='B910350623D5' OR "C"."CELL_NAME"='B910350623D6' OR "C"."CELL_NAME"='B910350623D7' OR
"C"."CELL_NAME"='B910350623D8' OR "C"."CELL_NAME"='B910350623D9' OR "C"."CELL_NAME"='B910350623DA' OR
"C"."CELL_NAME"='B910350623DB' OR "C"."CELL_NAME"='B910350623DC' O

R "C"."CELL_NAME"='B910350623DF' OR

"C"."CELL_NAME"='B910350623E0')

10 - access("C"."FILE_NAME"="B"."FILE_NAME")

Statistics
----------------------------------------------------------

1recursive calls

0db block gets

1314044consistent gets

1301688physical reads

5140redo size

34262bytes sent via SQL*Net to client

952bytes received via SQL*Net from client

41SQL*Net roundtrips to/from client

1sorts (memory)

0sorts (disk)

600rows processed

差别也太大了。。
昨晚也做了整个FORMAT OWNER的统计信息收集，还是一样。。不知问题在那里。。。请教大家看看。。
[ 本帖最后由 flying_life 于 2010-8-28 12:53 编辑 ]

千问 · 2007-9-26 18:42:10

"C"."CELL_NAME"='B910350623DB' OR "C"."CELL_NAME"='B910350623DC' O
R "C"."CELL_NAME"='B910350623DF' OR

"C"."CELL_NAME"='B910350623E0')
10 - access("C"."FILE_NAME"="B"."FILE_NAME")
怎么是这么多的OR运算。。

千问 · 2007-9-26 18:42:10

楼主编辑一下执行计划, 这样子太难看了.

千问 · 2007-9-26 18:42:10

统计信息似乎不准, 你单独对这几个表再采集统计信息.

千问 · 2007-9-26 18:42:10

太乱了，没法看嘛！

千问 · 2007-9-26 18:42:10

不要意思重编了一下，请大家看一下。。

千问 · 2007-9-26 18:42:10

两个库的版本是否一致,是否都执行了信息统计....

千问 · 2007-9-26 18:42:10

一个
0rows processed
一个
600rows processed
结果集都不同

千问 · 2007-9-26 18:42:10

第5步中, 使用的索引的字段有哪些?
5 - access("A"."TEST_TYPE"='AG')
filter("A"."CELL_NAME"='B91035062316' OR "A"."CELL_NAME"='B91035062317' OR

千问 · 2007-9-26 18:42:10

原帖由 ZALBB 于 2010-8-28 23:22 发表
第5步中, 使用的索引的字段有哪些?
5 - access("A"."TEST_TYPE"='AG')
filter("A"."CELL_NAME"='B91035062316' OR "A"."CELL_NAME"='B91035062317' OR
问题解决了，在CYCEL_DATA1 上增加了CELL—NAME的索引，
再修改了2个参数。
optimizer_index_caching
integer 90
optimizer_index_cost_adj
integer 20
现在效率高多了
SQL> Select a.Cell_Name,
2 a.Cycle_Index,
3 a.Transf_Date Transf_Time,
4 a.Charge_Capacity,
5 a.Discharge_Capacity,
6 c.Channel_Index,
7 b.Machine_No,
8 b.test_name,
9 b.Schedule,
10 b.End_Time
11From format.Cycle_Data1 a, format.Test_Files1 b, format.Test_Cells1 c
12 Where a.Test_Type = 'AG'
13 and a.Cell_Name in
14 ('B91035062381', 'B910350623A0', 'B91035062399', 'B9103506237F',
15
'B91035062394', 'B91035062393', 'B91035062389', 'B910350623A2',
16
'B910350623A4', 'B910350623A1', 'B910350623A8', 'B910350623A5',
17
'B910350623A6', 'B91035062387', 'B910350623A7', 'B9103506238A',
18
'B910350623A9', 'B910350623AD', 'B910350623AA', 'B91035062388',
19
'B9103506238F', 'B9103506238D', 'B9103506238E', 'B910350623A3',
20
'B9103506237D', 'B91035062385', 'B9103506237E', 'B9103506237B'
21 )
22 and a.Cell_Name = c.Cell_Name
23 and c.File_Name = b.File_Name
24 and a.Transf_Date = c.Transf_Date
25 Order by Cell_Name, Transf_Time;
168 rows selected.
Elapsed: 00:00:00.28
Execution Plan
----------------------------------------------------------
Plan hash value: 782012085
--------------------------------------------------------------------------------
-----------------------------------------------
| Id| Operation
| Name
| Rows|
Bytes | Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------
-----------------------------------------------
| 0 | SELECT STATEMENT
|
|66 |
10164 |45 (0)| 00:00:01 | | |
| 1 |NESTED LOOPS
|
| |
|
|
| | |
| 2 | NESTED LOOPS
|
|66 |
10164 |45 (0)| 00:00:01 | | |
| 3 |NESTED LOOPS
|
|66 |
7590 |32 (0)| 00:00:01 | | |
| 4 | INLIST ITERATOR
|
| |
|
|
| | |
| 5 |TABLE ACCESS BY GLOBAL INDEX ROWID| TEST_CELLS1
|66 |
3168 |19 (0)| 00:00:01 | ROWID | ROWID |
|*6 | INDEX RANGE SCAN
| UQ_TEST_CELLS1 |66 |
| 6 (0)| 00:00:01 | | |
| 7 | TABLE ACCESS BY INDEX ROWID| TEST_FILES1
| 1 |
67 | 0 (0)| 00:00:01 | | |
|*8 |INDEX UNIQUE SCAN
| UQ_TEST_FILES1 | 1 |
| 0 (0)| 00:00:01 | | |
|*9 |INDEX RANGE SCAN
| CELLNAME_CYCLE_DATA1 | 1 |
| 1 (0)| 00:00:01 | | |
|* 10 | TABLE ACCESS BY GLOBAL INDEX ROWID | CYCLE_DATA1
| 1 |
39 | 1 (0)| 00:00:01 | ROWID | ROWID |
--------------------------------------------------------------------------------
-----------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------
6 - access("C"."CELL_NAME"='B9103506237B' OR "C"."CELL_NAME"='B9103506237D' O
R "C"."CELL_NAME"='B9103506237E' OR

"C"."CELL_NAME"='B9103506237F' OR "C"."CELL_NAME"='B91035062381' O
R "C"."CELL_NAME"='B91035062385' OR

"C"."CELL_NAME"='B91035062387' OR "C"."CELL_NAME"='B91035062388' O
R "C"."CELL_NAME"='B91035062389' OR

"C"."CELL_NAME"='B9103506238A' OR "C"."CELL_NAME"='B9103506238D' O
R "C"."CELL_NAME"='B9103506238E' OR

"C"."CELL_NAME"='B9103506238F' OR "C"."CELL_NAME"='B91035062393' O
R "C"."CELL_NAME"='B91035062394' OR

"C"."CELL_NAME"='B91035062399' OR "C"."CELL_NAME"='B910350623A0' O
R "C"."CELL_NAME"='B910350623A1' OR

"C"."CELL_NAME"='B910350623A2' OR "C"."CELL_NAME"='B910350623A3' O
R "C"."CELL_NAME"='B910350623A4' OR

"C"."CELL_NAME"='B910350623A5' OR "C"."CELL_NAME"='B910350623A6' O
R "C"."CELL_NAME"='B910350623A7' OR

"C"."CELL_NAME"='B910350623A8' OR "C"."CELL_NAME"='B910350623A9' O
R "C"."CELL_NAME"='B910350623AA' OR

"C"."CELL_NAME"='B910350623AD')
8 - access("C"."FILE_NAME"="B"."FILE_NAME")
9 - access("A"."CELL_NAME"="C"."CELL_NAME")
filter("A"."CELL_NAME"='B9103506237B' OR "A"."CELL_NAME"='B9103506237D' O
R "A"."CELL_NAME"='B9103506237E' OR

"A"."CELL_NAME"='B9103506237F' OR "A"."CELL_NAME"='B91035062381' O
R "A"."CELL_NAME"='B91035062385' OR

"A"."CELL_NAME"='B91035062387' OR "A"."CELL_NAME"='B91035062388' O
R "A"."CELL_NAME"='B91035062389' OR

"A"."CELL_NAME"='B9103506238A' OR "A"."CELL_NAME"='B9103506238D' O
R "A"."CELL_NAME"='B9103506238E' OR

"A"."CELL_NAME"='B9103506238F' OR "A"."CELL_NAME"='B91035062393' O
R "A"."CELL_NAME"='B91035062394' OR

"A"."CELL_NAME"='B91035062399' OR "A"."CELL_NAME"='B910350623A0' O
R "A"."CELL_NAME"='B910350623A1' OR

"A"."CELL_NAME"='B910350623A2' OR "A"."CELL_NAME"='B910350623A3' O
R "A"."CELL_NAME"='B910350623A4' OR

"A"."CELL_NAME"='B910350623A5' OR "A"."CELL_NAME"='B910350623A6' O
R "A"."CELL_NAME"='B910350623A7' OR

"A"."CELL_NAME"='B910350623A8' OR "A"."CELL_NAME"='B910350623A9' O
R "A"."CELL_NAME"='B910350623AA' OR

"A"."CELL_NAME"='B910350623AD')
10 - filter("A"."TEST_TYPE"='AG' AND "A"."TRANSF_DATE"="C"."TRANSF_DATE")

Statistics
----------------------------------------------------------

1recursive calls

0db block gets
550consistent gets
30physical reads

0redo size
10568bytes sent via SQL*Net to client
645bytes received via SQL*Net from client
13SQL*Net roundtrips to/from client

0sorts (memory)

0sorts (disk)
168rows processed