Ideas For Oracle Performance Topics

October 26th, 2007
Goto comments Leave a comment

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!

Post to Twitter Tweet This Post

Oracle, Performance, Troubleshooting

  1. Trackbacks

  2. No trackbacks yet.

  1. Comments

  2. Krishna
    November 27th, 2007 at 20:04 | #1
    Reply | Quote

    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

  3. smallkoala
    February 10th, 2008 at 20:55 | #2
    Reply | Quote

    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.

  4. whiz
    March 1st, 2010 at 14:11 | #3
    Reply | Quote

    @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.