查找正在被你运行的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 secildi.
 
SQL_ID: 7r0kgzntdn7sq
 
SQL> SET FEEDBACK OFF SQL_ID
SQL> SELECT COUNT(*) FROM DBA_OBJECTS;
 
  COUNT(*)
----------
     92633
 
SQL_ID: 7r0kgzntdn7sq



SQL> SET FEEDBACK ONLY
SQL> SELECT * FROM DBA_OBJECTS;  <<<< 很实用哦，很多时候 咱们不需要结果集，只需要结果行数
 
92633 sat?r secildi.