-- ############################################################################################# -- -- %Purpose: How to reclaim UNUSED_SPACE from Indexes and Tables using DBMS_SPACE.UNUSED_SPACE -- -- Before growing a datafile in a tablespace that shows on your -- space…
Read More-- ############################################################################################# -- -- %Purpose: Tuning Redologs und Checkpoints (Contention, Waits, Number/Duration of Checkpoints) -- -- ############################################################################################# 1). Redolog Buffer Contention ----------------------------- SELECT SUBSTR(name,1,20) "Name",gets,misses,immediate_gets,immediate_misses FROM v$latch WHERE name in…
Read MoreWeblogic Reports and forms services Start/Stop Start a WebLogic Forms and Reports Services : export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain export FR_INST=$MW_HOME/asinst_1 echo “Starting AdminServer” nohup $DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 & sleep…
Read MoreSteps to start and stop a WebLogic domain and managed server Start a WebLogic domain and managed server : export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/clusterDomain echo “Starting AdminServer” nohup $DOMAIN_HOME/startWebLogic.sh > /dev/null…
Read MoreSteps to start and stop Node-manager in weblogic Starting node-manager : export MW_HOME=/u01/app/oracle/middleware export WLS_HOME=$MW_HOME/wlserver_10.3 echo “Starting Node Manger” nohup $WLS_HOME/server/bin/startNodeManager.sh > /dev/null 2>&1 & echo “Done!” Stopping node-manager :…
Read MoreTo find the dependent packages or objects related to a package Below query is used to find the dependencies for an objects or a package So we can avoid the…
Read MoreQuery to find current cache hit ratio in database Below query represents the exact cache hit ratio happening currently in database The minimum figure of 89% is quoted below, but…
Read MoreHow to Run Expdp Impdp Jobs in Background Step 1: Create export or import parameter file $ cat exp.par userid=abc/def job_name=tab_export directory=EXP_DIR dumpfile=TST_table_exp.dmp logfile=TST_tab_exp.log REUSE_DUMPFILES=y tables=sox.PROFILE,sox.PROFIL_ACC_TYPE,sox.PURCHASE_STEP,sox.RULE,sox.SUB,sox.SUB_TABLE, Step 2: Create a…
Read MoreIn the process of upgrading EBS R12 DB from 11.2.0.3 to 11.2.0.4 using DBUA. The end of the upgrade, DBUA fails with following error message. During the DBUA, I have…
Read MoreFollowing query will be useful to findout Roles and Privileges assigned to a user. Here, used SCOTT as User: COL “USER,HIS ROLES AND PRIVILEGES” FORMAT a100 set linesize 300 pages…
Read More