526互联

查找正在被你运行的SQL的SQL_ID

发布时间 2023-11-19 23:01:09作者: DBAGPT
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.