Re: Query with Bind variables hangs but hard coded literals works fine
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 26 Nov 2019 20:08:32 -0500
Message-ID: <72144a88-8c02-0739-3247-72958a912dc4_at_gmail.com>
Date: Tue, 26 Nov 2019 20:08:32 -0500
Message-ID: <72144a88-8c02-0739-3247-72958a912dc4_at_gmail.com>
As I've already said, I would definitely try with 10046 trace. That is by far the most precise method.
Regards
On 11/26/19 11:38 AM, Steve Wales (AddOns) wrote:
>
> * I gathered my initial plans using explain plan. Then I went and
> ran them both using the GATHER_PLAN_STATISTICS hint. Literals
> ran in less than a second. BV’s took 52-57 minutes (ran it a
> couple of times).
> * I will try Pathfinder and advise findings.
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 27 2019 - 02:08:32 CET