Posts Categorized: Technical Blog
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.
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.
A simple example of BBCode would be to make some text bold , this can be simply written like that [b]Bold Text[/b] or italic [i]italic text[/i]. In HTML , this can be done by font tags (deprecated in newer HTML versions) or CSS text properties. I tell you what! I’m writing this blog and I’m even using some BBCode tags to format text.
Automatic degree of parallelism, or Auto DOP, is a new feature in 11gR2 that promises to help manage systems where large subset of the workload runs with parallel processing. In this post I’ll introduce the feature and give very useful tips I got from Oracle’s Real World Performance expert Greg Rahn on how to use it. So this is worth reading even if you are familiar with the feature.
This is a short blog post to give you my Apps DBA takeaway from Oracle OpenWorld 2011 in the context of Oracle Fusion Applications (new Oracle ERP/CRM/…+ product).
The MySQL errorlog is an important point of reference when administering a MySQL Server. We can grasp much about the state of our MySQL instance by the informational and error messages written out to it by our MySQL daemon. I was asked to investigate some replication outage alerts a colleague had received overnight. One of the primary directions I took was the error log file. This is where I would expect find any evidence of replication being stopped or crashes etc. When I ran the command to tail the log I was shocked to see the log was totally empty.