Database Administration (MOSC)

MOSC Banner

How to disable flash cache in storage clause for a partitioned index?

Following a recommendation given by an Oracle analyst, we disabled the flash cache in storage clause for all indexes in our ODA X5-2.

eg.:

alter index mercury.idx_mercury_01 storage (flash_cache none);

However, for partitioned indexes this modification is not being made. We still have 11 indexes in that situation:

select index_name, flash_cache, partitioned from dba_indexes where flash_cache <> 'NONE' and owner in (select username from dba_users where oracle_maintained = 'N') and index_type <> 'LOB' and temporary = 'N' and index_type not like '%IOT%';

INDEX_NAME                                        FLASH_CACHE    PARTITIONED

-------------------------------------------------- --------------- --------------------

IDX_CU_DATETIME                                   DEFAULT        YES

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