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…
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
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” »
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…
. $ENV_FILE #sqlplus -silent / as sysdba
#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…
#!/bin/ksh
To Find Orphan OS processes. When a process run from command line its parent process id will be 1. Consider following example: In current session, we are executing SQLPLUS. whose process id = 22833 and parent is 22822. process 22822 is ksh. So this is not orphan process. if you find any process with parent…
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” »
Note:396940.1 How many Subpools will I have by default? The number of subpools is calculated using a simple algorithm. First, a subpool must be at least 128MB in 9i releases and at least 256MB in 10g releases. Bugs and internal tests show that subpools around 500M will work most efficiently and in future versions, we…
