Saturday, December 28, 2013

During my talk at UK OUG tech 2013 earlier this month; running "Oracle Database on LDOMS" I promised I would put some figures on what performance hit to expect when doing virtual IO in the guest domain.

So far I did following tests :


  • orion testing
  • SLOB testing
  • fio 

I am still busy to review the results.
I'll put the results there shortly


here is the link to the presentation :

Friday, December 27, 2013

replicate controlfile or restore controlfile

something i noticed today

I remember that once i used following in rman


 replicate controlfile from '/export/home/oracle/control_ACP1.cont';


I thought it would also update the spfile however that seemed not the case.

how ever what automatically updates the spfile is the following

RMAN> restore controlfile from '/export/home/oracle/control_ACP1.cont';

Starting restore at 27-DEC-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=110 instance=EUACP11 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATADG1/euacp1/controlfile/current.4907.835270147
output file name=+ARCHDG1/euacp1/controlfile/current.16585.835270147

Finished restore at 27-DEC-13



lots of audit files generated in ASM home dir on 12cR1

Last week I had an issue on a freshly installed dev system with 12c and Oracle Restart.
In about 3 months time there were 7,5 million audit files generated in the GI home.

This caused the zfs filesystem to fill up completely ( zfs doesn't like this ;-) we didn't finish monitoring yet on this system so we noticed it when damage was done ....



cleaning up the zfs filesystem was one thing, first we had to make some space otherwise we got ...

rm: cannot remove : No space left on device



First since is was a dev system and holidays anyways I stop ASM and the databases ...
After cleaning up some space we could to following ...


cd $GRID_HOME/rdbms/audit
find . > /tmp/rm_audit

remove the first line of that file ...


cat rm_audit | xargs -l 100 rm



and then slowly the space was given back...

now time to change the check interval to something more reasonable since it was checking each second .... and thus generating an audit file each second or 86400 each day

to view all the parameters 

crsctl stat res -p 

for example on the ASM instance following parameters are set.


NAME=ora.asm
TYPE=ora.asm.type
ACL=owner:grid:rwx,pgrp:asmdba:r-x,other::r--
ACTIONS=
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALERT_TEMPLATE=
ALIAS_NAME=
ASM_DISKSTRING=/dev/oracle/*
AUTO_START=restore
CHECK_INTERVAL=1
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=asm) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%)
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Oracle ASM resource
ENABLED=1
GEN_USR_ORA_INST_NAME=+ASM
INSTANCE_FAILOVER=1

but databases are impacted as well.

so we changed it to every minute a check

-bash-4.1$ crsctl modify resource ora.dba12c.db -attr "CHECK_INTERVAL=60"
-bash-4.1$ crsctl modify resource ora.asm -attr "CHECK_INTERVAL=60"


ofcourse a cron job to delete the audit files on a regular basis installed ...


Saturday, December 7, 2013

post UKOUG impressions

I had a blast at UKOUG, I  met plenty of friends, finally could place a face on an avatar and had my first talk ever, in short lots of emotions and the quality of the sessions was very very high. I helped with RAC attack and was glad to see that plenty of people have now RAC running on their laptop.


I enjoyed  my good friend Iloon's session about the APEX listener. Joel Goodman on the picture here under chaired the session.








My talk it self went fine, had a good interaction with the audience and got some good questions, Solaris and LDOMs are certainly not dead, i think it just started for them as Bjoern Rost's session about a customer moving from Linux to Solaris showed, which was a great session BTW he really is a gifted speaker.



It was not only my first time but also Jan Karremans' first conference talk, he really did a good job he was up at 8:30 wednesday. I really enjoyed his session



Finally I got to meet Osama Mustaffa and Uwe Hesse face to face, two great guys, I feel like I have two friends, you guys rock






Thank you Iloon , Joel , Oyvind Isene, Sally-Ann, Peter Raganitsch,  Uwe, Bjoern, Osama,Gert Poel, Jan, Frits Hoogland (without you I was still at the train station ;) you made UKOUG something not to forget soon !!!







Apart from UKOUG and running in parallel there was also Oak Table World, with great speakers, I went to two presentations over there :

Apex for Dba's
Hadoop for Dba's

both very interesting





The jumping Rac Attack Guys ( + plenty of others that came later) 




I now have to keep my promise to the attendees of my session to put a blog article online about the performance of different SPARC processor and the impact of virtual I/O


Also a big thank you to Kevin Closson father of  SLOB, thank you for this great tool, it helped me a lot and is standard in my tool.

Sunday, December 1, 2013

arrived in Manchester

I arrived in Manchester today, looking forward to it.

this is my agenda for today

NAS & SAN Storage with the Oracle ZFS Storage Appliance  by Mr Darren Moffat

Oracle Transaction Locks and Analysis by Mr Kyle Hailey

and of course Iloons session

How to Avoid to Struggle with the APEX Listener


looking really forward to it.

Tomorrow D-day ;-)