Database Administration (MOSC)

MOSC Banner

Index Investigation Script - Doc ID 989186.1

Hi. I have uncovered cases where a coalesce of an index can greatly improve performance of some queries and been all through these documents:

-- Index Rebuild, the Need vs the Implications ( Doc ID 989093.1 )

-- Script to investigate a b-tree index structure ( Doc ID 989186.1 )

I see that the 989186.1 doc only claims to be applicable through 12.1.2. I have implemented the script before, including recently, in 12.1.2 db's and it works. I now have a need to add it to a multi-tenant 19.13 db. I can get the objects implemented fine and the package and package body compile fine. But executing the procedure yields various errors. Is the script not applicable past 12.1.2?  If not, is there another oracle-approved, non-impactful method to see if indexes are in need of a coalesce or rebuild? 

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