????????oracle??????к?????????loadrunner??oracleЭ????????oracle???в?????????????????java?????oracle???в???????????????????μ?????????
????????????????????JDK1.6
????????????JAVA_HOME
???????????C:Program FilesJavajdk1.6.0
????????????CLASSPATH
???????????.;%JAVA_HOME%libdt.jar;%JAVA_HOME%lib ools.jar;C:programfileloadrunnerclasses;C:programfileloadrunnerlib;%JAVA_HOME%liboracle_11g_11.2.0_jdbc_ojdbc6.jar
????????????Path
???????????%JAVA_HOME%in;%JAVA_HOME%jrein;
????????loadrunner????
???????Э?飺Java Vuser
????????????????? Oracle_11g_11.2.0.1.0_JDBC_ojdbc6.jar
????????jdk??loadrunner??????????
?????????????-classpath??loadrunner/classes??loadrunner/lib??jdk/lib/dt.jar??jdk/lib/tools.jar??oracle_11g_11.2.0_jdbc_ojdbc6.jar
????????LoadRunner????java???????磺oraclDBtest
????1??oraclDBtest.class???????loadrunner->classes->com???????
????2?????import com.oraclDBtest?????е???;
????loadrunner??????
import lrapi.lr;
import com.oraclDBtest;
public class Actions
{
public int action() throws Throwable {
lr.start_transaction("start");
oraclDBtest.testSelet();
lr.output_message("test_action");
lr.end_transaction("start"?? lr.AUTO);
return 0
};
????Java??????
??????????PGA??С????????£?
????SQL> show parameter pga;
????NAME                      TYPE        VALUE
????------------------------------------ ----------- ------------------------------
????pga_aggregate_target      big integer 520M
???????????SQL???????????????PGA??С?520M??
???????sql?????????SGA???С??
????SQL> show parameter sga;
????NAME                                 TYPE        VALUE
????------------------------------------ ----------- ------------------------------
????lock_sga                             boolean     FALSE
????pre_page_sga                         boolean     FALSE
????sga_max_size                         big integer 2G
????sga_target                           big integer 2G
????????????????SGA????С?2G??
???????shared_pool_size?????????????£?
???????SQL??????v$shared_pool_advice???
????select t.SHARED_POOL_SIZE_FOR_ESTIMATE "SP"??
????t.ESTD_LC_SIZE                  "EL"??
????t.ESTD_LC_MEMORY_OBJECTS        "ELM"??
????t.ESTD_LC_TIME_SAVED            "ELT"??
????t.ESTD_LC_TIME_SAVED_FACTOR     "ELTS %"??
????t.ESTD_LC_MEMORY_OBJECT_HITS    "ELMO"
????from v$shared_pool_advice t;
??????????????????????CPU?????????????????????????????????????????????д??????????????????SQL????????????CPU????????linux??top????????????????????CPU??oracle?????????????y????PID???????????????????????????????

?????????????26113????????????μ?sql???

????????????????sql???????????