Re: longops vs sql

Steve Howard wrote:
> 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

Sorry, that is assuming that 300 disk I/Os can be performed per second. That is just an estimate. Received on Thu Sep 07 2006 - 12:03:18 CDT