|
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...
|
|
|
Using Cross-Instance Parallel Query |
|
MikeA
|
Friday, May 04, 2007 11:23 AM
|
|
|
|
With the use of RAC on the rise it is time to talk about the use of a feature very under-utilized in Oracle. This feature I refer to is cross-instance parallel query. Many times on site visits I see people using single-instance parallel query, but no one whose system I reviewed has used cross-instance parallel. Some weren’t aware it was available ...
|
|
|
|
|
Read More...
|
|
|
Sizing of Oracle10g Indexes |
|
MikeA
|
Wednesday, April 04, 2007 9:15 AM
|
|
|
|
In my last blog entry we looked at sizing tables in 10g, of course the other side of that coin is the sizing of indexes. As with tables the Oracle8 manuals had an explanation of how to size indexes, but manuals since then have been strangely silent on the subject. In this blog I will address the sizing of normal, b-tree ...
|
|
|
|
|
Read More...
|
|
|
Sizing Tables in Oracle |
|
MikeA
|
Friday, March 16, 2007 9:22 AM
|
|
|
|
On one of my first Oracle consulting assignments I had to come up with the sizing estimates for tables for a data warehouse for a telecommunications company in California. At that time, (1994) there were few products that provided sizing al ...
|
|
|
|
|
Read More...
|
|
|
How is Oracle Like Scuba Diving? |
|
MikeA
|
Wednesday, February 21, 2007 4:08 PM
|
|
|
|
One of my favorite things to do (when I am not tuning and managing Oracle databases) is to don a scuba tank, mask, and exposure suit and slip beneath the waters surface. For a long time I wondered how to reconcile these two interests and then it came to me.
|
|
|
Read More...
|
|