26.4.3.30 The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer Views
These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention first).
These views user a helper view, x$ps_schema_table_statistics_io.
The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer views have these columns:
-
table_schemaThe schema that contains the table.
-
table_nameThe table name.
-
rows_fetchedThe total number of rows read from the table.
-
fetch_latencyThe total wait time of timed read I/O events for the table.
-
rows_insertedThe total number of rows inserted into the table.
-
insert_latencyThe total wait time of timed insert I/O events for the table.
-
rows_updatedThe total number of rows updated in the table.
-
update_latencyThe total wait time of timed update I/O events for the table.
-
rows_deletedThe total number of rows deleted from the table.
-
delete_latencyThe total wait time of timed delete I/O events for the table.
-
io_read_requestsThe total number of read requests for the table.
-
io_readThe total number of bytes read from the table.
-
io_read_latencyThe total wait time of reads from the table.
-
io_write_requestsThe total number of write requests for the table.
-
io_writeThe total number of bytes written to the table.
-
io_write_latencyThe total wait time of writes to the table.
-
io_misc_requestsThe total number of miscellaneous I/O requests for the table.
-
io_misc_latencyThe total wait time of miscellaneous I/O requests for the table.
-
innodb_buffer_allocatedThe total number of
InnoDBbuffer bytes allocated for the table. -
innodb_buffer_dataThe total number of
InnoDBdata bytes allocated for the table. -
innodb_buffer_freeThe total number of
InnoDBnondata bytes allocated for the table (innodb_buffer_allocated−innodb_buffer_data). -
innodb_buffer_pagesThe total number of
InnoDBpages allocated for the table. -
innodb_buffer_pages_hashedThe total number of
InnoDBhashed pages allocated for the table. -
innodb_buffer_pages_oldThe total number of
InnoDBold pages allocated for the table. -
innodb_buffer_rows_cachedThe total number of
InnoDBcached rows for the table.
© 2025 Oracle
Licensed under the GPLv2 License.
