Weekend Learning: Collecting information to troubleshoot SQL performance problems

Have you ever run into a situation where SQL is not performing like it should?  We have a lot of tools now compared to "back in the day" (before Oracle Enterprise Manager) but some of the classics can be found in MOS article "SRDC - How to Collect Standard Information for a SQL Performance Problem" from note ID 1594386.1 and even if you do not need to work with Oracle to help solve the problem you can utilize these tools to diagnose and possibly resolve it!

Weekend Learning: Assets archiving, purging and restoration

Are you archiving or purging anything from Oracle Assets?  Did you know that you can restore what you archive and purge?  Learn more this weekend from My Oracle Support document "Oracle Assets Troubleshooting Guide For Archive, Purge And Restore" from note ID 144432.1 and see if you can't make your EBS footprint just a bit smaller!

Weekend Learning: Troubleshooting WF_CONTROL issues for Workflow Agent

Check out the MOS document "Troubleshooting WF_CONTROL Agent issues" via note ID 469045.1 to catch up on things you may already have setup in your system like the concurrent program that needs to run to clean this queue up or find out what AQs you can query to verify your system is running just fine!

Weekend Learning: Troubleshooting row cache enqueue locks

Check out MOS document ID 278316.1 to get up to speed with "Troubleshooting: "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! "" which was created for Oracle databases 8i but appears to be completely relevant for us today on 11g and 12c databases!  There are a TON of other articles linked on here as well that you should take a look too!!

Resolving archive logs not being shipped to standby

Have you had occasion to see your remote/DR instance become disconnected or otherwise offline to your primary database?  If so, make sure you bookmark MOS document "Logs are not shipped to the physical standby database" via note ID 1130523.1 for your troubleshooting needs later!

Weekend Learning: JDBC driver cursor leak on 11.2.0.4

Do you know how sometimes you can stumble across a solution for a problem, when you are not even looking for it?  Well let me introduce you to My Oracle Support document "Cursor Leak After Upgrading to JDBC Driver 11.2.0.4" via note ID 1939530.1 and ask if you have been having problem with "middleware" or "web services" after upgrading to 11.2.0.4?  We are not on 11.2.0.4 YET, but on 11.2.0.3 we have had some issues with memory leaks so this type of issue could be the next condition we encounter so now I am aware of it and can potentially start looking for it when we start upgrading (and testing).  Luckily we have not had the ORA-01000 errors indicated in this article, but forewarned is forearmed.

Weekend Learning: Troubleshooting Essbase Agent when hanging

Did you know there are some step by step instructions for how to troubleshoot the Essbase Agent when it is hanging?  The note "Troubleshooting Essbase Agent Hangs on UNIX Systems" on My Oracle Support via document ID 1107095.1 gives you the steps using the pstack and netstat commands!  On top of it all, they give you the other information needed to open an SR when you encounter this issue which may clue you in on the application log files you need to be monitoring in the future.

Weekend Learning: JDBC/JVM connection troubleshooting

Have you made sure you have every little bit of performance from your system?  Well here is another way to squeeze out a little more performance from your system by visiting My Oracle Support note "Please update JDBC settings following MOS Basic troubleshooting of JVM consuming CPU or too many JDBC connections in EBS Apps 11i" via document ID 370583.1 and even if you are on R12 there are some nuggets of information that may interest you including a linked document towards the end of the article which is not exclusive for 11i.

Weekend Learning: Troubleshooting memory leaks for UNIX (Siebel)

Recently I ran across the My Oracle Support article "How To Troubleshoot Memory Leaks on UNIX" in note ID 477522.1 but I was a bit disappointed to find it relating to Siebel application/architecture because I do not know anything about this nor am I aware of us running this software at work.  Why did I still post it then?  Well, this might not be specifically apples to apples for everybody (and if you support Siebel, bonus!) yet I think there are a few general ideas that can be extended for other applications so it is certainly worth a quick review.

When a bug really is not a bug

Since I do not get to develop or QA in my regular job duties, articles like this one from Maris Elsins are perfect eye-openers as they expand my horizons a bit so when I get into unusual situations I have more tools in my mental toolbox.  Go read Maris' article about what he found when he encountered an issue where it really looked like it was a bug on his version of the Oracle DB, but after troubleshooting and analysis it really was not a bug at all.

This situation reminded me a lot of my recent posting about how XLA data builds up and affects the A/P module in ways that were totally not expected or encountered when we were testing R12!

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!