查找正在被你运行的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.
posted @ 2023-11-19 22:51  DBAGPT  阅读(18)  评论(0)  编辑  收藏  举报