Re: Strange behaviour of Cramer query
From: Mladen Gogala <mladen_at_bogus.email.com>
Date: Wed, 24 Jun 2009 16:15:45 +0000 (UTC)
Message-ID: <h1tjfh$205$1_at_solani.org>
On Wed, 24 Jun 2009 05:41:18 -0700, HansP wrote:
Date: Wed, 24 Jun 2009 16:15:45 +0000 (UTC)
Message-ID: <h1tjfh$205$1_at_solani.org>
On Wed, 24 Jun 2009 05:41:18 -0700, HansP wrote:
> v$sql_plan shows only 1 plan.
>
> Does anyone have clue?
> Statistics cannot be the issue because the remain the same between
> executions.
>
What are the wait events? What are you waiting for, in one execution and what are the events that you're waiting on in the other execution?
-- http://mgogala.freehostia.comReceived on Wed Jun 24 2009 - 11:15:45 CDT