Monday, March 21, 2011

kids pic

From: גונן [mailto:aaron_g@bezeqint.net]
Sent: Sunday, March 20, 2011 4:27 PM
To: Amihay Gonen
Subject:

Posted via email from agonen's posterous

Sunday, February 13, 2011

Cool clip

Download now or watch on posterous
Remember_Me.wmv (2407 KB)

From: Alona G (Home) [mailto:alona.gaidi@gmail.com]
Sent: Friday, February 11, 2011 10:06 PM
To: Alona G (Home)
Subject: FW: זוכרת אותי

Posted via email from agonen's posterous

Sunday, May 2, 2010

Sql for query in toad 'redo blocks written'

                Select sn.snap_id, sn.BEGIN_INTERVAL_TIME, sum(lc2.value - lc1.value) "redo blocks written"

From   SYS.DBA_HIST_SYSSTAT lc1,

       SYS.DBA_HIST_SYSSTAT lc2,

       SYS.DBA_HIST_snapshot sn

where  lc1.snap_id = (select max(s.snap_id)

                      from    SYS.DBA_HIST_snapshot s

                      where   s.snap_id < sn.snap_id

                      and     s.instance_number = sn.instance_number

                      and     s.dbid = sn.dbid

                      and     s.startup_time = sn.startup_time)

and    lc2.stat_name='redo blocks written'

and    lc1.stat_name='redo blocks written'                     

and    lc2.snap_id = sn.snap_id

and    lc1.dbid = sn.dbid

and    lc1.instance_number = sn.instance_number

and    lc2.dbid = sn.dbid

and    lc2.instance_number = sn.instance_number

and    sn.snap_id in (&Snapshotlist)

group by sn.snap_id, sn.BEGIN_INTERVAL_TIME

order by sn.snap_id

Posted via email from agonen's posterous

Thursday, April 29, 2010

jvm native leaks in solaris

                interesting article...see chapter 3.4

http://java.sun.com/javase/6/webnotes/trouble/TSG-VM/html/memleaks.html

 

1.gcore <pid>

2.mdb core.pid

            ::findleaks

Use lubumem.so.1 .see link

Posted via email from agonen's posterous