Posts Categorized: Technical Blog
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 email@example.com 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.
If you haven’t considered attending the AUSOUG conference in Perth yet, you definitely should! Out of 50 sessions I counted 21 to be presented by Oracle ACEs and Oracle ACE Directors; 8 by Oracle employees and at least 2 by Oracle Certified Masters! Briefly looking though the conference program I would like to suggest that you consider sessions from the following speakers.
After an in place upgrade of SQL server 2005 to SQL server 2008 R2 , I tried to open SQL errorlog from Management> SQL server logs but I got the following error. Here’s how I fixed it.