pvmehta.com

Finding Oracle Patches with opatch

05-Jan-2007 Admin No Comments

dbaltxprod50->WEBP18F@(/home/oracle)/oracle/app/oracle/product/10.2/OPatch/opatch lsinventory Invoking OPatch 10.2.0.2.0 Oracle interim Patch Installer version 10.2.0.2.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /oracle/app/oracle/product/10.2 Central Inventory : /var/opt/oracle/oraInventory from : /oracle/app/oracle/product/10.2/oraInst.loc OPatch version : 10.2.0.2.0 OUI version : 10.2.0.2.0 OUI location : /oracle/app/oracle/product/10.2/oui Log file location : /oracle/app/oracle/product/10.2/cfgtoollogs/opatch/opatch-2006_Aug_28_17-52-47-E DT_Mon.log Lsinventory Output file location : /oracle/app/oracle/product/10.2/cfgtoollogs/opatch/lsinv/lsinventory-2006_Aug_28 _17-52-47-EDT_Mon.txt…

Oracle, SQL scripts

Sort with ASCII order and Numeric Order

03-Jan-2007 Admin No Comments

By default sort command will sort by ASCII order. To sort it on basis of NUMERIC sort, you need to specify “-n” switch. du -sk * | sort -n

Linux/Unix, shell

Order by with ROWNUM

03-Jan-2007 Admin No Comments

18:02:01 PVM@AWRTEST:-> select * from pvm1; NO ——— 100 20 40 1 2 200 24 7 rows selected. Elapsed: 00:00:00.01 18:02:17 PVM@AWRTEST:-> select no from ( select no, row_number() over (order by no desc) r from pvm1) where r=2; NO ——— 100 1 row selected. Elapsed: 00:00:00.02 18:02:38 PVM@AWRTEST:-> select no from ( select no,…

xargs use

29-Nov-2006 Admin No Comments

Remove all files that are generated in OCT ls -rlt | grep -i “oct” | awk ‘{print $9}’ | xargs rm Remove files that has number 3200 to 3699. ls -rlt arch1_573748961_3[2-6][0-9][0-9]* | awk ‘{print $9}’ | xargs rm

Linux/Unix, shell

oradebug ipcrm ipcs

21-Nov-2006 Admin No Comments

In this article I will describe the steps used to identify which shared memory and semaphore segments are owned by a particular instance in Oracle V7, V8.0, V8i, and V9i. This can be helpful in recovery situations where the database instance has not released its shared memory and semaphores on database shutdown. Consider the situation…

How to sort list of files on basis of their sizes.

09-Nov-2006 Admin No Comments

tuningdb21->AWRTEST@(/db1/home/oracle)ls -rlt | sort +4 total 48 drwx—— 2 oracle dba 96 May 17 16:16 nsmail drwxrwxr-x 3 oracle dba 96 Oct 3 2005 app drwxr-xr-x 3 oracle dba 96 Oct 4 2005 patch drwxr-xr-x 2 oracle dba 96 Oct 16 15:17 scripts -rw-r–r– 1 oracle dba 124 Oct 3 2005 local.cshrc -rw-r–r– 1 oracle…

Linux/Unix, shell

Locktree.sql

06-Nov-2006 Admin No Comments

Locktree.sql is renamed with $ORACLE_HOME/rdbms/admin/utllockt.sql This will show the lock hierarchy in Oracle.

Oracle, SQL scripts

This is im telling Kishore

26-Oct-2006 Admin No Comments

Test data

Oracle, SQL scripts

Some OS level threshold for performance.

25-Oct-2006 Admin No Comments

Some OS level threshold for performance. Run queue > 8 : May indicate an overloaded CPU. Page_in and Page_out > 50 : May indicate overloaded RAM memory. This should be correlated with page-outs and scan rate. user+system CPU > 70% : Indicates periods with a fully-loaded CPU subssystem.Periods of 100% utilization are only a concern…

Linux/Unix, shell

find_du.ksh to find # of files, their sizes in current folder and its subdolder

10-Oct-2006 Admin No Comments

#!/usr/bin/ksh for dirname in `find . -type “d”` do #print “dirname is $dirname”; tot_files=`ls -rlt $dirname| grep -i “^-” | wc -l` tot_file_size=`ls -rlt $dirname| grep -i “^-” | awk ‘{tot+=$5} END {print tot/1024/1024}’` echo “Folder : $dirname, Total Files : $tot_files, Total File Sizes : $tot_file_size MB” done

Linux/Unix, shell