search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

curlog #2

Open baobao219 opened 5 years ago

baobao219 commented 5 years ago

在RAC环境中，无法正确执行curlog.sql脚本，建议修改如下 select member from v$logfile where group# in (select group# from v$log where status = 'CURRENT'); 即将“=”修改为"in"

baobao219 commented 5 years ago

或者修改成如下内容 SELECT member FROM v$logfile WHERE group# =( SELECT group# FROM v$log WHERE status = 'CURRENT' AND thread# = userenv('instance') );