1.top获取耗cpu或者内存高的数据库进程
2.使用以下sql获取sql_text

select sql_text
  from v$sqlarea
 where (address, hash_value) in
       (select /*+unnest*/
         DECODE(sql_hash_value, 0, prev_sql_addr, sql_address),
         DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value)
          from v$session
         where sid =
               (select sid
                  from v$session
                 where paddr =
                       (select ADDR from v$process where SPID = '95851')));
复制