Tuesday May 17, 2016

Recap - OTN Tour EMEA - Baku, Azerbaijan - 2016

Working on a Saturday is not common for me but happens from time to time mostly when I travel abroad or when a customer has a critical upgrade or migration on a weekend.

Having 120 skilled and enthusiastic people in a conference day on a Saturday is VERY UNCOMMON. And having them stay from 9am to 6pm is a sign that the selection of topics fit the interest of the audience - and the presenters got their attention the entire day.

Please find the slides and the Hands-On-Lab here:

I'm full of a ton of positive emotions (you know that Germans are ice cold and keep their feelings mostly under control, don't you *haha*) - still two days later. That was such a amazing day in Azerbaijan. I haven't been to this country before neither have I visited Baku. The only thing I knew about Baku was from my youth days when I used to play chess in our school team and tried to learn from Garri Kasparov's books. He was born in Baku.

The city is beautiful. Unfortunately I didn't see much as I wished as I had to rush back to Germany. But looking at the 1000s of pictures Oracle ACE Director Joél Perez has taken in two days it is very scenic. Speaking of the other presenters I learned a lot from everybody, Chris Antonini from Trivadis, Björn Rost from Pythias and of course from Joel.

And ... I know now - thanks to the AzerOUG's president Kamran Agayev that ALT+N advances the Java-based DBUA when the NEXT button is outside of your screen's scope and does not appear no matter what you do. Thanks my friend, you saved me :-)

Congrats also to all the organizers - everything worked perfectly well.

The conference got even attention in television:


;-)

I hope I can come back soon with a bit more time to look around.

CU all soon!

--Mike

Friday May 13, 2016

Recap - OTN Tour EMEA - Milano, Italy - 2016

Milano Centrale - OTN Tour EMEA 2016

Thanks for this excellent day yesterday in Milano for the OTN EMEA Tour 2016. What a great audience, excellent speakers covering a broad spectrum - and also a perfect organization.

In case you need the slides please find them here (or many more including the Hands-On-Lab) in the Slides Download Center to your right (scroll down a bit):

I'm looking forward to Baku, Azerbaijan now - but I hope as well that the Italian User Group will stay now more active. There's such a huge potential and so many great customers and people ...!!!

Ciao!

--Mike

Wednesday Sep 09, 2015

Different Metrics for SPA (SQL Performance Analyzer)

I'm more the command line type of person. Once I've understand what's going on behind the curtains I certainly switch to the GUI-click-click tools. But in the case of Real Application Testing - even though the support via the OEM GUI is excellent - sometimes I prefer to run my procedures from the command line and check my reports in the browser.

Recently Thomas, a colleague from Oracle ACS Support, and I were asking ourselves about the different comparison metrics for the SQL Performance Analyzer reporting We did scan the documentation but we found only examples but no complete list. Then we did ask a colleague but thanks to OEM we got an incomplete list as well.

Finally Thomas dug it out - it's stored in the dictionary in the table V$SQLPA_METRIC

SQL> SELECT metric_name FROM v$sqlpa_metric;

METRIC_NAME   
-------------------------
PARSE_TIME               
ELAPSED_TIME             
CPU_TIME                 
USER_IO_TIME             
BUFFER_GETS              
DISK_READS               
DIRECT_WRITES            
OPTIMIZER_COST           
IO_INTERCONNECT_BYTES    

9 rows selected.

What do you do with these metrics now?

You can use them in such a way:

set timing on

begin
dbms_sqlpa.execute_analysis_task(
   task_name=>'SPA_TASK_MR07PLP_11107_12102',
   execution_name=>'Compare workload Elapsed',
   execution_type=>'compare performance',
   execution_params=>dbms_advisor.arglist(
                     'comparison_metric','elapsed_time',
                     'execution_name1','EXEC_SPA_TASK_MR07PLP_11107',
                     'execution_name2','TEST 11107 workload'),
   execution_desc=>'Compare 11107 Workload on 12102 Elapsed');
end;
/

You can vary the elapsed_time in my example with the various comparison metrics mentioned in v$sqlpa_metric

--Mike 

Thursday Jul 30, 2015

Things to consider BEFORE upgrading to Oracle 12.1.0.2 to AVOID poor performance and wrong results

Finally it got published on MyOracle Support (MOS) portal - one of the most helpful notes when we prep for an upgrade or a migration - and potentially the one with the longest title in MOS:

MOS Note: 2034610.1
Things to consider BEFORE upgrading to Oracle Database 12.1.0.2
to AVOID poor performance and wrong results 

Avoid Poor Performance and Wrong Results when upgrading to 12.1.0.2

Just in case you are NOT upgrading/migrating to Oracle Database 12.1.0.2 there are three other helpful notes for earlier releases available as well:

Document 1320966.1
Things to Consider Before Upgrading to 11.2.0.2
to Avoid Poor Performance or Wrong Results

Document 1392633.1
Things to Consider Before Upgrading to 11.2.0.3
to Avoid Poor Performance or Wrong Results
Document 1645862.1
Things to Consider Before Upgrading to 11.2.0.4
to Avoid Poor Performance or Wrong Results

--Mike 

Thursday Apr 17, 2014

Avoid Poor Performance and Wrong Results in 11.2.0.4

One of the best notes in MOS got refreshed last night for Oracle Database 11.2.0.4. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the "sleeping beauties" as you as a DBA usually won't recognize them. It is recognized at the application level when the result of a report is incorrect or instead of 4 rows just 3 rows get delivered in the output. Therefore you should be highly aware of those and add this note to your bookmarks.

MOS Note 1645862.1Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results

And in case you don't want to move to Oracle 11.2.0.4 but searching for information and known issues in Oracle 11.2.0.3 or Oracle 11.2.0.2 then please find the corresponding documents:

  • MOS Note: 1320966.1 Things to Consider Before Upgrading to 11.2.0.2.x to Avoid Poor Performance or Wrong Results
  • MOS Note: 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
-Mike

Wednesday Jul 29, 2009

Ministry of Justice (UK) - live on 11g

[Read More]
About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle

Based in Germany. Interlink between customers/partners and the Upgrade Development. Running workshops between Arctic and Antartica. Assisting customers in their reference projects onsite and remotely. Connect via:

- -

Search

Archives
« June 2016
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
17
18
19
21
22
23
24
25
26
27
28
29
30
  
       
Today
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
Workshop Map
x Oracle related Tech Blogs
This week on my Rega & Pono
Upgrade Reference Papers