Index Inventory Report — ACME-192-0-2-120

Host: 192.0.2.120

Collected: 2026-08-19T18:00:46Z

Server dashboard: http://198.51.100.182:8080/report_dba/server-metrics.html?server=ACME-192-0-2-120

Fleet inventory: http://198.51.100.182: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.