This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!
How to resolve unusual situation where Oracle was writing trace files into the user directory instead of the usual oracle diagnostic destinations.
When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. I had a situation that required to look at these stats so I could see why one query would run fast and sometimes much slower. I wrote a simple wrapper ksh shell script for the query. It saves the session statistics in a table before and after the execution of the query and then prints out the statistics in a pivot report. This turned out to be very handy to me and therefore I chose to share it with the world :)
For only $299 you can access Virtual IOUG Collaborate 13 individually or setup a conference room at your company for the whole team. There will be two tracks broadcasted so if you have demand for both tracks, it make sense to purchase two access passes and setup two tracks broadcasted in parallel in your office so that members of your team can choose individually what to attend.
With real possibilities and opportunities, blogging is getting mature day by day, and so is the technology and its innovations. The combination of both becomes a dazzling medley, which is called as Log Buffer. Enjoy this week’s stunning Log Buffer #311.
When you set sizes for areas of the SGA (e.g. large_pool_size or java_pool_size) you might often see Oracle has used different and sometimes much larger values, this post explains some of the reasons why this might happen.
Mother, mother Oracle. I have heard you call… Wanted to sail upon your cloud (control) since 7.3.4… You’ve seen it all, you’ve seen it all… (Paraphrased from Jimmy Buffett’s, “A Pirate Looks at 40”) For a while now, Oracle Enterprise Manager (OEM) has had an application management component for E-Business Suite (EBS). However, it wasn’t…
Spring is a very active conference season for me. I might be going to half a dozen conferences in 3-4 months. That’s a lot of travel but I look forward to all them. The conference I’m probably looking forward the most this year is IOUG Collaborate.
Notwithstanding all the new shiny features the latest database release can provide; in this post I am going to put in dollars and cents the reasons why upgrading your database makes economical sense.
In this post I go through some tips and advice when revoking UNLIMITED TABLESPACE in Oracle, and look at how to form the experts.