Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2004
    Posts
    10

    Unanswered: Simple Performance Question

    Platform: IBM AIX 5.2
    Application: Oracle E-business suite 11i
    DB: oracle 9.2.0.6


    Question:

    A User calls and states the system is very, very slow. What steps do you use to determine the cause of the problem?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    NO, not a simple performance question.
    Isolating the cause in a 3-tier environment can be a REAL hard challenge.
    It also helps to know what is behaving normally ( 'cuz then that is not the problem).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    Posts
    330
    You must always assume that the user has not changed his code or his queries because that is never the cause of poor performance.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I disagree. It is a very simple question. The answer has been known to fill books, and still be incomplete, though.

  5. #5
    Join Date
    Nov 2004
    Posts
    10
    I knew it wasnt a simple question; I'm still trying to figure it out a systematci way to troubleshoot in our environment. The question boggled me when a Director was logging into one of our test environments and while waiting for Oracle Applications to load, she said, 'Connection time is very slow. I wonder why?'.

    So, without going into the details of connection pooling, dispatchers, shared server processes, ect... I just told her we needed faster P.C.'s.

  6. #6
    Join Date
    Jan 2004
    Posts
    370
    Be careful what you wish for.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I generally start with a high level approach. Look at whatever resource monitors you can get hold of, and look for spikes in CPU , disk activity, Memory, Network Activity, or anything else. Check all machines in the system, since you can not be certain where the problem is, then try to work your way down from there.

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    such a generic question.
    have statspack running during those times that this SLOWNESS occurrs.

    also, I would do a cursory search and investigation on the code that is run
    from the app side that seems slow. trace and tkprof the session that is slow.

    perhaps it is not using an index, perhaps the table stats are old and need
    analyzing, perhaps an index was dropped (unlikely but possible), perhaps
    additional data was loaded onto those tables and your scalability tests did
    not account for that large amount of data.

    ANYTHING is possible, but those are some likely candidates.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    Sep 2005
    Posts
    4
    If somebody calls and says "the system is slow", I usually proceed with a 10046 trace. Cary Millsap has an excellent book titled "Optimizing Oracle Performance" on this subject. To interpret the trace file you can buy a commercial tool such as the Hotsos profiler, or download for free Trace Analyzer. See MetaLink Note ID: 224270.1. The resulting output will show you the Oracle kernel wait events that are consuming the most time, and it these you should focus on tuning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •