Re: Query with Bind variables hangs but hard coded literals works fine

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 26 Nov 2019 20:08:32 -0500

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

References:
- Re: Query with Bind variables hangs but hard coded literals works fine
  - From: Steve Wales (AddOns)

Other related posts:

» Query with Bind variables hangs but hard coded literals works fine- Steve Wales (AddOns)
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Stefan Koehler
» Re: Query with Bind variables hangs but hard coded literals works fine- Jonathan Lewis
» Re: Query with Bind variables hangs but hard coded literals works fine- Neil Chandler
» Re: Query with Bind variables hangs but hard coded literals works fine- Jonathan Lewis
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Sayer
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Chris Taylor
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Klock
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Wattenhofer
» Re: Query with Bind variables hangs but hard coded literals works fine- Ethan Post
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Chris Taylor
» Re: Query with Bind variables hangs but hard coded literals works fine- Steve Wales (AddOns)
» Re: Query with Bind variables hangs but hard coded literals works fine - Mladen Gogala