Re: V$SQL Executions

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Mon, 19 Sep 2011 23:48:34 +0800
Message-ID: <CAMNBsZungzbLwqJUKfUF3hZC3fn_H7=RhcqVND9r66aBB7DNFg_at_mail.gmail.com>

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_at_gmail.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 19 2011 - 10:48:34 CDT