Author: Admin

Wait.sql

04-Apr-202322-Apr-2025 Admin No Comments

/********************************************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# || ‘,@’ ||…

CPU speed on Linux

10-Dec-2010 Admin No Comments

less /proc/cpuinfo

Linux/Unix, shell

CPU speed on solaris

10-Dec-2010 Admin No Comments

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…

get_aix_vmstat.ksh

18-Nov-2010 Admin No Comments

#!/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…

Processes Parameter decision

17-Nov-2010 Admin No Comments

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.

Oracle, SQL scripts

How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

11-Nov-2010 Admin No Comments

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…

Oracle, SQL scripts

grep multuple patterns

27-Oct-2010 Admin No Comments

cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’

Linux/Unix, shell

fuser to check who is using diretory

22-Oct-2010 Admin No Comments

fuser -cu /directory_name

Linux/Unix, shell

Unix command for system configuration

21-Oct-2010 Admin No Comments

Seeing kernel version (32/64 Bit) on Unix flavors. -isainfo -kv on Solaris -lsconf on AIX -uname -a on Linux to See configuration -prtdiag on Solaris -lsconf on AIX -dmidecode on Linux Other useful Unix commands: Disk usage. # df -al Memory information. # free Network information. # ifconfig -a Installed Modules information. #lsmod Currently mounted…

Linux/Unix, shell

Oracle Recommended Patches — Oracle Database ID 756671.1

20-Oct-2010 Admin No Comments

Oracle Recommended Patches — Oracle Database Target Configurations Patch Availability Current Recommended Patches 11.2.0.2 Current Recommended Patches 11.2.0.1 Current Recommended Patches 11.1.0.7 Current Recommended Patches 11.1.0.6 Current Recommended Patches 10.2.0.5 Current Recommended Patches 10.2.0.4 Current Recommended Patches 10.2.0.3 Current Recommended Patches Conflict Resolution On Request Known Issues References Beginning with release 10.2.0.3, Oracle releases Recommended…

Oracle, SQL scripts