 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
MikeA |
Created: |
Wednesday, October 18, 2006 4:54 PM |
|
|
Providing tips, techniques and insight into management and tuning issues affecting your database systems. |
|
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...
|
|
|
Tuning UNDO Segments |
|
MikeA
|
Monday, January 29, 2007 9:03 PM
|
|
|
|
Of the many databases I have examined on releases 9i and 10g, most are using the automatic undo management feature and on the whole it does a pretty good job of managing the undo segments (for you other old timers, rollback segments).
|
|
|
Read More...
|
|
|
Hidden Costs |
|
MikeA
|
Monday, January 08, 2007 9:40 AM
|
|
|
|
Caveat Emptor (Buyer beware) has been around since, well, since time began. Whether barter or cash, when doing a deal the buyer has to careful, this is especially true in the complex area of software licensing.
|
|
|
|
|
Read More...
|
|
|
Tailoring Session Parameters |
|
MikeA
|
Tuesday, December 26, 2006 5:03 PM
|
|
|
|
Many times I am asked how to tailor the initialization parameters for a specific process or user. Essentially the easiest way to set custom initialization parameters for a particular session is to use the ALTER SESSION SET command in a logon trigger keyed to a specific schema or schemas. For example, say we had an application where we wanted to set ...
|
|
|
|
|
Read More...
|
|
|
Removing 10g Grid Control |
|
MikeA
|
Thursday, December 14, 2006 12:36 PM
|
|
|
|
I recently went on a very nice vacation to Curacao. Before I went on vacation the Oracle 10g Grid Control (10.2.0.2) I had installed on my Laptop for monitoring my home office systems was working. I took my laptop with me to allow offload of pictures from my cameras and to track email while I was away. When I returned home and hooked my laptop back up to my home network Grid Control wouldn’t start and of course ...
|
|
|
|
|
Read More...
|
|
|
Watching Your ASMM in Oracle10g |
|
MikeA
|
Monday, November 27, 2006 8:44 AM
|
|
|
|
Oracle’s Oracle10g requires more memory than was ever required before. If you utilize any of the new features such as automatic storage management (ASM) and automatic shared memory management (ASMM) then you really need to pay attention to what memory is doing in 10g.
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|