Database Tuning (MOSC)

MOSC Banner

db_flash_cache integration

edited Mar 15, 2012 4:10AM in Database Tuning (MOSC) 2 comments
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center