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

Thread: Measure of response - UNIX and ORACLE

  1. #1
    Join Date
    Aug 2001
    Posts
    8

    Question

    Can anyone help me here?

    I am just looking for seuggestions, not answers, so any suggestions are appreciated.

    My boss asked to find a value of response time in seconds for UNIX and ORACLE. I was thinking of along the lines of using the unix commands - sar, iostat, vmstat, but he only wants ONE value for this. What do you think should be measured for response time?

    Remeber just suggestion or idea's, I tried telling the boss that you cant really base the whole the thing on one value, but he didnae take that as an answer!

    Cheers guys (and gals)
    Rich H

  2. #2
    Join Date
    Aug 2001
    Posts
    8
    any ideas people?????
    Rich H

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Response time of what? A specific query? An application? Creating a datafile? Truncating a table? A particular process?

    The best way, IMHO, to benchmark a system is to use actual pieces of the application. First, you need to figure out what you mean by "response time". Then, I would setup a test of typical user load, 3* typical user load, and 10* typical user load to see how my response time varies.
    Jeff Hunter

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Is your BOSS working in Account Dept?

  5. #5
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Well thats a wide open question. Version of Oracle, Version of Unix, Hardware? DSS or OLTP?

    I believe http://www.tpc.org may have some figures for ya.
    Doug

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If you would like to have same performance as of TPC, then you will spend around $100M for the HW and SW.

    Don't take TPC result seriously. They are all good for reading.

  7. #7
    Join Date
    Jul 2000
    Posts
    521
    if your boss can not be more specific and still needs ONE value, tell him/her this Unix/Oracle combo is invaluable.
    svk

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