When tuning an application that is under heavy load, one of the issues is that some queries perform very well most of the time, but occassionally run very long and create application problems. These queries don’t look suspicious from OEM or the AWR reports, but they cause unexplained blips in the application. If you’re looking […]