SQL> set linesize 200
SQL> set pagesize 200
SQL> select * from v$mystat where rownum<2;
SID STATISTIC# VALUE
---------- ---------- ----------
1175 0 0
SQL> select * from (select * from TLYH order by owner) where rownum<20;
正在执行SQL:
SQL> select sid,
serial#,
username,
sql_hash_value,
sql_address,
prev_hash_value,
sql_hash_value
from v$session
where sid = 1175 2 3 4 5 6 7 8 9 ;
SID SERIAL# USERNAME SQL_HASH_VALUE SQL_ADDRESS PREV_HASH_VALUE SQL_HASH_VALUE
---------- ---------- ------------------------------ -------
查找正在运行或上一次执行的sql
最新推荐文章于 2021-03-10 02:23:59 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)