Almost a year ago, I started a spotlight feature that I sadly haven't followed through on in a while so there is no time like the present! I met Ric Van Dyke when he was part of the Hotsos team that came into our offices several years ago to diagnose our performance problems and teach our group how to avoid them in the future. Imagine my surprise and delight when I found his blog after I attended the Hotsos Symposium in 2012!
Flash forward a few years and here we are! The first article I want to share is his latest about HASH_VALUE and PLAN_HASH_VALUE, as it has some "basic" information which is nonetheless important to have in our quest for complete knowledge about the Oracle database. Aside from the history of the feature, which is great as I am getting into this a bit late, Ric proves out the fact that two similar SQL statements that are written differently actually can share the same PLAN_HASH_VALUE but have different HASH_VALUEs. Additionally, he helps us remember another tool we have available to do troubleshooting and diagnosis of SQL plans!
I thought this was a great example of the articles that Ric writes, and I hope you'll enjoy the week long spotlight on his blog!
Showing posts with label spotlight. Show all posts
Showing posts with label spotlight. Show all posts
Monday, May 19, 2014
Wednesday, December 11, 2013
Blog spotlight follow up: Tanel Poder
The last spotlight I did was on Tanel Poder, and even though it has just been a few months he's absolutely published some gems which are worth visiting.
Did you know that it is possible for the SGA to be larger than the amount of HugePages in Linux? It is possible and maybe you'll learn something about USE_LARGE_PAGES and SGA_MAX_SIZE too.
Tanel has introduced a new version of his ash_wait_chains script! Looking forward to using this, and to see what's in his next version of the script too.
Want to learn more about Oracle Parallel Execution? Click here for part one and here for part two of some very seriously in-depth articles on the topic!
Ever have to replace a hard drive for Exadata? Tanel breaks down exactly WHY the system believes the drive has failed in a very methodical way that will be easy to replicate the next time we have an issue. I've even picked up a few new tricks here to look at disks in a proactive manner! Also, a great reminder that he has some webinars lined up that I know are worth signing up for.
Here is an interesting post on the difference between "cell flash cache read hits" versus "cell writes to flash cache" metrics.
Did you know that it is possible for the SGA to be larger than the amount of HugePages in Linux? It is possible and maybe you'll learn something about USE_LARGE_PAGES and SGA_MAX_SIZE too.
Tanel has introduced a new version of his ash_wait_chains script! Looking forward to using this, and to see what's in his next version of the script too.
Want to learn more about Oracle Parallel Execution? Click here for part one and here for part two of some very seriously in-depth articles on the topic!
Ever have to replace a hard drive for Exadata? Tanel breaks down exactly WHY the system believes the drive has failed in a very methodical way that will be easy to replicate the next time we have an issue. I've even picked up a few new tricks here to look at disks in a proactive manner! Also, a great reminder that he has some webinars lined up that I know are worth signing up for.
Here is an interesting post on the difference between "cell flash cache read hits" versus "cell writes to flash cache" metrics.
Tuesday, December 10, 2013
Blog spotlight follow up: Oracle Support EBS blog
My second spotlight was on the Oracle Support EBS blog, so tonight we turn back to the blog for many a good update!
The EBS Techstack landing page for R12 has been redesigned.
I mentioned this before, but it needs repeating; there is a new Procurement Enhancement Request Community that is the future of how Oracle will be working with the customer.
September 2013 Recommended Patch Collections have been released.
Looking for Troubleshooting Assistants (old Search Helpers)?
WebADI has changed with R12.
Help for stuck payments in R12 has arrived!
The year end checklist for HCM users.
A new analyzer for iProcurement has been released.
General Data Fixes (GDFs) for Payables are now available.
The 1099 patches for 2013 are out!
Recommended patches for Procurement in R12.
The EBS Techstack landing page for R12 has been redesigned.
Procurement development is focusing on the Buyer Work Center, and here are the top Enhancement Requests for it.
I mentioned this before, but it needs repeating; there is a new Procurement Enhancement Request Community that is the future of how Oracle will be working with the customer.
September 2013 Recommended Patch Collections have been released.
Looking for Troubleshooting Assistants (old Search Helpers)?
WebADI has changed with R12.
Help for stuck payments in R12 has arrived!
The year end checklist for HCM users.
A new analyzer for iProcurement has been released.
General Data Fixes (GDFs) for Payables are now available.
The 1099 patches for 2013 are out!
Recommended patches for Procurement in R12.
Monday, December 9, 2013
Blog spotlight follow up: Steven Chan's EBS blog
Several months ago, I started a feature of spotlighting blogs and now I want to start a follow up feature so where else would I start but with Steven Chan's EBS blog?
First off, Steven and crew have added a lot of updates which I'll break down into several different categories:
Certifications:
Java 1.6.0_60, 1.6.0_65, 1.7.0_40 and Java 1.7.0_45 are now certified with EBS.
Now you can use Transportable Tablespaces on 10gR2, potentially saving you time in your upgrade processes.
IE10 on Windows 7 is now certified with EBS.
The Application Management Pack is now certified with the latest version of 12c and EBS Plug-in 12.1.0.2 is now available for EM 12c.
The initial release of 12c is certified with 11i and R12, while the terminal release of 11gR2 is certified as well and even more certifications are available for 11gR2.
Multiple versions of EBS client configurations are now certified on Windows 8.
Firefox ESR 24 is certified with multiple EBS clients.
Running EBS on SPARC? If so, 11i is now certified with 11gR2.
Did you know that Office 2010 64-bit is certified with EBS 12?
R12:
The R12.1 Consolidated Update Patch #2 is available, but is not required if you are already on R12.
Steven reminds us that if you're on R12.1.1 or R12.1.2, you're closer to being able to go to R12.1.3 than you think!
Are you unsure if you should go to R12.1.3 or R12.2? Steven has an answer for you.
Do you know about the new flexfield value set security feature in R12.2?
Are you using Oracle VM Templates? New templates are available for R12.2.2.
New Information:
An offer to help Oracle shape the future of the next generation of the EBS interface. I'll sign up, how about you?
Want to see a great reason to attend Oracle OpenWorld next year? How about getting support timeline updates direct from the source?
The CPU for October has been released.
Did you know that you are expected to be signing your JAR files?
A new white paper on best practices for gathering EBS statistics, while another paper is available on getting optimal performance from the EBS.
Oracle is sharing the presentations from OpenWorld 2013 for a few months!
Elke suggests a series of upgrade recommendations that are available now.
Can you use 3rd party tools to modify your DB? Steven has an answer on this one too.
First off, Steven and crew have added a lot of updates which I'll break down into several different categories:
Certifications:
Java 1.6.0_60, 1.6.0_65, 1.7.0_40 and Java 1.7.0_45 are now certified with EBS.
Now you can use Transportable Tablespaces on 10gR2, potentially saving you time in your upgrade processes.
IE10 on Windows 7 is now certified with EBS.
The Application Management Pack is now certified with the latest version of 12c and EBS Plug-in 12.1.0.2 is now available for EM 12c.
The initial release of 12c is certified with 11i and R12, while the terminal release of 11gR2 is certified as well and even more certifications are available for 11gR2.
Multiple versions of EBS client configurations are now certified on Windows 8.
Firefox ESR 24 is certified with multiple EBS clients.
Running EBS on SPARC? If so, 11i is now certified with 11gR2.
Did you know that Office 2010 64-bit is certified with EBS 12?
R12:
The R12.1 Consolidated Update Patch #2 is available, but is not required if you are already on R12.
Steven reminds us that if you're on R12.1.1 or R12.1.2, you're closer to being able to go to R12.1.3 than you think!
Are you unsure if you should go to R12.1.3 or R12.2? Steven has an answer for you.
Do you know about the new flexfield value set security feature in R12.2?
Are you using Oracle VM Templates? New templates are available for R12.2.2.
New Information:
An offer to help Oracle shape the future of the next generation of the EBS interface. I'll sign up, how about you?
Want to see a great reason to attend Oracle OpenWorld next year? How about getting support timeline updates direct from the source?
The CPU for October has been released.
Did you know that you are expected to be signing your JAR files?
A new white paper on best practices for gathering EBS statistics, while another paper is available on getting optimal performance from the EBS.
Oracle is sharing the presentations from OpenWorld 2013 for a few months!
Elke suggests a series of upgrade recommendations that are available now.
Can you use 3rd party tools to modify your DB? Steven has an answer on this one too.
Monday, August 26, 2013
Troubleshooting PO Output
After doing my first blog spotlight last month, I'm convinced that it is a good idea so this week I'm going to spotlight the Oracle EBS Support blog. You may be asking yourself how this blog is different from Steven Chan's blog? Well, Steven is in charge of the Applications Technology Group at Oracle and as a result his blog is focused on the EBS from the ATG perspective where this blog is specifically aimed at the EBS and the modules that comprise it.
A few months ago, the Master Troubleshooting Guide for POXPOPDF (PO Output for Communication) was released on My Oracle Support. This guide includes setup checks, targeted patching, common issues, and additional troubleshooting help so it is well worth putting into your toolbox and procedures in order to avoid issues!
A few months ago, the Master Troubleshooting Guide for POXPOPDF (PO Output for Communication) was released on My Oracle Support. This guide includes setup checks, targeted patching, common issues, and additional troubleshooting help so it is well worth putting into your toolbox and procedures in order to avoid issues!
Monday, July 22, 2013
Blog spotlight: Steven Chan's EBS blog
Quite a while ago, I threatened to start spotlighting blogs I follow but this week I'm going to do better than just spot light a blog; I will share with you each day a different article, which has given me food for thought, taught me something about Oracle technology or just showed me how to be a better blogger.
If you aren't following Steven Chan's EBS blog, you need to! There are SO many snippets of good information that come out of this blog, that I eventually signed up to get the e-mail digest when a new post has gone up that day and I regularly send the information out to my team so we can all stay informed.
Recently we had a problem which we thought might be a load balancer or the firewall, so to My Oracle Support we went to try and find out what was happening. To my surprise several articles linked back to this post from 2007 on Steven's blog that very simply details out the interaction between loopbacks, firewalls, virtual IP, and load balancers which is so useful it is still a reference documentation Oracle uses today SIX years later!
If you aren't following Steven Chan's EBS blog, you need to! There are SO many snippets of good information that come out of this blog, that I eventually signed up to get the e-mail digest when a new post has gone up that day and I regularly send the information out to my team so we can all stay informed.
Recently we had a problem which we thought might be a load balancer or the firewall, so to My Oracle Support we went to try and find out what was happening. To my surprise several articles linked back to this post from 2007 on Steven's blog that very simply details out the interaction between loopbacks, firewalls, virtual IP, and load balancers which is so useful it is still a reference documentation Oracle uses today SIX years later!
Subscribe to:
Posts (Atom)