Re: SQL Plan Management
- From: "Lyall Barbour" <lyallbarbour@xxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 07 Oct 2013 16:02:33 -0400
12c says that the one i Loaded is accepted AND enabled. The other one is only
enabled.
I don't see my SQL_HANDLE in the SQL_PLAN_BASELINE column of v$sql while this
query is running. I guess that means that NO baselines are being used for this
query.
This is our main inventory/sales order/supply chain ERP for our business. I
work for a Steel company and we worked with a vendor to build this ERP 6-7
years ago. Steelman, Inc from Toronto.
So, how the heck do i get 11g to use this baseline....?
Lyall
----- Original Message -----
From: Raghu Doppalapudi
Sent: 10/02/13 09:34 AM
To: lyallbarbour@xxxxxxxxxxxxxxx
Subject: Re: SQL Plan Management
Can you also check if the SQL Plan Baselines are Accepted and Enabled?
If you look at V$SQL.SQL_PLAN_BASELINE column,you will know for sure whether
the plan baseline is used or not (vs looks like :) )
I normally use the V$SQl_MONITOR view to look at SQL statements that take more
than 5 secs to execute... get the information from there to see what plan is
used.....
Just curious - what application is this DB supporting?
On Wed, Oct 2, 2013 at 7:22 AM, Lyall Barbour < lyallbarbour@xxxxxxxxxxxxxxx >
wrote:it's set to 11.2.0.4
I'm going to try to bounce the db, delete my baseline and the load the baseline
back in this morning.
Lyall Barbour
----- Original Message -----
From: David Fitzjarrell
Sent: 10/01/13 05:10 PM
To: lyallbarbour@xxxxxxxxxxxxxxx , oracle-l
Subject: Re: SQL Plan Management
How do you have optimizer_features_enable set in the 11.2 database?
David Fitzjarrell
From: Lyall Barbour < lyallbarbour@xxxxxxxxxxxxxxx >
To: oracle-l < oracle-l@xxxxxxxxxxxxx >
Sent: Tuesday, October 1, 2013 3:01 PM
Subject: SQL Plan Management
Hello everyone,
I'm in the middle of upgrading our 10.2.0.5 databases to 11.2.0.4 I'm trying to
get SQL Plan Management to make the 11g database run all our queries the same
as 10g was. This is what i did
1) Upgraded a database, which flushed SQL Cache memory
2) Created a Tuning Set on the Production database, with about 12k sql plans
3) Packed that set
4) expdp the tables (forget what they are called)
5) imported that dump into the 11g database
6) unpacked that Tuning Set
7) Loaded as a Baseline.
Everything looked good, i can see the Tuning Set, i can see all the Plans in
the Baseline. But when i run this one query in 11g, and it *looks* like it's
using the Baseline, it's really slow and the plan looks nothing like the 10g
plan in our current Prod database.
I have the OPTIMIZER_USE_SQL_PLAN_BASELINES set to true (default)
Did i miss a step?
Thanks,
Lyall Barbour
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
