Re: V$SQL Executions
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: hostetter.jay@xxxxxxxxx
- Date: Mon, 19 Sep 2011 23:48:34 +0800
Also look at cpu_time, disk_reads, buffer_gets etc. SQL executions that
began but were interrupted / cancelled / killed.
Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
sent from my smartphone
On 19 Sep 2011 23:33, "Jay Hostetter" <hostetter.jay@xxxxxxxxx> wrote:
> I have numerous sql statements in the library cache where the value for
> executions is equal to 0. These statements have been loaded at various
> times over the last few days. I would assume that the application is
> parsing the statement, but not actually executing it, which seems odd to
> me. Are there other reasons that cause the value of the executions column
> to be zero? I know that executions could be zero while a statement is
> executing for the first time, but many of these statements were loaded
days
> or hours ago - they weren't loaded a few minutes ago. I feel like I'm
> missing something obvious here.
> This is Oracle 10.2.0.5 on Windows 2008.
>
> Thank you,
> Jay
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
