SAP BC 低性能SQL语句跟踪

1、首先在服务器上执行top命令，查看哪几个数据库（Oracle）的Pid占用 CPU较高

2、找到对应的PID，查找对应的SQL ID

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 ('29851'));  //Pid

 

3、找到对应的SQL 语句

 select sql_text, disk_reads, buffer_gets, parsing_schema_name, executions
from v$sqlarea WHERE SQL_ID  = 'fv3j3fjsssdzh'

4、然后在SAP db02 -性能-SQL Statement Analysis-shared cursor cache