a dba life: 2010

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

Tuesday, April 27, 2010

Unix/Oracle schudle tasks report

Oracle schedule tasks :

owner	job_name	schdule	last_run_duration	last_start_date
SYS	FGR$AUTOPURGE_JOB	freq=daily;byhour=0;byminute=0;bysecond=0
SYSTEM	DAILY_EXPORT	FREQ=YEARLY;INTERVAL=3
NG	JOBMOVEALARMS2HISTORY	FREQ=SECONDLY;INTERVAL=3	+00 00:00:00.040996	27/04/2010 12:54:34.106007 +03:00
OPS3	MOVECLOSEDALARMSTOHISTORY	FREQ=SECONDLY;INTERVAL=30	+00 00:00:00.044452	27/04/2010 12:54:30.108538 +03:00
NG	JOBCHECKTOPOLOGY	FREQ=SECONDLY;INTERVAL=60	+00 00:00:00.040272	27/04/2010 12:54:25.174559 +03:00
OPS3	JOB_SPINSERTCLOSEDALARMS	FREQ=SECONDLY;INTERVAL=70	+00 00:00:00.041415	27/04/2010 12:53:40.109356 +03:00
OPS3	JOB_DELETEOLDRECORDS	FREQ=SECONDLY;INTERVAL=110	+00 00:00:00.043696	27/04/2010 12:53:20.165314 +03:00
OPS3	JOB_DELETEOLDTASKS	FREQ=SECONDLY;INTERVAL=110	+00 00:00:00.042024	27/04/2010 12:53:20.103841 +03:00
EXFSYS	RLM$EVTCLEANUP	FREQ = HOURLY; INTERVAL = 1	+00 00:00:00.041805	27/04/2010 02:39:46.110092 -07:00
EXFSYS	RLM$SCHDNEGACTION	FREQ=MINUTELY;INTERVAL=60	+00 00:00:00.072486	27/04/2010 12:24:30.106135 +03:00
OPS3	SWITCHALARMHISTORY	FREQ=HOURLY	+00 00:00:00.054332	27/04/2010 12:00:00.190979 +03:00
NG	CLEANUP_JOB	FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0	+00 00:00:02.952196	27/04/2010 01:00:00.175784 +03:00
ECI_ADMIN	DB_MAINTAINCE	FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0	+00 00:00:03.368310	27/04/2010 01:00:00.122527 +03:00
SYS	GATHER_STATS_JOB		+00 00:06:22.460691	26/04/2010 22:00:02.732556 +03:00
SYS	AUTO_SPACE_ADVISOR_JOB		+00 00:00:17.485245	26/04/2010 22:00:02.730916 +03:00
ORACLE_OCM	MGMT_CONFIG_JOB		+00 00:00:00.211014	26/04/2010 22:00:02.726446 +03:00
SYS	PURGE_LOG	freq=daily;byhour=3;byminute=0;bysecond=0	+00 00:00:14.662377	26/04/2010 03:00:00.167015 -07:00
NG	ALARM_PROP			22/04/2010 13:08:55.891537 +03:00
ORACLE_OCM	MGMT_STATS_CONFIG_JOB	freq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=01	+00 00:00:00.087157	01/04/2010 01:01:01.820472 -07:00
ECI_ADMIN	JOB_TEMPLATE	FREQ=DAILY; INTERVAL=60	+00 00:00:00.054227	06/01/2010 11:21:59.543579 +02:00

Query :

select owner,job_name,nvl(REPEAT_INTERVAL,

(select repeat_interval

from dba_scheduler_schedules where owner=a.owner and SCHEDULE_NAME=a.SCHEDULE_NAME)

) schdule,last_run_duration,LAST_START_DATE from dba_scheduler_jobs a

order by last_start_date desc

Unix schedule tasks (cron only ) Format :

* * * * * command to be executed

- - - - -

| | | | |

| | | | +----- day of week (0 - 6) (Sunday=0)

| | | +------- month (1 - 12)

| | +--------- day of month (1 - 31)

| +----------- hour (0 - 23)

+------------- min (0 - 59)

Global zone :

::::::::::::::

crontabs/adm

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

11 * * * * MonitorZFS 3600

::::::::::::::

crontabs/sys

::::::::::::::

Oracle Zone:

::::::::::::::

crontabs/adm

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/oracle10

::::::::::::::

10 0 * * * /opt/oraServer/sh/OraHouseKeeping

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

Zone 2 (Axl)

::::::::::::::

crontabs/adm

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

crontabs/sys

::::::::::::::

Zone 3 (OPS)

::::::::::::::

crontabs/adm

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

crontabs/sys

::::::::::::::

Command :

more /var/adm/cron/crontabs/* | grep -v # > /tmp/list

Posted via email from agonen's posterous

Tuesday, January 19, 2010

always fill the resource usage- actual work.png

The message is ready to be sent with the following file or link attachments:

resource usage- actual work.png

Note: To protect against computer viruses, e-mail programs may prevent
sending or receiving certain types of file attachments. Check your e-mail
security settings to determine how attachments are handled.

Posted via email from agonen's posterous

Thursday, January 14, 2010

ג'ינג'ר לט"ו בשבט

Charles de Gaulle - "The better I get to know men, the more I find myself loving dogs."

---------- Forwarded message ----------
From: efrat gonen <efratgonen@gmail.com>
Date: 2010/1/14
Subject: ג'ינג'ר לט"ו בשבט
To:

שלום לכולם.

לאחר סיבוב הופעות וסדנאות מוצלח בחנוכה סטודיו ג'ינג'ר חוזרות לשוק החופשי

ומזמינות אתכם

להזמין אותנו

לכבוד החג המתקרב... ט"ו בשבט!

ההצגה "מעשה בחושך" הינה שילוב של תיאטרון כביסה וצלליות העושה שימוש חוזר בבגדים וחפצים ובוראת עולם לילי חי ורוחש על הבמה.

בסוף ההצגה נלמד למחזר אריזות ישנות ולהכין מהן בובות צללית צבעוניות ולהפעיל אותן.

ההצגה מיועדת לגילאי 3-8 ו-20-120.

למי שכבר ראה את ההצגה אנו מציעות שלל סדנאות ליצירת בובות מסוגים שונים מחומרי מיחזור (בובות מריונטה מגרביים וגלילי נייר טואלט, בובות מוט משקיות ניילון ועיתונים, ועוד).

כולכם מוזמנים לבקר בגלריה שלנו ולראות תמונות מהופעות וסדנאות החנוכה:

www.flickr.com/photos/ginger-puppets

שלכם

אפרת וגילי

נ.ב. אם מי מכם לא מעוניין לקבל מאיתנו מיילים- תגידו ומייד נסיר אתכם מייד מרשימת התפוצה