We have Oracle 10.2.0.4.0 version running on 2 node RAC environment.
I need to calculate maximum logical_reads_per_call and cpu_per_call for a sql statement.
Can somebody help me.
Is it possible to find it out from AWR / ASH reports for the peak period. I was able to find CPU and reads per execution and per statement. but not able to locate reads and cpu usage per call.
Basically we want to set the values to logical_reads_per_call and cpu_per_call to limit queries utilizing more resources. For setting the values, we need to know the current consumption.