SHMMAX = The maximum size(in bytes) of a single shared memory segment. SHMMIN = The minimum size(in bytes) of a single shared memory segment. The above settings let the max be bigger then we wil ever use and the min much smaller. They are sufficient for pretty much all systems. SHMMNI = The number of…
Read More “Kernel Parameter setting explaination for Processes Parameter” »
column name format a10 column position format 99 column datatype_string format a20 column value_string format a50 set lines 120 pages 200 select sql_id, name, position, datatype_string, value_string from v$sql_bind_capture where sql_id = ‘&sql_id’ /
SQL> select distinct sid from v$mystat; SID ———- 1365
. $ENV_FILE echo “Started test.ksh `date +%D-%T`” V1=1; V3=One; $ORACLE_HOME/bin/sqlplus pvm/pvm
#!/usr/bin/ksh ########## Configuration ############# ENV_FILE=$1
#!/bin/ksh -x # First, we must set the environment . . . . ORACLE_SID=WEBP18F export ORACLE_SID ORACLE_HOME=`cat /var/opt/oracle/oratab|grep ^$ORACLE_SID:|cut -f2 -d’:’` export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH SERVER_NAME=`uname -a|awk ‘{print $2}’` typeset -u SERVER_NAME export SERVER_NAME # sample every five minutes (300 seconds) . . . . SAMPLE_TIME=30 while true do vmstat ${SAMPLE_TIME} 2 > /tmp/msg$$…
To search and replace between line1 and line2 use following: (*) This is vi editor command: following command will serach and replace whole file. (this is default with %s). :line1,$ s/old_string/new_string/g following command will search and replace only in specific lines: :line1,line2 s/old_string/new_string/g for example, :3,5 s/CIF/UOC/g above command will replace CIF with UOC in…
Subject: Extent and Block Space Calculation and Usage in V7-V9 Database Doc ID :10640.1
Driver table: Take the driver table which returns the less number of rows for predicate with literal valae. For example, Consider the statement below: SELECT SUM(BIP.VALUE) value FROM BSKT_ITEM_CALC_PRICING BIP,BSKT_PRICING_ELEMENT BP WHERE BIP.BASKET_ITEM_ID IN (:”SYS_B_0″) AND BIP.PRICING_ELEMENT_ID = BP.PRICING_ELEMENT_ID AND BP.PRICING_TYPE_CODE = :1; Here SQL> select BASKET_ITEM_ID, count(1) from BSKT_ITEM_CALC_PRICING group by BASKET_ITEM_ID; BASKET_ITEM_ID COUNT(1)…
set lines 132 set pages 1400 SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position) “Query Plan” FROM v$sql_plan START WITH id = 0 and sql_id=’4ftvbpzhwkfd8′ and child_number=0 CONNECT BY PRIOR id = parent_id and sql_id=’4ftvbpzhwkfd8′ and child_number=0;
