DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Oracle script/tool to measure the performance

  1. #1
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99

    Question Oracle script/tool to measure the performance

    Hi,

    I am going to upgrade the memory on an Oracle database server (8.1.7.4). Is there any Oracle script/tool that can be used to compare the before and after of the upgrade to get the performance gain? Thank a lot.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Who told you that if you add more memory you will get performance gain.

    Tamil

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by jiong
    I am going to upgrade the memory on an Oracle database server (8.1.7.4). Is there any Oracle script/tool that can be used to compare the before and after of the upgrade to get the performance gain? Thank a lot.
    What metrics did you use to determine you need to upgrade memory?
    Jeff Hunter

  4. #4
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi Tamil and Jeff,

    I didn't make the decision. I am just being told to do the upgrade and compare the performance.

    Thank you two.
    Jiong
    ---------------------------
    OCP (DBA 8, 8i, 9i, AD, iAD)
    SCSA, SCJP, SCWCD
    ---------------------------

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Take statspack reports in 5 min interval. And compare the results.

    Tamil

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by marist89
    What metrics did you use to determine you need to upgrade memory?
    ...and have the person that decided to run them again.

    Otherwise, measure your transaction throughput using statspack before the upgrade and after. Actually, in this case, I'd suggest a statspack snapshot every 60 minutes. In this particular case (but not in the case of diagnosing a performance problem) you are more interested in an overall transaction rate over a long period. Not that you couldn't do it with data every 5 minutes, but if you are looking at several days for comparison the amount of data gets big.
    Jeff Hunter

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    take statspack snapshot during a week with 60 minutes interval nefore you add memory

    after add memory take statspack snapshot for a week then compare

  8. #8
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi Tamil, Jeff, and Pando,

    Thanks for all the reply. They are very helpful.

Posting Permissions

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


Click Here to Expand Forum to Full Width