Oracle全文检索耗资源,oracle 实时查询最耗CPU资源的SQL语句

1. 先通过top命令查看产用资源较多的spid号

https://www.cndba.cn/Dave/article/1227

https://www.cndba.cn/Dave/article/1227https://www.cndba.cn/Dave/article/1227

2.查询当前耗时的会话ID，用户名，sqlID等：

select sid,serial#,machine,username,program,sql_hash_value,sql_id,

to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') as login_time from v$session

where paddr in (select addr from v$process where spid in ('5648612','256523'));

3. 如果上一步sql_id或者 hash_value不为空，则可用v$sqlarea查出当前正在使用的sql

select sql_text

from v$sqltext_with_newlines

where hash_value = &hash_value

order by piece;

select * from v$sql where sql_id=''

https://www.cndba.cn/Dave/article/1227

---CSDN 网友提供的----

SELECTsql_textFROMv$sqltext aWHERE(a.hash_value, a.address)IN(SELECTDECODE(sql_hash_value,0, prev_hash_value, sql_hash_value),

DECODE(sql_hash_value,0, prev_sql_addr, sql_address)FROMv$session bWHEREb.paddr=(SELECTaddrFROMv$process cWHEREc.spid='&pid'))ORDERBYpieceASChttps://www.cndba.cn/Dave/article/1227https://www.cndba.cn/Dave/article/1227

https://www.cndba.cn/Dave/article/1227

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g