Skip to main content

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 '<path>/oracle/oradata/<Instan…

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}" = "" ] ; then
  MEM_DEV_AR…