Hi All,

I need some help.

This is a question on Oracle FLASH CACHE usage.

Environment: Oracle 11G R2
FLASH CACHE: 400GB
Number of records in the src_big_table: 300million rows per day.

There is a big debate going within our DBAs at present about the FLASH CACHE usage. I need to know which one of the below INSERT logic/option will be using the FLASH CACHE so that data will be cached for dependant processes to use.

a) INSERT into trg_big_table SELECT * from src_big_table

b) INSERT into trg_big_table SELECT /*+ parallel(src,16) */ * from src_big_table src

c) INSERT /*+ parallel(trg_big_table,16) */ into trg_big_table SELECT /*+ parallel(src,16) */ * from src_big_table src

d) BULK LOAD - SELECT /*+ parallel(src,16) */ * from src_big_table src and INSERT /*+ parallel(trg_big_table,16) */ into trg_big_table

commit every 100000 records

e) BULK LOAD - SELECT * from src_big_table src and INSERT /*+ parallel(trg_big_table,16) */ into trg_big_table

commit every 100000 records

f) BULK LOAD - SELECT * from src_big_table src and INSERT into trg_big_table

commit every 100000 records

g) BULK LOAD - SELECT * from src_big_table src and INSERT /*+ APPEND_VALUES */ into trg_big_table

commit every 100000 records

Please let me know which option would use/record data in the FLASH CACHE.



Kind Regards,