Ideas For Oracle Performance Topics

From time to time I get a little writer’s block and sometime search for topics to blog about. I thought, what better way to get ideas for blog posts than to ask the readers of this blog. Here is your chance to influence the topic of upcoming blog posts. I just have a few requests to keep things orderly:

  • Topics should in the context of the Oracle database and performance there of.
  • It’s not meant to be a Q & A, but rather the subject of a blog post.
  • Try to say as much as necessary, with the least amount of words.
  • It’s not meant to be a alternative to Oracle Support or Ask Tom.
  • Keep in mind it’s for a blog post, not a white paper or dissertation.
  • You get the gist…

Just a heads up: comments are moderated so don’t be surprised if they don’t show up immediately. Thanks much for taking the time to post your ideas/comments!

3 comments

  1. Krishna

    Hi Greg,

    I have often noticed that dba’s are not very knowledgeable when it comes to viewing system/storage stats to identify performance bottlenecks with respect to their database.

    In that context, can you post on a few simple and quick checks to identify if one is facing a performance issue ? This would be something which an Oracle DBA with non-privileged access can execute and draw conclusions – either through the database or system commands (Unix/Linux).

    Thanks
    Krishna

  2. smallkoala

    We know awr report is important for us to identify performance issues.But the report has a lot of context and not easy to understand.Could you post some typical tips about reading awr report? Thanks.

  3. whiz

    @Krishna
    Please Krishna,

    That was an absolute statement. Perhaps “The DBA’s I come across lack …..”
    By saying in the manner you have, its unfair.

    Consider this ….do you know that speeds of HDD matter a lot in latency and I/O.
    If you do then good. However in the end what really matters is the absolute result.
    Please allow me to give you an example.

    Consider a 15K rpm HDD.
    Now its obvious a 20K rpm would be faster. But then is it ?
    Please do the maths and you shall agree to the below.
    In order to shave off latency of just 1ms off a 15K rpm drive, the drive has to run at speed of 30K rpm. That’s twice for a measly 1ms.
    And the technology is not advanced enough for that drive speed.

    Absolute results matter. if 15K gives me what I want then 20K is really not up to it.
    The time taken for a job or query is the best unit of judgement.

    Basically I am trying so say :
    A Performance Tuning DBA is knowledgeable of all aspects of the domain.
    I would not generalise an absolute comment.

    Thanks,
    W.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s