Oracle Database Discussions

select *From v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL

SELECT * FROM (
SELECT TRANSACTION_RECORD_ID,ASIN_TITLE,IS_B2B,BILL_TO_COUNTRY,PRODUCT_BINDING,PRODUCT_BINDING_PEC,BUYER_ID,BUYER_ID_DOMAIN,BUYER_SOR_ID,CALVIN_EVENT_ID,CALVIN_EVENT_SO
URCE,CALVIN_EVENT_TYPE,CATALOG_EXCEPTION,COMMODITY_CODE,
COUNTRY_OF_ORIGIN,CREATED_BY,CREATION_DATE,CURRENCY_CODE,IS_EU_EXPORT,EXTENDED_ADJ_XB_SELLING_PRICE,FINALIZED_DATE,FINANCIAL_COMPONENT,GLPG_DESC,GL_PRODUCT_GROUP,GROUP_
ID,GROUP_ID_DOMAIN,LAST_UPDATED_BY,LAST_UPDATED_DATE,LINE_ITEM_ID,
LINE_ITEM_ID_DOMAIN,LIST_PRICE,MARKETPLACE_COUNTRY,MARKETPLACE_ID,MASS,ORDER_ID,ORDER_LINE_ITEM_ID,PRODUCT_CATEGORY,PRODUCT_ID,PRODUCT_ID_DOMAIN,PRODUCT_SUBCATEGORY,PRO
DUCT_TAX_CODE,QUANTITY,SELLER_ID,SELLER_ID_DOMAIN,SELLER_INTRACOMPANY_ACQ,
SELLER_SOR_ID,SHIP_FROM_COUNTRY,SHIP_FROM_SOURCE_SYSTEM_ID,SHIP_LINE_ITEM_ID,SHIP_TO_CITY,SHIP_TO_COUNTRY,SHIP_TO_COUNTY,SHIP_TO_LINE1,SHIP_TO_LINE2,SHIP_TO_LINE3,SHIP_
TO_POSTAL_CODE,SHIP_TO_STATE,SHIP_TO_TAX_LC_DOMAIN,SHIP_TO_TAX_LOCATION_CODE,
STATUS,STATUS_CHANGE_DATE,SUPPLY_COUNTRY,TRANSACTION_DATE,TRANSACTION_ID,TRANSACTION_ID_DOMAIN,TRANSACTION_TYPE,UNIQUE_KEY,VAT_INVOICE_NUMBER
FROM CORPTAX.TRANSACTION_RECORD WHERE (((FINALIZED_DATE>=to_date('10-02-2011 00:00:00','mm-dd-yyyy HH24:MI:SS') AND PRODUCT_ID_DOMAIN='ASIN') AND ASIN_TITLE='Monster Fl
oorfillers 2011') AND CATALOG_EXCEPTION='Campingaz 2 Burner Stove Carry Bag')
)
WHERE ROWNUM <= 100000
/
Elapsed: 00:01:44.97
Execution Plan
----------------------------------------------------------
Plan hash value: 2662217990

------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation              | Name               | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |    TQ  |IN-OUT| PQ Distrib |
------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |                    |    57 | 37392 |   529K  (1)| 01:46:00 |       |       |        |      |            |
|*  1 |  COUNT STOPKEY         |                    |       |       |            |          |       |       |        |      |            |
|   2 |   PX COORDINATOR       |                    |       |       |            |          |       |       |        |      |            |
|   3 |    PX SEND QC (RANDOM) | :TQ10000           |    57 | 37392 |   529K  (1)| 01:46:00 |       |       |  Q1,00 | P->S | QC (RAND)  |
|*  4 |     COUNT STOPKEY      |                    |       |       |            |          |       |       |  Q1,00 | PCWC |            |
|   5 |      PX BLOCK ITERATOR |                    |    57 | 37392 |   529K  (1)| 01:46:00 |     1 |     8 |  Q1,00 | PCWC |            |
|*  6 |       TABLE ACCESS FULL| TRANSACTION_RECORD |    57 | 37392 |   529K  (1)| 01:46:00 |  1953 |1048575|  Q1,00 | PCWP |            |
------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(ROWNUM<=100000)
   4 - filter(ROWNUM<=100000)
   6 - filter("PRODUCT_ID_DOMAIN"='ASIN' AND "ASIN_TITLE"='Monster Floorfillers 2011' AND "CATALOG_EXCEPTION"='Campingaz 2 Burner
              Stove Carry Bag' AND "FINALIZED_DATE">=TO_DATE(' 2011-10-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))


Statistics
----------------------------------------------------------
         14  recursive calls
          1  db block gets
    8703439  consistent gets
    6919356  physical reads
        132  redo size
       5215  bytes sent via SQL*Net to client
        442  bytes received via SQL*Net from client
          1  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          0  rows processed

Table TRANSACTION_RECORD is a partitioned by range(daily partitioned on finalize_date) and subpartitioned by hash (#partitions=8) on TRANSACTION_RECORD_ID (populatd by an oracle sequence-pk).
Table is having Parallel degree set to 4.
This table is having Conventional parth insert on 24x7 basis through 100+ concurrent sessions.
My question is : Is this normal to have 8.7M consistent gets (buffered IO) even if execution plan shows direct path read through parallel slaves. I am under impression that px read is always physical io from disk to pga.

I have seen that sql is using 4 parallel slaves to scan the table.