Check out Craig Shalamahar site www.orapub.com under tools. He got a free loadtesting tool.
Cheers, RS > > Can anyone recommend and low cost tool(s) for load > testing a database > > server? I looked at Quest's Benchmark Factory, > but it > > doesn't provide > > the flexibility I need in this situation I'm > facing The $15K I was > > quoted for the Quest tool is a bit pricey, so I > don't believe more > > expensive tools (e.g., Load Runner) are viable > candidates. > > > > Here's what I have to work with: > > > > I will have a log file from our mid tier server > that will contain all > > the SQL generated by the application. However, > since the > > system is not > > in production, I will be limited to using a single > user or > > small group > > to simulate use of the application. Therefore, I > will have to find a > > way to scale the limited capture to > production-like levels and > > substitute values for transactions and queries. > > > > Can anyone recommend a tool(s) that would allow me > to 1) automate > > substitution of values in WHERE clauses and > INSERT/UPDATE > > statements and > > 2) perform load testing using ascii files as the > input? > > > > TIA for your help, > > > > Ed > > > > > > > > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at > http://mail.yahoo.com > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Ed > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).