Sysbench test oracle Installation Method 32-bit export CC = ccexport CFLAGS = "-I/u01/app/oracle/product/11.2.0/db_1/rdbms/public" export CXXFLAGS = "$ CFLAGS" export ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1export LD_LIBRARY_PATH = $ ORACLE_HOME/libPATH = $ PATH: $ ORACLE_HOME/bin: $ HOME/bin64-bit export CC = ccexport CXX = c ++ export CFLAGS = "-m64-I/u01/app/oracle/product/11.2.0/db_1/rdbms/public" export CXXFLAGS = "$ CFLAGS" export ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1/export LD_LIBRARY_PATH =/u01/app/oracle/product/11.2.0/db_1/lib installation Method. /autogen. sh. /configure -- prefix =/usr/local/sysbench -- with-oracle-libs =/u01/app/oracle/product/11.2.0/db_1/lib -- without-mysql specify the ORACLE database directory, overwrite the path in the Makefile. make ORA_LIBS =/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh. set the name of the TNS string to the host name. comp203 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = comp203) (PORT = 1527) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CS) test to generate data. /sysbench -- test = oltp -- oltp-table-name = sysbench -- oltp-table-size = 100000 -- oracle-db = comp203 -- oracle-user = dba_yangjian -- oracle-password = dba_yangjian -- db-driver = oracle prepare test data. /sysbench -- test = oltp -- oltp-table-name = sysbench -- oltp-table-size = 100000 -- oracle-db = comp203 -- oracle-user = dba_yangjian -- oracle-password = dba_yangjian -- max-time = 60 -- oltp-read-only = on -- max-requests = 0 -- num-threads = 2 -- db-driver = oracle run. /sysbench -- test = oltp -- oltp-table-name = sysbench -- oltp-table-size = 100000 -- oltp-non-index-updates = 50 -- oracle-db = comp203 -- oracle -user = dba_yangjian -- oracle-password = dba_yangjian -- max-time = 60 -- oltp-read-only = on -- max-requests = 0 -- num-threads = 2 -- db-driver = oracle run. /sysbench -- test = oltp -- oltp-table-name = sysbench -- oltp-table-size = 100000 -- oltp-index-updates = 50 -- oracle-db = comp203 -- oracle-user = dba_yangjian -- oracle-password = dba_yangjian -- max-time = 60 -- oltp-read-only = on -- max-requests = 0 -- num-threads = 2 -- db-driver = oracle run