tomas.papp.me.u'know

To, ze nic nieje take bezpecne ako sa zda vam priblizi tento clanok o znamom vire Stuxnet ktory v roku 2010 spomalil Iransky jadrovy program..

viac v clanku sem

Tento clanok je pre tych ktory si myslia ze hardcore sifrovanie disku im zabezpeci nedotknutelne sukromie a ochrani ich data pred ocami autorit hociakeho typu

http://www.hermann-uwe.de/blog/physical-memory-attacks-via-firewire-dma-part-1-overview-and-mitigation

Plus netreba zabudat ze este stale existuje cold boot attack. Jedinym riesenim je neuchovavat citlive udaje v pameti ( vid tresor ) Alebo sa postarat o automaticke zmazanie RAM pri zisteni neopravneneho vniknutia do skrinky ( enclosure bay open ACPI event  dnes uz vedia reportovat hadam vsetky skrinky//biosy )

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 locknuta kontextom 5614566 ( 5614566 trace name context forever )
ci zabralo alebo nie je dobre checknut vo v$sql v stlpci invalidations.

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    A.tablespace_name = D.name
GROUP by A.tablespace_name, D.mb_total;

By session

SELECT   S.sid || ',' || S.serial# sid_serial, S.username,
 S.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used,
 COUNT(*) sort_ops
FROM     v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P
WHERE    T.session_addr = S.saddr
AND      S.paddr = P.addr
AND      T.tablespace = TBS.tablespace_name
GROUP BY S.sid, S.serial#, S.username, S.osuser, P.spid, S.module,
 S.program, TBS.block_size, T.tablespace
ORDER BY sid_serial;

By SQL

SELECT   S.sid || ',' || S.serial# sid_serial, S.username,
 T.blocks * TBS.block_size / 1024 / 1024 mb_used, T.tablespace,
 T.sqladdr address, Q.hash_value, Q.sql_text
FROM     v$sort_usage T, v$session S, v$sqlarea Q, dba_tablespaces TBS
WHERE    T.session_addr = S.saddr
AND      T.sqladdr = Q.address (+)
AND      T.tablespace = TBS.tablespace_name
ORDER BY mb_used;

http://www.avaaz.org/en/eu_herbal_medicine_ban/?copy

Velmi pekny tutorial a how-to ako na manualnu fotografiu: http://www.fotoreporter.cz/report/239-jak-vyvolat-film-nazvetsovat-fotografie.html , vsetko co potrebujete vediet od A po Z na jednom mieste pokope

tento skript sa mi osvedcil ako celkom handy tak som ho trochu upravil aby zobrazoval vsetky podstatne informacie ktore v danej chvili treba vediet

col object_name format a20
column sess format A20
col schemaname format a15

SELECT substr(DECODE(request,0,'Holder: ','Waiter: ')||l.sid,1,12) sess,s.schemaname,
l.id1,o.object_name, l.id2, l.lmode, l.request, l.type, l.inst_id,w.seconds_in_wait
FROM GV$LOCK l
left join gv$session s on s.sid=l.sid and l.inst_id=s.inst_id
left join dba_objects o on l.id1=o.object_id
left join v$session_wait w on s.sid=w.sid
WHERE (l.id1, l.id2, l.type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0)
ORDER BY sess,id1; 

Tisic a jedna receptov na ten spravny obraz. Kto rad foti na film a vyvolava si svoje foto doma a chcel by dosiahnut isty typ vysledku tato stranka mu poradi aky film, chemiu a aky vyvolavaci postup zvolit..

enjoy;)

Ci uz ste fanusikom db liniek alebo nie..faktom je..ze…veci sa kazia;) A nikdy nieje na skodu vediet presne identifikovat master session a ku nej prisluchajucu  db link slave session..Ocenite to hlavne vo viacnodovom RAC prostredi

Select /*+ ORDERED */
substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)      "ORIGIN",
substr(g.K2GTITID_ORA,1,35) "GTXID",
substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) "LSESSION" ,
s2.username,
substr(
decode(bitand(ksuseidl,11),
1,'ACTIVE',
0, decode( bitand(ksuseflg,4096) , 0,'INACTIVE','CACHED'),
2,'SNIPED',
3,'SNIPED',
'KILLED'
),1,1
) "S",
substr(w.event,1,10) "WAITING"
from  x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w, v$session s2
where  g.K2GTDXCB =t.ktcxbxba
and   g.K2GTDSES=t.ktcxbses
and  s.addr=g.K2GTDSES
and  w.sid=s.indx
and s2.sid = w.sid;

Tieto sa zidu poruke;)

v$asm_alias – Zobrazi aliasy v mountnutych DG
v$asm_client – Vsetky databazy aktualne pripojene do ASM
v$asm_disk – Vsetky disky ktore ASM instancia vidi
v$asm_diskgroup – Diskgrupy a DG info v ASM instancii
v$asm_file – Zobrazi subory v ASM
v$asm_operation – Aktualne beziace operacie v ASM, napriklad rebalancing
v$asm_template – ASM templaty
v$asm_diskgroup_stat – ako v$asm_diskgroup, ale zobrazuje viac info
v$asm_disk_stat – ako v$asm_disk ale zobrazuje viac info

Pevne pohlady
x$kfals – ASM aliasy
x$kfdsk – ASM disky
x$kffil – ASM subory
x$kfgrp – ASM diskgrupy
x$kfgmg – ASM operacie
x$kfkid – ASM disk performance
x$kfncl – ASM clienti
x$kffxp – ASM extenty, zauimave info ako su jednotlive disky vybalancovane
x$kfdat – ASM extenty v diskgrupe relativne ku extentom v suboroch