Posts

Showing posts from July, 2011

Importing Database

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 Oracle Database for Performance Testing

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

To obtain GC Activity in Logs in Weblogic

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