No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

SPM 12c
Next thread: RMAN and expired backup sets
Prev thread: Trying to create a procedure to load partition data form one database to another using db links

Message Score Author Date
HI masters, I am reading some about SPM. there ...... javed akhtar Apr 04, 2018, 08:13
Hi, Please refer below links and mos notes on S...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Mirza Hidayathullah Baig Apr 04, 2018, 13:58
Also check FAQ of SPM FAQ: SQL Plan Management ...... Mirza Hidayathullah Baig Apr 04, 2018, 14:16

Follow up by mail Click here


Subject: SPM 12c
Author: javed akhtar, India
Date: Apr 04, 2018, 08:13, 200 days ago
Os info: linux
Oracle info: 12.1
Message: HI masters,

I am reading some about SPM. there is one point » Plan Selection:
» Ensures only accepted execution plans are used for statements with a SQL plan baseline and records any
new execution plans found for a statement as unaccepted plans in the SQL plan baseline.

how Oracle accept the multiple plans for the single query.

thanks,
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SPM 12c
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Apr 04, 2018, 13:58, 200 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

Please refer below links and mos notes on SPM and different plans

http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-management-11gr2-133099.pdf

How To Diagnose Why an Identical Query Has Different Plans (and Performance) in Different Environments (Doc ID 1671642.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: SPM 12c
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Apr 04, 2018, 14:16, 200 days ago
Message: Also check FAQ of SPM

FAQ: SQL Plan Management (SPM) Frequently Asked Questions (Doc ID 1524658.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here