Session_info.ksh

Posted on By Admin No Comments on Session_info.ksh

/********* session_info.ksh ****************/ #!/bin/ksh . /home/oracle/oraprocs/WEBP18F.env USR_ID=vivek USR_PASS=viv1ek database=WEBP18F a=`ps -ef|grep “session_info.ksh”|grep -v grep|wc -l` if [ $a -gt 4 ] then echo “Exiting because of more than 1 process is running `date`”>>/db3/oradata/log/session_info.log exit fi echo “—–Begin —– Date `date`——————————–” >> /db3/oradata/log/session_info.log $ORACLE_HOME/bin/sqlplus -s /db3/oradata/log/session_info.log $USR_ID/$USR_PASS@$database set serverout on set feedback off SET PAGES 0…

Read More “Session_info.ksh” »

Linux/Unix, shell

Facts about SCN and Rollback Segment

Posted on By Admin No Comments on Facts about SCN and Rollback Segment

1. When should you create more rollback segments? The number of rollback segments needed to prevent contention between processes can be determined with the help of the monitor rollback display and with the use of the v$waitstat table. The rollback monitor column “header waits/sec” gives an indication of the current rollback segment contention. Waits are…

Read More “Facts about SCN and Rollback Segment” »

Oracle, SQL scripts

logminer and my_lbu

Posted on By Admin No Comments on logminer and my_lbu

dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83113.arc’, options => dbms_logmnr.new); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83114.arc’, options => dbms_logmnr.addfile); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83115.arc’, options => dbms_logmnr.addfile); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83116.arc’, options => dbms_logmnr.addfile); execute DBMS_LOGMNR.START_LOGMNR(options => dbms_logmnr.dict_from_online_catalog); Then rename v$logmnr_contents to logminer_bak. Then run my_lbu.sql

Oracle, SQL scripts

How to Use DBMS_STATS to Move Statistics to a Different Database

Posted on By Admin No Comments on How to Use DBMS_STATS to Move Statistics to a Different Database

Subject: How to Use DBMS_STATS to Move Statistics to a Different Database Doc ID: Note:117203.1 Type: FAQ Last Revision Date: 01-MAR-2007 Status: PUBLISHED To provide Oracle Support Services with statistics for debugging, please refer to the following article: Note 242489.1 Transferring Optimizer Statistics to Support Purpose: ======== The purpose of this article is to explain…

Read More “How to Use DBMS_STATS to Move Statistics to a Different Database” »

Oracle, SQL scripts

export import with parameter file.

Posted on By Admin No Comments on export import with parameter file.

Export with parameter file and import with same. =============================================== Task : I am exporting some tables from CS and importing thsoe tables into BASKET schema. /**************************************************** FILE NAME: exp_wo_data.par *******************/ userid=cs file=exp_bskt_15MAR07.dmp compress=N grants=N log=bskt_exp_15MAR07.log ROWS=N triggers=N statistics=NONE tables=(BSKT_AGENT_BASKET_CALL_DETAIL , BSKT_AGENT_ORDER_NOTE , BSKT_BASKET_ITEM_TYPE , BSKT_DISCOUNT_APPLY_TYPE , BSKT_DISCOUNT_REASON , BSKT_ITEM_CALC_PRICING , BSKT_ITEM_PRICING_XREF , BSKT_ITEM_SUB_PRODUCT , BSKT_PAYMENT_DETAIL…

Read More “export import with parameter file.” »

Oracle, SQL scripts

chk_space_SID.ksh

Posted on By Admin No Comments on chk_space_SID.ksh

#Description : This script will check whether free space is there for next extent allocation or not. #It checks TS level and OS level for extent allocation. Checks for UNIFORM allocated extents. #For system allocated extents. this script will check 1 GB should be there as free threshold. NODENAME1=`hostname` ORACLE_SID=WEBP18F LOG_FILE_DIR=/home/oracle/oraprocs/logs ENV_FILE=/home/oracle/oraprocs/WEBP18F.env #NOTIFY_LIST=’8774544468@skytel.com’,’8774537913@skytel.com’,’8666714349@skytel.com’,’8774538204@skytel.com’,’dbaoracle@1800flowers.com’,’8774889576@skytel.com’ NOTIFY_LIST=’pmehta@1800flowers.com’ ADMIN_USER=vivek…

Read More “chk_space_SID.ksh” »

Linux/Unix, shell

Another Tuning Article for subheap of shared pool

Posted on By Admin No Comments on Another Tuning Article for subheap of shared pool

http://www.mail-archive.com/oracle-l@fatcity.com/msg79721.html Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up into “heaps” (Oracle terminology) but whatever fancy stuff they were trying to accomplish by doing this (I think part of the magical self-tuning initiative) was buggy and this hastened the fatal 4031 situation. There is a parameter (so I…

Read More “Another Tuning Article for subheap of shared pool” »

Oracle, SQL scripts