Feed items
Log Buffer #313, A Carnival of the Vanities for DBAs
The answers to the questions like whether to patch now or wait a little? What quirks are there in that stunning new features? What are the limitations of that fancy index type, any working examples of a particular add-on, are best found in the blogs. This Log Buffer Edition provides you a window to those blogs out there.
Oracle:
Performance Settings of Concurrent Managers
This is the second article in a series about internals and performance of concurrent managers. In this post, we’ll take a look at three important settings that affect the performance of the concurrent managers: number of processes, “sleep seconds”, and “cache size”. This article might be a bit on the theoretical side, but it should provide a good understanding of how these settings actually affect the behavior and performance of concurrent managers.
REMINDER – MySQL Community Dinner at Pedro’s 2013
Friends,
I want to remind you, to let us know if you would like to come for the dinner at Pedro’s on Tuesday April, 23.
Actually ALL of you should come !
Pedro’s is asking us to have a better idea of the number of participants, so please go to this page “MySQL Community Dinner at Pedro’s 2013”
and subscribe.
We want to have all of you enjoy the evening with us, subscribe & come!
Log Buffer #312, A Carnival of the Vanities for DBAs
There are no rules for blogging. There cannot be any, because you cannot trap the wind in your hands. It’s innovation, it’s creativity, and it’s right out of the core of the technology from the bleeding edge. This Log Buffer drips into that, and brings you some of the finest posts.
Oracle:
The Internal Workflow of e-Business Suite Concurrent Manager Process
Concurrent processing is one of the key elements of any e-Business Suite system. It provides scheduling and queueing functionality for background jobs and it’s used by most of the applications modules. As many things depend on concurrent processing it’s important to make sure the configuration is tuned for your requirements and hardware specification.
Oracle Trace Files in User Directories
I encountered an unusual situation recently where Oracle was writing trace files into the user directory instead of the usual oracle diagnostic destinations. Our monitoring software indicated that the “/home” directory was filling up. When I checked the space, I saw it had become 85% full.
$ df /home
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/home 20642428 16503552 3090300 85% /home
Tuning using v$mystat
When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. These session statistics complement the wait events found in ASH and trace files. The wait events do not show this information. Many of these session level statistics can be quite revealing. They can show some execution differences that are otherwise difficult, if not impossible for some, to see with trace files and ASH data.
Virtual IOUG Collaborate 13 for only $299
For only $299 you can access Virtual IOUG Collaborate 13 individually or setup a conference room at your company for the whole team.
