Home > Oracle Tips > Oracle Voices > Why every performance tool stinks
Oracle Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ORACLE VOICES

Why every performance tool stinks


Craig Shallahamer
08.31.2004
Rating: -4.27- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


Craig's Corner
Insights on Oracle technologies and trends by Craig Shallahamer
About the Author

Craig Shallahamer has 18-plus years experience in IT. As the president of OraPub, Inc., his objective is to empower Oracle performance managers by "doing" and teaching others to "do" whole system performance optimization (reactive and proactive) for Oracle-based systems.

In addition to course development and delivery, Craig is a consultant who was previously involved with developing a landmark performance management product, technically reviews Oracle books and articles, and keynotes at various Oracle conferences.

To view more of Craig's work, visit www.orapub.com.

You may be wondering why someone who makes a living planning and optimizing Oracle-based systems thinks every performance tool sucks. I'll tell you why! I'm surrounded by performance problems and performance tools that suck... including mine.

I like my tools. I really do. They are simple, fast, and do the job. They have evolved over the years into a very complete and advanced tool kit that I can quickly install and use. Like any other tools, they are limited and could be improved to increase my productivity and creativity, but that takes time, which is something I closely guard. So, until I find something better, I'll stick with what works and watch for the system management tool industry's new wares.

I don't think I'll see anything anytime soon. The problem is the industry. With all its millions of market research, it still has not captured the true need and the true heart and soul of a DBA. There is so much information oozing out of performance tools, someone who can read The Matrix language still could not understand this stuff. I know the information is there in some tools. But, I'm also equally certain the information presentation is not. And so, we enter the world where over one hundred performance tool vendors compete for your IT budget.

With all the tools on the market today, you would think a problem's root cause could be firmly established within four mouse clicks. But most software wants you to look at tons of information and sift through all the sludge. It's like using an email filtering program...you still have to double check all the filtered emails just in case -- worthless. How about a lot of intelligence built into the product? I'm talking about automatic, self-aware, and root cause identification. But I don't think there is anything on the market yet. Vendors will argue this point, but I'm not convinced. It still takes a skilled professional to sift through the data and a highly skilled salesperson to make you believe it's automatic and self-aware.

And don't tell me that Response Time Analysis (RTA) is the answer. I published the first RTA paper, and I'll tell you it's just a piece of the pie. A significant piece, but all the same, just a piece. It's an answer, not the answer. Some professional RTA tools want you to do absurd things to your system (which I won't mention) so you can diagnose the problem. Nope -- not going to do it. There has got to be something better.

Something like graphics that actually mean something. You've been there too. You're standing around a really slick graphic depiction of a system and after a few hours someone has the guts to say, "What's it mean?" Another hour or two later someone else says, "I don't know, but it sure is cool looking." Cool is not good enough for me. I'm looking for graphics that grab my soul and bring me into the system, while I still maintain and even flourish in my humanity.

I know our industry's companies can do better than striving for the next quarter's net-profit-deductible-after-tax-net-gain-nothing. They just stick with what "works." Does this sound familiar? They find salespeople who can still sell an 8-track tape player, give them a significant percentage, make sure they aren't familiar with words like Enron and ethics, help them find big IT budgets, and then let them go to work. It sounds crazy until you actually meet salespeople like this. Honestly, take a close look at those stacks of binders from really expensive software that is supposed to make your job easier and more fun…they never get used.

The software is not used because the solution is not elegantly simple. I mean really simple and really elegant. The first user interface for my rightsizing product, HoriZone, was very thorough, but it took people too long to figure out how to use the system. So hardly anyone did and I wondered why. Then I ran across a book that asked the question: How would Leonardo DiVinci use a computer? After reading the book it dawned on me why I had this love/hate relationship with Windows, why people weren't flocking to HoriZone, and why the best performance tools on the market today do, in fact, really suck.

It's because our tools don't do what we want them to do in an elegant fashion. Most tools try and conform us to them, not empower us. Ask yourself, when was the last time your computer really empowered you to create something beautiful something that you're really proud of? For most people, it doesn't happen very often, if ever. And that's sad. We all have the innate capability to create beauty. But the tools we use just help us get by, not fly.

I know I'm whining. But as an experienced performance specialist, and especially as a consumer, that is my right. I will always be looking for the DBA tool that will expand my capabilities and allow me to leave work feeling good, not tired.

Someday I'll see that tool... I hope. I haven't yet. But when I do, I'll post it on my web site, use it on all my performance engagements, and sell it with a passion.

Rate this Tip
To rate tips, you must be a member of SearchOracle.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Oracle Database Administrator
What is the difference between a database engineer, architect and administrator?
Import on one table from dump file
Error during RMAN backup
Can I drop a column in SYS schema?
STATSPACK tool: transaction vs. execution measurement
Should I port from Microsoft Access?
Installing multiple Oracle homes
How can I find statistics on total memory usage and database connections?
Modifying SYS password in a RAC environment
How to create Datafiles in a Data Guard (10g) environment

Oracle database performance problems and tuning
Oracle 11g data compression
Varchar or number for better performance?
Do statistics on SYS-owned objects hurt performance in 10g?
Inside the Oracle 11g SQL Performance Advisor, part 1
Inside the Oracle 11g SQL Performance Advisor, part 2
Difference between driving table and driver table in Oracle
Best design for E-Business Suite on hard drive
20GB data dictionary causing performance problems
Using the cost-based optimizer to improve Database 10g performance
Online tablespace reorganization in Oracle 9i

Oracle Voices
Essential performance forecasting, part 2: I/O
Essential performance forecasting, part 1
Performance tuning: The limits and limitlessness of time
Oracle myths debunked
Why Oracle hashing is so cool
Why it's OK to have more latches than CPUs
Performance war
Triangulation: Hunting down performance bottlenecks

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

HomeNewsTopicsTipsAsk the ExpertsWebcastsWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts