SQL_ID
查找正在被你运行的SQL的SQL_ID
SQL> SHOW FEEDBACK FEEDBACK ON for 6 or more rows SQL_ID OFF SQL> SET FEEDBACK ON SQL_ID SQL> SELECT COUNT(*) FROM DBA_OBJECTS; COUNT(*) 92633 1 sat?r ......
给定SQL_ID,查看访问的表以及其统计信息
-- https://github.com/jkstill/oracle-script-lib/blob/master/sql/stats-sqlid.sql -- stats-sqlid.sql -- get stats info for all objects used in a SQL_ID ......