Database Blog

Steps to Reclaim Unused Space From Indexes and Tables

-- ############################################################################################# -- -- %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

Steps to Tune Redologs undo Checkpoints for Contention,Waits and Number/Duration of Checkpoints

-- ############################################################################################# -- -- %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 More

Weblogic Reports and forms services Start/Stop

Weblogic 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 More

Steps to start and stop a WebLogic domain and managed server

Steps 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 More

Steps to start and stop Node-manager in weblogic

Steps 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 More

To find the dependent packages or objects related to a package

To 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 More

Query to find current cache hit ratio in database

Query 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 More

Steps to Run Expdp Impdp Jobs in Background with nohup mode

How 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 More

ORA-1166 file number 101 is larger than MAXDATAFILES (100)

In 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 More

Find Roles and Privelages for USER

Following 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