Index Inventory Report — ACME-198-51-100-125

Host: 198.51.100.125

Collected: 2026-09-11T18:01:05Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-198-51-100-125

Fleet inventory: http://192.0.2.15:8080/report_dba/database-inventory.html

Oracle keeps no per-index seek/scan counters unless each index is placed into ALTER INDEX ... MONITORING USAGE, which is a change to the database rather than to the monitor. So there are no usage columns and no drop candidates here: an index that is never read looks exactly like one read a thousand times a minute. Everything below is what Oracle states on its own — what exists, its size, whether it is still usable, and how old its statistics are.

Never analyzed (2)

No statistics were ever gathered for these, so the optimizer is costing them from defaults. On 8i that is the rule-based path in practice.

All indexes (172)

Every index on the instance, largest first.