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
Thursday, April 29, 2010
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
Subscribe to:
Posts (Atom)