Database Administration (MOSC)

MOSC Banner

12.1.0.2 : How to detect analytic indexes to drop them ?

edited Apr 22, 2015 10:00AM in Database Administration (MOSC) 2 commentsAnswered

Hi ,

I would like to implement in-memory option by following next steps :

1/

alter system set memory_max_target=7G SCOPE=SPFILE; -- Actual memory_max_target = 4 Go.

alter system set memory_target=7G SCOPE=SPFILE;  -- Actual memory_target = 4 Go.

ALTER SYSTEM SET INMEMORY_SIZE=3G SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP;

2/

ALTER TABLE IM_TAB_1  INMEMORY;

ALTER TABLE IM_TAB_2  INMEMORY;

...

ALTER TABLE IM_TAB_N  INMEMORY;

3/

My question is , how to detect analytic indexes in order to drop them ?

Best regards.

GD.

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