Script to load test an oracle database
Hi, gurus.I am conducting a performance test between Oracle GoldenGate and Oracle Database Gateway (formerly Transparent Gateway). We need to view data from an IBM DB2 database as close to real time as possible. So, we have to compare performance and connectivity for both tools.
here is an example:
select B_SYS_ID, sysdate from GGDB2TARGET.BALTIDTB where B_SYS_ID=68756665;
Goldengate and Gateway run on the same Linux server with 11.2.0.3 Oracle database. What I need to do is to flood database with connections running the same SQL.
Here are the challenges.
1) The SQL has to pass random values to WHERE clause, so data wouldn't be cached in memory.
here is an example:
select B_SYS_ID, sysdate from GGDB2TARGET.BALTIDTB where B_SYS_ID=68756665;
Goldengate and Gateway run on the same Linux server with 11.2.0.3 Oracle database. What I need to do is to flood database with connections running the same SQL.
Here are the challenges.
1) The SQL has to pass random values to WHERE clause, so data wouldn't be cached in memory.
1