Performance Testing Tools

To make db instance up:- login as oracle user source sett.csh <db> lsnrctl start sqlplus /nolog conn logon as sysdba; password <blank> startup ================================================ Steps to import Import Data dump: create Directory <name> AS '<path>/dumpfile' grant read,write on DIRECTORY <name> TO sa; impdp sa/sa@<Instance> DIRECTORY=<name> dumpfile=file.dmp

Tuning Database for Performance Testing: 1.       USERS tablespace created with a size of 20 GB 2.       INDX tablespace created with 15 GB 3.       TEMP tablespace set to 1 GB CREATE TABLESPACE INDX DATAFILE   '<path>/oracle/oradata/<Instance>/INDX_1.dbf' SIZE 6100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED,   <path>/oracle/oradata/<Instance>/INDX_2.dbf' SIZE 6100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL UNIFORM SIZE 40K BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON; ALTER TABLESPACE USERS ADD DATAFILE '/<path>/oracle/oradata/<Instance>/users02.dbf' SIZE 5120M AUTOEXTEND OFF; ALTER TABLESPACE USERS ADD DATAFILE '<path>/oracle/oradata/<Instance>/users03.dbf' SIZE 5120M AUTOEXTEND OFF; ALTER TABLESPACE USERS ADD DATAFILE '<path>/oracle/oradata/<Instance>/users04.dbf' SIZE 5120M AUTOEXTEND OFF; ALTER TABLESPACE USERS ADD DATAFILE

Open setDomainEnv.sh and change it by adding the below lines and deleting some more lines as shown below. WLS_HOME="${WL_HOME}/server" export WLS_HOME #**************************** echo SERVER_NAME=$SERVER_NAME GCLOGFILE="bin/JVMGCStats$SERVER_NAME.log" echo *********************** if [ "${SERVER_NAME}" = "AdminServer" ] ; then MEM_ARGS="-verbose:gc -Xms1024m -Xmx1024m -XX:MaxPermSize=128m -XX:SurvivorRatio=8 -XX:+PrintGCDetails -XX:+PrintTenuringDistribution -XX:+PrintGCTimeStamps -XX:+PrintHeapAtGC -Xloggc:$GCLOGFILE -DSESS_CLEAN_STARTUP=0 -DSESS_CLEAN_SLEEP=86400" else MEM_ARGS="-verbose:gc -Xms2048m -Xmx2048m -XX:MaxPermSize=256m -XX:SurvivorRatio=8 -XX:+PrintGCDetails -XX:+PrintTenuringDistribution -XX:+PrintGCTimeStamps -XX:+PrintHeapAtGC -Xloggc:$GCLOGFILE" fi #*************************** if [ "${JAVA_VENDOR}" = "Sun" ] ; then  if [ "${PRODUCTION_MODE}" = "" ] ; t