Hi, all.
The oracle is 11.2.0.3 on a linux machine.
I did "select in parallel(index ffs) and serial insert".
The following is tkprof output from one of tracefiles(parallel slave produced several tracefile).
That's why block related counters are not accurate.
I found "ROW LOCATION ROW LOCATION" operation, and I googled it.
There is little information about it.
The index of "PARTITIONED_AAA_PK" is global hash partitioned index(hash level 16).
What is "ROW LOCATION ROW LOCATION"??
insert into TEST_AAA_HIS
select /*+ index_ffs(t PARTITIONED_AAA_HIS_PK) parallel_index(t,PARTITIONED_AAA_HIS_PK,8) */ *
from PARTITIONED_AAA t
where seq > 548215475
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.08 33 33 0 0
Execute 1 23.63 32.67 44336 112722 399430 1407251
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 23.64 32.75 44369 112755 399430 1407251
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL (cr=112722 pr=44336 pw=0 time=32670190 us)
1407251 1407251 1407251 PX COORDINATOR (cr=48 pr=0 pw=0 time=4328843 us)
0 0 0 PX SEND QC (RANDOM) :TQ10000 (cr=0 pr=0 pw=0 time=0 us cost=151381 size=93444240 card=210460)
0 0 0 PX PARTITION HASH ALL PARTITION: 1 16 (cr=0 pr=0 pw=0 time=0 us cost=151381 size=93444240 card=210460)
0 0 0 TABLE ACCESS BY GLOBAL INDEX ROWID PARTITIONED_AAA PARTITION: ROW LOCATION ROW LOCATION (cr=0 pr=0 pw=0 time=0 us cost=151381 size=93444240 card=210460)
0 0 0 INDEX RANGE SCAN PARTITIONED_AAA_PK PARTITION: 1 16 (cr=0 pr=0 pw=0 time=0 us cost=731 size=0 card=210460)(object id 814571)
Thanks in advance.
Best Regards.