26.4.3.31 The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views
These views display which tables are being accessed with full table scans. By default, rows are sorted by descending rows scanned.
The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns:
-
object_schemaThe schema name.
-
object_nameThe table name.
-
rows_full_scannedThe total number of rows scanned by full scans of the table.
-
latencyThe total wait time of full scans of the table.
© 2025 Oracle
Licensed under the GPLv2 License.