Thanks for the link, but at this moment I can not open any web page rather then oracle.com domain.
I am woking in a kind of enviroment where workload and queries are not filxed...
(oracle 10gR2,HP-UX 11.31)
One problem is that we captured some queries are showing high resource consumption, but what if they supposed to do so ? Application team not alway able to provide rigth picture about this.
I wonder who should be in picture to resolve these kind of issues ?
its not goes like that , you have to generate AWR reports and make more investigation Start Reading MOS Notes :
Troubleshooting: High CPU Utilization [ID 164768.1]
SMON Is Waiting On Latch High CPU Resource consumption MMON blocking SMON [ID 1496453.1]
Throttling Of Instances Causing High Resource Consumption [ID 1240114.1]