No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7200
3 B. Vroman 6200
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3200
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h7
Act. users last hour1
Registered user hits last week192
Registered user hits last month1051
Go up

Want to see 2 different date EXPLAIN PLAN DETAILS
Next thread: PL/SQL packages and Tuning Pack
Prev thread: dbca - single instance to rac - no copy

Message Score Author Date
Dear Experts, I want to know .. One batch jo...... Jill Salalila Feb 14, 2019, 08:37
DBA_HIST_SQL_PLAN (if you have purchased the app...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Feb 14, 2019, 11:05
Hi Mike, Is it recommended to configure <b> SQL...... Jill Salalila Feb 15, 2019, 05:55
Hi, You mean? https://blog.rackspace.com/use-s...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Philip Wisse Feb 15, 2019, 08:38

Follow up by mail Click here


Subject: Want to see 2 different date EXPLAIN PLAN DETAILS
Author: Jill Salalila, Philippines
Date: Feb 14, 2019, 08:37, 97 days ago
Os info: RHEL 6.4
Oracle info: 12.1.0.2
Message: Dear Experts,

I want to know ..

One batch job is executed every day (EOD).
A Query was running fine 2 days back.
But today Query is running worse. It takes more than usual time.

Is it possible to find/check last 2 days back explain plan with todays explain plan ?

Simply I want to see
A Query's explain plan on 12-FEB-19 and 14-FEB-19 ?

How it can be done ?
Thanks in advance.




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

Subject: Re: Want to see 2 different date EXPLAIN PLAN DETAILS
Author: Michel Cadot, France
Date: Feb 14, 2019, 11:05, 97 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
DBA_HIST_SQL_PLAN (if you have purchased the appropriate options) for the past and V$SQL_PLAN for the current instance.

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

Subject: Re: Want to see 2 different date EXPLAIN PLAN DETAILS
Author: Jill Salalila, Philippines
Date: Feb 15, 2019, 05:55, 96 days ago
Message: Hi Mike,

Is it recommended to configure SQLT utility ?
Do we need extra license to configure this utility ?


Thanks

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

Subject: Re: Want to see 2 different date EXPLAIN PLAN DETAILS
Author: Philip Wisse, Netherlands
Date: Feb 15, 2019, 08:38, 96 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

You mean?
https://blog.rackspace.com/use-sqlt-to-diagnose-difficult-sql-performance-issues
https://carlos-sierra.net/category/sqltxplain-sqlt/

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