Year: 2006

Vivek’s egrep commands to trace problem. (on linux x86-64)

13-Sep-2006 Admin No Comments

dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “INSERT” /tmp/v1aa|awk -F”trc” ‘{print $2}’|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk -F””trc ‘{print $2}’|sort |uniq -c|sort -nr dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk -F”:” ‘{print $2}’|sort |uniq -c|sort -nr dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Delete” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Update” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP) dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep…

Linux/Unix, shell

mutex in Oracle 10.2.0.2 or Oracle 10g

13-Sep-2006 Admin No Comments

######### # _kks_use_mutex_pin # # Enables use of more efficient mutex mechanism for # implementing library cache pins. # ######### _kks_use_mutex_pin=TRUE Apparently, Oracle is migrating some of its serialization protection from latches to mutexes. For example, the structures previously protected by the Library Cache Pin latch are now protected by a mutex and evidenced by…

Oracle, SQL scripts

tuning commmand for cpu, ip and memory stats

12-Sep-2006 Admin No Comments

SQL> !mpstat Linux 2.6.9-34.ELsmp (dbaltxprod51) 09/12/2006 05:45:41 PM CPU %user %nice %system %iowait %irq %soft %idle intr/s 05:45:41 PM all 1.34 0.00 4.17 0.47 0.02 0.11 93.89 1413.67 SQL> !vmstat procs ———–memory———- —swap– —–io—- –system– —-cpu—- r b swpd free buff cache si so bi bo in cs us sy id wa 7 0 86476…

Linux/Unix, shell

oracle 10g on linux

12-Sep-2006 Admin No Comments

http://www.dbspecialists.com/presentations/oracle10glinux.html

Linux/Unix, shell

Linux CPU info.

12-Sep-2006 Admin No Comments

The following commands can be used to identify the processor architecture on your database server: $ uname -m $ grep “model name” /proc/cpuinfo

Linux/Unix, shell

ipcs -l

12-Sep-2006 Admin No Comments

dbaltxprod51->WEBP18F@(/home/oracle/paresh)ipcs -l —— Shared Memory Limits ——– max number of segments = 4096 max seg size (kbytes) = 4002706 max total shared memory (kbytes) = 8388608 min seg size (bytes) = 1 —— Semaphore Limits ——– max number of arrays = 128 max semaphores per array = 250 max semaphores system wide = 32000 max…

Renaming Global Name GLOBAL_NAME

06-Sep-2006 Admin No Comments

Problem: ——– I cannot create a db_link on my database that does not have the fuly qualified domain.name. eg. if I create a db_link called fred as follows: create database link fred connect to ITU604SP4B identified by using ‘sup9206_hippo’ a link called fred.intec.co.za is created, I just want fred. I have set global_names= FALSE db_domain=””…

Oracle, SQL scripts

Kernel Parameter setting explaination for Processes Parameter

31-Aug-2006 Admin No Comments

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…

Linux/Unix, shell

sbind.sql Find Bind variable from sql_id sqlid

30-Aug-2006 Admin No Comments

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’ /

Oracle, SQL scripts

How to know current SID

30-Aug-2006 Admin No Comments

SQL> select distinct sid from v$mystat; SID ———- 1365

Oracle, SQL scripts