Filename : fphv.sql REM *** Find Plan Hash value column plan_hash_value format 999999999999 accept v_sqlid prompt ‘Enter SQL_ID : ‘ select distinct sql_id, plan_hash_value, to_char(timestamp, ‘DD-MON-RRRR:HH24:MI:SS’) from dba_hist_sql_plan where sql_id=’&v_sqlid’;
set lines 120 pages 200 select status, count(1) from v$shared_server group by status; select * from v$shared_server_monitor; select dispatcher, count(1) from v$circuit group by dispatcher; select * from v$sgastat where name like ‘%free memory%’;
column osuser format a10 column username format a30 column machine format a30 column program format a40 column sid format 99999999 column serial# format 99999999 column TOT format 999999 heading “Total Sessions” break on report compute sum of TOT on report set lines 141 set pages 500 select machine, osuser, username, count(1) “TOT” from v$session group…
set lines 120 pages 200 column event format a30 column object_type format a14 column object_name format a30 column owner format a10 column sql_text format a120 accept event_name prompt ‘Enter fraction of event to trace : ‘ select distinct a.event, s.sql_id, s.sql_text, s.executions from v$session a, v$sqlarea s where s.sql_id = a.sql_id and lower(a.event) like lower(‘%&event_name%’)…
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…
Read More “Vivek’s egrep commands to trace problem. (on linux x86-64)” »
######### # _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…
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…
http://www.dbspecialists.com/presentations/oracle10glinux.html
The following commands can be used to identify the processor architecture on your database server: $ uname -m $ grep “model name” /proc/cpuinfo
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…
