Query DBA_HIST_WR_CONTROL to see the interval, retention and the TOPNSQL setting. For TOPNSQL a setting of DEFAULT translates to: 30 where statistics_level is typical 100 where statistics_level is all Simply because this one SQL appears to consume 7% of the load it may not be in the top SQLs in these categories: Elapsed Time CPU…
/********************************************Author: Paresh MehtaScript Name : find_planinfo.sql********************************************/set lines 200set pages 500set echo offcol execs for 999,999,999col avg_etime for 999,999.999col avg_lio for 999,999,999.9col begin_interval_time for a30col node for 99999col plan_hash_value format 99999999999999col sql_profile format a30col intrvl format a29col component format a20alter session set nls_date_format=’DD-MON-RRRR:HH24:MI:SS’;–break on plan_hash_value,sql_profile on startup_time skip 1accept v_sql_id prompt ‘Enter SQL_ID ->’select s.instance_number, to_char(begin_interval_time,’DD-MON:HH24:MI’)…
/********************************************Author: Paresh MehtaScript Name : waitt.sqlwaits order by sql start time********************************************/set feedback 1set pages 2000set lines 190column event format a45column machin format a12column modul format a10column prg format a10column osuser1 format a10column username format a10column sesinfo format a15column blockedby format a15alter session set nls_date_format=’DDMONRR:HH24:MI:SS’;select /*+ first_rows(100) */ a.sid || ‘,’ || a.serial# || ‘,@’ ||…
less /proc/cpuinfo
To get cpu speed, use psrinfo -v psrinfo -v Status of virtual processor 0 as of: 12/10/2010 11:33:07 on-line since 08/01/2010 15:55:44. The sparcv9 processor operates at 1800 MHz, and has a sparcv9 floating point processor. Status of virtual processor 1 as of: 12/10/2010 11:33:07 on-line since 08/01/2010 15:55:50. The sparcv9 processor operates at 1800…
#!/bin/ksh -x # First, we must set the environment . . . . ORACLE_SID=fdprod export ORACLE_SID ORACLE_HOME=/orastdbybin/fdprod/product/10.2 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH SERVER_NAME=`hostname` typeset -u SERVER_NAME export SERVER_NAME # sample every two minutes (120 seconds) . . . . SAMPLE_TIME=30 while true do vmstat ${SAMPLE_TIME} 2 > /tmp/msg$$ cat /tmp/msg$$|sed 1,7d | awk ‘{ printf(“%s…
According to the query output from V$RESOURCE_LIMIT, the PROCESSES parameter limit is not yet reached. RESOURCE_NAME processes CURRENT_UTILIZATION 102 MAX_UTILIZATION 559 INITIAL_ALLOCATION 2000 LIMIT_VALUE 2000 The maximum value it ever reached was 559, while the limit is set to 2000.
Ref ID: How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1] Issue: We had network outage and there were some distributed transactions with dblinks hangs. Causing issue when trying to update some rows of the base table. Problem Discription: ==================== As a result of a failed commit of a distributed transaction, some entries canbe left in…
Read More “How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)” »
cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’
fuser -cu /directory_name
