Sunday, April 10, 2011
Monday, March 21, 2011
kids pic
From: גונן [mailto:aaron_g@bezeqint.net]
Sent: Sunday, March 20, 2011 4:27 PM
To: Amihay Gonen
Subject:
Sunday, February 13, 2011
Cool clip
From: Alona G (Home) [mailto:alona.gaidi@gmail.com]
Sent: Friday, February 11, 2011 10:06 PM
To: Alona G (Home)
Subject: FW: זוכרת אותי
Thursday, February 10, 2011
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
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
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
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.pngNote: 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.
Thursday, January 14, 2010
ג'ינג'ר לט"ו בשבט
From: efrat gonen <efratgonen@gmail.com>
Date: 2010/1/14
Subject: ג'ינג'ר לט"ו בשבט
To:
Wednesday, January 13, 2010
צלצולי טלפון בשלוש שפות
From: Alona Gaidi [mailto:Alona.Gaidi@timetoknow.org]
Sent: Wednesday, January 13, 2010 11:52 AM
Subject: FW: צלצולי טלפון בשלוש שפות
DBA TOOLS
From: Moti Maimon
Sent: Wednesday, January 13, 2010 11:09 AM
To: Ami Bukris; Amihay Gonen
Subject: DBA TOOLS
Regards,
Moti.
Wednesday, April 30, 2008
manage the cluster
- login as root
- run:
$ORA_CRS_HOME/bin/crsctl start crs
you should get :
Attempting to start CRS stack
The CRS stack will be started shortl
check logs at : $ORA_CRS_HOME/log/`hostname`/crsd
and : $ORA_CRS_HOME/log/`hostname`/cssd
on all nodes .
Tuesday, April 8, 2008
How the oracle clusterware behave
- Oracle clusterware is calling all the scripts on $CRS_HOME/racg/usrco on the node where the actions take place. and only on this node.
Thursday, April 3, 2008
RAC - Troubleshooting
The clusterware is an oracle software which manage oracle and user defined resources.
There a lot of places which can get wrong. This post intend to provide the initial steps for troubleshooting RAC.
Ok ... you did srvctl
2. go the machine which has reported on the error (incase you don't sure . go to the machine you run the command on .
3. cd $ORA_CRS_HOME/log/`hostname`/crsd
4. check crsd.log for errors.
When thing is important to remember :
when something in wrong , first check on the node level .
For example - If cluster can not start database - check alertlog, try to start database without RAC .
Tuesday, March 4, 2008
How to add new Iscsi disk
- Define the disk in the storage gui
- Login as root to the system
- Enable Iscsi:iscsiadm modify discovery -s enable
iscsiadm list discovery-address -v - Define Iscsi:
svcs -a | grep -i iscsi
you should get : disabled Jan_22 svc:/network/iscsi_initiator:default-
iscsiadm list initiator-node
you should get : Initiator node name: iqn.1986-03.com.sun:01:0003ba321f11.4523d4a8 - Rescan iscsi to find new disks
- devfsadm -C -i iscsi
this command scan for new disks. please note -C is to cleanup old disks definitions , -i is for iscsi only - Use format to define new partitions
- format
you should get a list of disks like that -
AVAILABLE DISK SELECTIONS:
0. c0t0d0
/pci@1c,600000/scsi@2/sd@0,0
1. c0t1d0
/pci@1c,600000/scsi@2/sd@1,0
2. c2t1d0
/iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,0
3. c2t2d0
/iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,1
4. c2t4d0
/iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,2
5. c2t5d0
/iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,3
Specify disk (enter its number): - 3
choose one of the disks if you get Disk not labeled. Label it now? - put yes - FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
!- execute , then return
quit
partition (or p as shortcut)
print (or p as shortcut)
quit
quit (to exit format) - Create a new file system
- newfs /dev/rdsk/c2t2d0s6
you should get newfs: construct a new file system /dev/rdsk/c2t2d0s6: (y/n)?
press - y - mount /dev/dsk/c2t2d0s6 /oracle
make sure that /oracle directory is exists.