db_flash_cache integration
I've a customer who wants to use db_flash_cache feature of 11g.
To simulate created the database on 11.2.0.1 and 11.2.0.3 version.With memory sizing as below:-
db_cache_size=500M,Pga_aggregate_taget=300m,shared_pool_size=100m.db_flash_cache_size=12GB with proper grants on raw device used for flash_cache.
The table size as 9GB in a test schema.Queried table using full table scan hint.
The flash_cache is not being getting used, also the select is not using db_cache.
I would like to know is there any changes in 11g from previous FTS.