Home » Infrastructure » Linux » oracle load testing (oracle 11g)
oracle load testing [message #664879] Thu, 10 August 2017 00:17 Go to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
I hv 24 tables in the schema, and needs to use DML and select operations on these tables for 24 tables to check the db performance testing. Can someone give the idea how can I generate the load on db??

If you needs any details then let me know.

Re: oracle load testing [message #664881 is a reply to message #664879] Thu, 10 August 2017 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OS?

Re: oracle load testing [message #664882 is a reply to message #664881] Thu, 10 August 2017 01:29 Go to previous messageGo to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
Linux
Re: oracle load testing [message #664883 is a reply to message #664882] Thu, 10 August 2017 01:42 Go to previous messageGo to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
I have gone through many testing tools like SLOB, SwingBench, and HammerDb etc but there are restriction of tables means these tool can generate upto max 9 tables in a schema. if you have the idea of testing tool that can generate the load testing for higher numbers. to come up over to 8-9 tables I have created 24 static table so now I want to load on those data tables by script/tools. pls let me know for details. thanks
Re: oracle load testing [message #664884 is a reply to message #664879] Thu, 10 August 2017 01:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
If you needs any details then let me know.
Yes, I need detail! Specifically, what is the purpose of this load testing? If it is to compare performance of the database and hardware then the TPC benchmarks should be fine; if it is some application that you have written, then you may have to write your own tool.
Re: oracle load testing [message #664885 is a reply to message #664882] Thu, 10 August 2017 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Simple shell script(s) will do the trick like a master script which will execute a client one (syntax may change depending on your shell):
# parameter = number of clients
i=1
while [ $i -le $1 ];
do
  client.sh &
  i=`expr $i + 1`
done
client.sh:
sqlplus usr/psw <<EOF
  <....the statements you want...>
EOF
Now client.sh may accept parameters like:
- type of the client: depending on it the statements are different
- think time: between each statements you wait for this time to simulate an interactive client
- a number of times the statements hav to be executed before leaving
...
Instead of sqlplus, this may a SQL*Loader or imp/impdp call...


Re: oracle load testing [message #664888 is a reply to message #664884] Thu, 10 August 2017 02:07 Go to previous messageGo to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
John,

Yes, It is to compare performance of the database and hardware. I have already tried to use TPC-C/TPC-H benchmark but these benchmark generates the schema only for 8 to 9 tables. Client here suggest us that 9 tables is not good enough to check, it must me 20-50 table set to check the performance test. I have here now 24 table's schema with dummy data set. is there any testing tool there we can enter/set the numbers of table more than 9.

thanks,
Re: oracle load testing [message #664889 is a reply to message #664888] Thu, 10 August 2017 02:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to educate your client. The TPC benchmarks are the industry standard, in what way does he think they are inadequate for him when they are good enough for the rest of the world? There is no reason why the number of tables used by the benchmark is of any significance.

Of course, if he has the budget you can charge him to develop his own benchmark that hits a thousand tables Smile
Re: oracle load testing [message #664892 is a reply to message #664888] Thu, 10 August 2017 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And what about the simple solution I mentioned?

Re: oracle load testing [message #664893 is a reply to message #664892] Thu, 10 August 2017 04:00 Go to previous messageGo to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
My question is based on oracle load testing and needs to know the process of load testing with lot of tables(dummy datasets). Bcz benchmark tools as I hv used test only on max 9 tables. Client need more than 20(min).
Re: oracle load testing [message #664894 is a reply to message #664893] Thu, 10 August 2017 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In what my reply does not answer your questions?

Re: oracle load testing [message #664919 is a reply to message #664889] Fri, 11 August 2017 03:57 Go to previous messageGo to next message
farid.mca@gmail.com
Messages: 6
Registered: August 2017
Junior Member
John, Agreed with your comment. But Hereafter I have one more question that What is the workload percentage of DML/Select operations in hammerdb TPC-H???
As calling circle (Oracle swingbench) benchmark percentage is like • Select 83% • Insert 7% • Update 10% • Delete 0%
Re: oracle load testing [message #664920 is a reply to message #664919] Fri, 11 August 2017 04:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Come on, man. How would I know? If you can't work it out by looking at the code and the docs yourself, ask the appropriate people. Not me.
Re: oracle load testing [message #664936 is a reply to message #664919] Fri, 11 August 2017 10:26 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 10 August 2017 11:07

In what my reply does not answer your questions?
I wanted to provide you a complete set of scripts to achieve your needs but as you have not the slightness correctness to answer me and showed the behavior of a lazy contemptible person I leave this topic and won't come back to any of your future ones.

Previous Topic: conversion problems
Next Topic: df command insert into sqlplus and table databas
Goto Forum:
  


Current Time: Thu Mar 28 17:18:57 CDT 2024