Eye on Oracle

Aug 1 2007   8:10AM GMT

Wednesday wrap-up: Low-cost database tuning tips

Beth Pariseau Beth Pariseau Profile: Beth Pariseau

Following up on Mark’s post from last week (“Do Oracle Database innovations really matter?”), check out this article from Computerworld on how DBAs solve problems cheaply. It seems to support the assertion that new features aren’t all that:

Experienced DBAs know that new versions usually pack in more features, meaning that any performance boost is more likely to come from the expensive hardware upgrade accompanying a database upgrade, not the database upgrade itself. And those gains can be limited, if underlying design flaws or operational problems remain.

The article goes on to list some ways you can improve database performance with elbow grease instead of throwing money at the problem, such as fixing bad SQL code (duh) and implementing “intelligent balancing of traffic” for database-backed Web sites.

More links of interest from around the Web . . . Nishant Kaushik of Talking Identity offers an overview of what the Bharosa acquisition adds to Oracle’s access management capabilities, including the addition of contextual and software-based authentication to Oracle Access Manager and improved fraud detection and identity theft protection.

Doug Burns goes over some questions to ask if your manager asks you for workload metrics:

  • What do you mean by “workload”?
  • How much detail are you looking for?
  • Over what time intervals?

And, mostly importantly he says, “Why?” The reason you want the metrics will define your approach to gathering them. (Open questions like this, according to Doug, are what make being a DBA fun.)

Finally, catering to my obsession with all things Google, Andy C charts out which companies have most embraced Facebook. (I’ve started collecting Facebook invitations in lieu of Facebook “friends” . . . I just can’t bring myself to join any social networking sites. Don’t they exist solely so people can waste time at work? IM is bad enough . . . ) Google leads the pack, with almost 52% of employees on Facebook, followed by Yahoo at 34% and Microsoft at 25%. Oracle’s Facebook factor is much lower, just under 6% — only 4,280 Oracle employees out of 74,674. What, Larry Ellison figures he has enough friends already?

Have a good week everybody,

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: