select name,value from v$sysstat where name like 'parse%';我的方法找出多次沒有綁定變量的sql:select count exe_count,module,SQL_TEXT from (select ROW_NUMBER()over(partition by substr(SQL_TEXT,1,50) order by SQL_TEXT) num,a.* from (select count(*)over(partition by substr(SQL_TEXT,1,50)) count ,SQL_TE...【阅读全文】
场景:查出被锁的对象。select * from dba_ddl_locks where NAME like 'PRO%'针对session id 查出进程id。select spid, osuser, s.program from v$session s,v$process pwhere s.paddr=p.addr and s.sid=154由于常规方法无法删除。所以通过,直...【阅读全文】
转载:http://blog.csdn.net/robinson1988/article/details/7836338性能优化最好的书就是官方文档。官方文档每一句话都值得引起我们深思。Allocation UnitsWhen you create a disk group, you can set the Oracle ASM allocation unit size withthe AU_SIZE disk group attribute. The values can be 1, 2,...【阅读全文】
环境:RHEL5.8 RAC 11.2.0.3.01:查看ORC和voting disk信息:In 11g Release 2 your voting disk data is automatically backed up in the OCR whenever there is a configuration change.所以恢复时恢复备份OCR即可,这里和10g是不同的,不需要备份voting disk,备份OCR即可2:使用cluvfy 工具检查OCR完整...【阅读全文】