No question at this time
DBA Top 10
1 B. Vroman 15100
2 M. Cadot 14200
3 A. Kavsek 9300
4 J. Schnackenberg 6100
5 T. Boles 5500
6 M. Hidayathullah ... 5400
7 P. Wisse 2500
8 T. P 900
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48178
Total active users1670
Act. users last 24h2
Act. users last hour0
Registered user hits last week257
Registered user hits last month1287
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, 15 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, 14 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, 14 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