|
An Analysis of Database Issues |
|
MikeA
|
Friday, March 21, 2008 9:58 AM
|
|
|
|
In my ten plus years as a database consultant before joining Quest Software I had the opportunity to visit hundreds of client sites. At client sites I performed analysis of their environments to help them improve the performance of their database systems. In this blog I want to talk about the top ten performance-related issues that I saw over and over again.
The following table lists them in order of occurrence: ...
|
 |
|
|
Read More...
|
|
|
First, don’t Panic! |
|
MikeA
|
Tuesday, February 12, 2008 9:28 AM
|
|
|
|
I was working the other day to rebuild my Linux 32 bit cluster in preparation for doing some tests between OEM and PAO for some internal training. I planned to use raw for my cluster configuration and voting files for CRS and ASM for the rest of the shared files. The 32 bit cluster had been up and operating fine and I had completed the testing I was doing so I retasked the drives to build a 64 bit cluster. I dr ...
|
|
|
|
|
Read More...
|
|
|
Q&A from Webcast on using Indexes to Boost Performance |
|
MikeA
|
Thursday, January 24, 2008 2:20 PM
|
|
|
I recently gave a webcast about using indexes to boost your application performance, of course at the end of the webcast we took questions, unfortunately I wasn’t able to anser all of the questions so I pulled the ones I felt were most important and decided to answer them here in my blog. For the full webcast see :
|
|
|
Read More...
|
|
|
Questions from the Instant Replay Webcast |
|
MikeA
|
Wednesday, January 16, 2008 10:56 AM
|
|
|
|
Well, here I sit at 30,000 feet over the Atlantic heading for London and then on to Abu Dhabi. It seems like just yesterday I was doing a webcast for the Performance Allstars series on Instant Replay and the use of history to find problems, oh wait, that was yesterday!
During the webcast many excellent questions where asked concerning historical data c ...
|
|
|
|
|
Read More...
|
|
|
Further Travels in Betaland |
|
MikeA
|
Friday, September 28, 2007 3:13 PM
|
|
|
|
Well, I decided that Linuxtown wasn’t going anywhere very fast and with the all the SRs I was leaving in my wake I soon would not be welcome by the locals so I decided I would take it on the lamb over to Windowsville for a while. Besides it was looking like the local disk array was going to pin a power supply failure on me.& ...
|
|
|
|
|
Read More...
|
|
|
Messing With 11g 32bit RAC |
|
MikeA
|
Wednesday, September 05, 2007 10:25 AM
|
|
|
|
Well, the 32 bit 11g beta is officially over with the GA of the 11g 32 bit release on the Oracle download site. I replaced my beta copy with the production release and started playing about 2 weeks ago. I tho ...
|
|
|
|
|
Read More...
|
|
|
The Joys of Beta Testing |
|
MikeA
|
Monday, July 30, 2007 9:48 AM
|
|
|
|
I am participating in the Oracle11g beta. The next time I tell you I am going to do a beta please lock me up until the fit passes. I have subjected myself to this abuse since Oracle8, usually tied with writing or updating a book. Maybe I am getting smarter as I get older as I am not (currently) involved in a book project although there may be one or two mor ...
|
|
|
|
|
Read More...
|
|
|
|
Can You Take a Hint? |
|
MikeA
|
Thursday, June 14, 2007 10:14 AM
|
|
|
|
Hints in Oracle have been around since version 8. Hints are like compiler directives that tell Oracle what path to take when optimizing a SQL statement (generally speaking.) However, Oracle will ignore the hint if it can’t do it or it is formatted poorly.
|
|
|
|
|
Read More...
|
|
|
The Cost of Poor Database Design |
|
MikeA
|
Wednesday, May 30, 2007 9:32 AM
|
|
|
|
I’ve been searching for a definitive answer to the question: “What is the cost of poor database design?” No doubt you have all seen the cost/benefit graphs for fixing application problems and the pyramid showing how up to 90 percent of performance issues in a running database are SQL and ind ...
|
|
|
|
|
Read More...
|
|