Every engine can tell an administrator how its storage is used, and every engine does it differently: different catalogs, different units, different ideas of what free space means. This release puts one set of storage questions over all five engines the platform runs most, and answers them from each engine's own catalog, with the basis of every figure stated rather than assumed.
The same questions on every engine
- Database and containers. The size of a database, its dbspaces or tablespaces with their free space, and its largest tables.
- One table in depth. Partitions and extents, how full the pages are, every index with its keys and when it was last read, and how current the statistics are.
- Honest where an engine cannot answer. Where an engine does not expose a figure, such as free space in a PostgreSQL tablespace that is a directory on the file system, the answer says so instead of inventing a number.
- Who is using it. A companion facet reports which sessions have a database open and which hold or wait on a table, the fast answer when an operation that needs a table to itself is refused.
Sizing and review
- Size before it exists. Given a row size and a row count, the platform estimates the space a table and its indexes will take from the engine's own page layout.
- Findings with their statement. A review turns a table's measurements into findings, duplicate or redundant indexes among them, each carrying the statement a person would run and what running it costs in locks and space. Nothing is run by the review itself.
- Informix-specific rules. On Informix the review also finds interleaved extents, a page size that fits the row badly, attached indexes, and a rebuild that would outgrow temporary space.
- Available to agents. Four read-only
dba_storage_*tools expose the same answers over MCP, behind the same gate as the other database tools.
The advisor only reads. Every change it proposes is a statement for an administrator to review and run, which keeps storage decisions where accountability for them already sits.