tomas.papp.me.u'know

  echo “- – -” > /sys/class/scsi_host/host0/scan

Wait details: select distinct ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,ses.ksuseunm machine, ob.kglnaown obj_owner, ob.kglnaobj obj_name ,pn.kglpncnt pin_cnt, pn.kglpnmod pin_mode, pn.kglpnreq pin_req , w.state, w.event, w.wait_Time, w.seconds_in_Wait — lk.kglnaobj, lk.user_name, lk.kgllksnm, –,lk.kgllkhdl,lk.kglhdpar –,trim(lk.kgllkcnt) lock_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req, –,lk.kgllkpns, lk.kgllkpnc,pn.kglpnhdl from x$kglpn pn, x$kglob ob,x$ksuse ses , v$session_wait w where pn.kglpnhdl in (select kglpnhdl from x$kglpn […]

tr -cd ‘\11\12\40-\176’ < $INPUT_FILE > $OUTPUT_FILE cize tr bude ignorovat vsetky znaky ktore niesu v rozsahu ASCII ktory sme zadefinovali.. tento skript pride velmi handy pri kopirovani z e-mailov ci “inteligentnych” textovych editorov do UNIX shell konzoly..

Primarna strana: 1;) zhodit vsetky RAC instancie na PRI a DR strane okrem jednej 2;) alter database commit to switchover to physical standby with session shutdown; 3;) shutdown immediate; 4;) startup nomount; 5;) alter database mount standby database; 6;) alter database recover managed standby database disconnect; DR strana 7:) alter database recover managed standby database cancel; 8:) ak pouzivame delayed […]

ABMR – auto block media recovery background process – Filters duplicate BMR requests and performs flood control. When a request of block media recovery comes to ABMR, then ABMR spawns BMRn slave processes to perform block media recovery dynamically. repairing of corrupted blocks on primary site by obtaining the same block from standby site and […]

Ak by ste nahodou dostavali hlasku ORA-01102: cannot mount database in EXCLUSIVE mode napriek tomu, ze instancia je vypnuta je mozne, ze nieco drzi jej zdielanu pamet, ci uz instancia po pade zabudla po sebe odpratat alebo sa pokusate bezat dve rozne instancie s tym istym DB_NAME treba sa pozriet na toto a;) alertlog;) ten […]

Je na to trik rman target/ rman> sql ‘alter database datafile 7 offline drop’; sql ‘alter database rman> datafile 8 offline drop’; sql ‘alter database open’; remn> exit

Mozno sa vam obcas pritrafi, ze potrebujete z nejakeho dovodu presunut velke mnozstvo tabuliek z jedneho tbs do ineho. V pripade ze tabulka nema index je to jednoducha vec, ale ked index ma problemy sa zacinaju. Tento skript sa o vsetko postara.. //move all non-indexed// select ‘alter table ‘||t.owner||’.’||t.table_name|| ‘move tablespace table_small;’   from dba_tables […]

Je na to pekny trik:) SQL> select address, hash_value from v$sqlarea where sql_text = ‘select * from dept’; ADDRESS HASH_VALUE ——– ———- 2671F27C 3599690174 SQL> exec dbms_shared_pool.purge(‘2671F27C,3599690174′,’C’); PL/SQL procedure successfully completed. SQL> select address, hash_value from v$sqlarea where sql_text = ‘select * from dept’; no rows selected pozn: funguje od 11.1 vyssie, na 10.2.x.y je […]

Total used SELECT   A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total – SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free FROM     v$sort_segment A, ( SELECT   B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_total FROM     v$tablespace B, v$tempfile C WHERE    B.ts#= C.ts# GROUP BY B.name, C.block_size ) D WHERE    […]