Posts Categorized: Technical Blog
In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.
My colleages and I want to set up a LAN radio station, so that we can all groove to the same soundtrack. To make things interesting, we want to be able to dynamically add songs to the playlist. From any machine. And since I don’t really have time to do something like that, I’m setting myself a deadline of one evening to get it running. Got it? Good. For it’s time to rip our shirts. And dance the Haka.
My good friend (and personal hero) Cary Millsap is doing a series of one day classes around the world — Mastering Oracle Trace Data. One of them is conveniently scheduled in Birmingham Thursday next week right after the UKOUG Conference.
I have decided to share with you some of the real life examples of why sometimes V$ views may hide real resources utilization numbers. As AWR and STATSPACK (previous version of AWR) as based on V$ views those may reflect the wrong statistics as results of the issues I am going to discuss in this blog post.
anticipate seeing people from all over the continent at UKOUG. The attendance over the past few years has been growing and nothing short of astounding. I am giving two papers at the show … one on a dear friend of us all called rman and the other on a close second … the physical standby. For me, even in the midst of emerging technology solutions, there’s still nothing like the old-fashioned Oracle CORE database arena.
I returned from AUSOUG conference in Perth (Australia) just last week. This blog is my report from the conference for the days 0 and 1.
Pythian continues to have a busy quarter with events right up to the end of the 2011 calendar year. If you happened to miss us at a past event, email firstname.lastname@example.org to reconnect or request a copy of the any of the presentations we’ve made through 2011 or earlier.
If you ever used SQL server Database Engine Tuning Advisor then you know you have few options as a source of analysis workload, here they are.
While Oracle does supply a list of RPMs that must be installed on a Linux system, that information does not help you in determining which Oracle files are dependent on the RPMs in question. If the list of RPMs to be updated is small, it may even be that that few, if any of the Oracle files on a server may be affected. Here’s how that can be determined.
If you do any performance tuning , and everyone does, then you’ll come to a point where you want to know if your tables have sufficient indexes to serve the queries fast, here’s how.