Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
      1,431,909            8      178,988.6   12.8    13.16     33.05 2225735611
Module: engine.exe
SELECT  /*+ INDEX_ASC(cash cash_3ind) */ Ref,Zero,DbCr,Ban
k,Acct,BankRef,BankCashDate,OrigBal,RemainBal,Curr,FxOrigBal,FxR
emainBal,UOrigBal,URemainBal,SecIDType,Cusip,FxRate,ValueDate,Ca
shDesc,LastMatch,Ledger,BankSecIDType FROM pamcash WHERE Bank>=:
Bank AND(Bank>:Bank OR(Acct>=:Acct AND(Acct>:Acct OR(Ledger>=:Le

      429,636           20       21,481.8    5.5    10.69     60.36 4173079977
Module: RG.exe
 Select Distinct ASSETID,  SECURITYIDTYPE,FROMDATE,TODATE,DATEBA
SIS,COSTBASIS,PORTFOLIONUMBER,USERID  From RPT_HOLDINGS_Temp   W
here PORTFOLIONUMBER= :"SYS_B_00" And trunc(FROMDATE)= TO_DATE(:
"SYS_B_01",:"SYS_B_02") And trunc(TODATE)= TO_DATE(:"SYS_B_03",:
"SYS_B_04") And DATEBASIS= :"SYS_B_05" And COSTBASIS= :"SYS_B_06


 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
        423,731           20       21,186.6   61.8    10.69     60.36 4173079977
Module: RG.exe
 Select Distinct ASSETID,  SECURITYIDTYPE,FROMDATE,TODATE,DATEBA
SIS,COSTBASIS,PORTFOLIONUMBER,USERID  From RPT_HOLDINGS_Temp   W
here PORTFOLIONUMBER= :"SYS_B_00" And trunc(FROMDATE)= TO_DATE(:
"SYS_B_01",:"SYS_B_02") And trunc(TODATE)= TO_DATE(:"SYS_B_03",:
"SYS_B_04") And DATEBASIS= :"SYS_B_05" And COSTBASIS= :"SYS_B_06

SELECT  /*+ INDEX_ASC(pamcash pamcash_3ind) */ Ref,Zero,DbCr,Bank,Acct
,BankRef,BankCashDate,OrigBal,RemainBal,Curr
,FxOrigBal,FxRemainBal,UOrigBal,URemainBal,SecIDType
,Cusip,FxRate,ValueDate,CashDesc,LastMatch
,Ledger,BankSecIDType
FROM pamcash 
WHERE Bank>='xxx' 
AND(Bank>'xxx' OR ( Acct>=18 AND(Acct>18 OR(Ledger>=to_date('28-feb-03', 'dd-mon-yy')))));

345685 rows selected.

Elapsed: 00:00:49.30

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=335 Card=155459 Byte
          s=21919719)

   1    0   TABLE ACCESS (FULL) OF 'PAMCASH' (Cost=335 Card=155459 Byt
          es=21919719)





Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
      31512  consistent gets
       3529  physical reads
          0  redo size
   52622339  bytes sent via SQL*Net to client
    2558425  bytes received via SQL*Net from client
      23047  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
     345685  rows processed
     
     
Select Distinct ASSETID,  SECURITYIDTYPE,FROMDATE,TODATE,DATEBASIS,COSTBASIS,PORTFOLIONUMBER,USERID  
From RPT_HOLDINGS_Temp 
Where PORTFOLIONUMBER= '3093' 
And trunc(FROMDATE)= TO_DATE('01-12-2006','dd-mm-yyyy') 
And trunc(TODATE)= TO_DATE('31-12-2006','dd-mm-yyyy') 
And DATEBASIS= 'Ledger' 
And COSTBASIS= 'GAAP';

3824 rows selected.

Elapsed: 00:00:06.28

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   SORT (UNIQUE)
   2    1     TABLE ACCESS (BY INDEX ROWID) OF 'RPT_HOLDINGS_TEMP'
   3    2       INDEX (RANGE SCAN) OF 'RPT_HOLDINGS_TEMP_PK' (UNIQUE)




Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
       4780  consistent gets
       3886  physical reads
         60  redo size
     451801  bytes sent via SQL*Net to client
      28624  bytes received via SQL*Net from client
        256  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
       3824  rows processed
     
 

 High buffer gets in the first sql is due to high "get per exec". 
Consistent gets could not be the reason as it is not having high physical reads.

- Second sql is due to consistent reads as it is having Physical reads, despite a relatively high gets per exec.

And FROMDATE >= TO_DATE('01-12-2006','dd-mm-yyyy')
AND FROMDATE < 1 + TO_DATE('01-12-2006','dd-mm-yyyy')