Database Administration (MOSC)

MOSC Banner

Ask about unused indexes

edited Jun 18, 2011 5:48PM in Database Administration (MOSC) 6 commentsAnswered
 Hi all,

      My database version 10g (64 bit). OS is linux 64 bit

      I want drop unused indexes on tablespace. But at first, I must monitor all of indexes. I read some documents about monitoring indexes with MONITORING and NOMONITORING. I use:

        select 'alter index '||owner||'.'||index_name||' monitoring usage;'
        from dba_indexes
        where owner not in ('SYS','SYSTEM');

    ---> Monitor all of indexes from my database server exclude SYS and SYSTEM. But how impact of this work on perfomance of database ? My database is slower ? or size of tablespace that contain this indexes will increase ?

    Plz, can help me about it ! Thanks

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