-
Use of Oracle FLASH_CACHE
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,
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|