Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Internal Benchmarking

Internal Benchmarking

From: Orr, Steve <sorr_at_rightnow.com>
Date: Wed, 14 Nov 2001 13:27:16 -0800
Message-ID: <F001.003C50EE.20011114130018@fatcity.com>

Howdy All,

I want to create some database-only benchmarking scripts to reflect a typical day in the life of a custom application. I'm thinking about using LogMiner to get the redo and v$sqlarea to derive a representative mix of queries. Maybe we can also sniff/parse the network traffic to the DB server. Since I'm looking only at database activity I'm not too keen on applications which merely record and replay end-user keystrokes and mouse clicks but I would like to mimic delays in transaction commits due to network latency and user indecision or whatever. I'd also like to be able to increase the load intensity by factors of 10 to 1000. Has anyone created any application specific benchmark routines and can you share some tips on how to do this? Any good tools that you have used? Any comments on Mercury Interactive stuff? Other ideas?

AtDhVaAnNkCsE,
Steve Orr
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 14 2001 - 15:27:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US