Re: longops vs sql

Ben wrote:
> The following SQL is supposed to give me disk reads that take longer
> than 10 seconds.
>
> SELECT sql_text nl, 'Executions= ' ||
> executions nl,
> 'Expected Response Time in Seconds= ',
> disk_reads / decode(executions, 0, 1, executions) / 300 "Response"
> FROM v$sql
> WHERE disk_reads / decode(executions, 0, 1, executions) / 300 > 10
> AND executions > 0
> ORDER BY hash_value, child_number
>

Hi Ben,

I may be missing something, but how is that giving you SQL that took longer than 10 seconds to execute? That is just showing the statements where the number of disk reads per execution / 300 is greater than 10. What is the significance of the 300?

Regards,

Steve Received on Thu Sep 07 2006 - 09:38:48 CDT