Top 60 Oracle Blogs

Recent comments

March 2011

Presenting at Miracle Open World 2011

Just a really quick post about my appearance at Miracle Open World 2011 in Denmark next month:

I strongly recommend you to have a look at the agenda and speakers, there are lots of fellow Oak Table members sharing their knowledge-quite an incredible lineup and a great honour for me to be there.

Ad: Trivadis Performance Days 2011

The company I work for, Trivadis, has organized a 2-day seminar with Cary Millsap, James Morle, Jonathan Lewis and me. It will take place in Zurich the 24-25 of May.

If you are interested in topics like the following, do not miss the opportunity…

Telco Churn Case Study Reloaded: Oracle Data Miner

The previous three-part series on mining star schemas (using a telco churn case study) demonstrated how to leverage SQL and the Oracle Data Mining API to capture complex methodology in a simpler, more performant approach.  I have been informed that there is this concept called a "user interface" which some people find enticing :-).  This post demonstrates the telco churn methodology using the shiny new Oracle Data Miner interface.  Oracle Data Miner is bundled with SQL Developer 3.0 (SQL Developer 3.0 is currently available as an early adopter release) and runs against Oracle database version 11gR2 with the Oracle Data Mining option enabled.

Testing, Testing, 123

This is the second post in a row inspired by a comment on Twitter. The tweet that inspired this is here. The author was expressing her frustration at test hardware that did not reflect the production system. This approach was recently well illustrated on the BBC Top Gear show as you can see in the [...]

Automatic log gathering for Grid Control 11.1

Still debugging the OMS problem (it occasionally hangs and has to be restarted) I wrote a small shell script to help me gather all required logs for Oracle support. These are the logs I need for the SR, Niall Litchfield has written a recent blog post about other useful log locations.

The script is basic, and can possibly be extended. However it saved me a lot of time getting all the required information to one place from where I could take it and attach it to the service request. Before uploading I usually zip all files into to avoid clashing with logs already uploaded. I run the script via cron daily at 09:30.


# A script to gather diagnostic information for OMS GC 11.1 for use by Oracle
# Support
# WARNING the previous output of the script's execution is NOT preserved!
# (c) Martin Bach Consulting Ltd All rights reserved
# The script performs the following tasks
# 1) creates a heap dump for the EMGC_OMS1 server
# 2) creates a compressed tar archive of all server logs
#    including the webtier

set -x


# get heap dump for EMGC_OMS1-I upped the JVM args to -Xms of 768M which works
# fine as an identifier in Solaris 10. For Linux you may have to grep for EMGC_OMS1
# in the ps output
# the heap dump goes into EMGC_OMS1.out which is compressed and saved later
DUMP=`ps -ef | grep "Xms768m" | grep -v grep | awk '{print "kill -3 "$2}'`

if [ ! -d $DST_DIR ]; then
echo $DST_DIR does not exist-creating it
mkdir -p $DST_DIR

# get the relevant logs
cd $GC_INST/em/EMGC_OMS1/sysman/log/
tar -cvf - . | gzip > $DST_DIR/gc_inst.em.EMGC_OMS1.sysman.log.tar.gz

cd $GC_INST/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/
tar -cvf - . | gzip > $DST_DIR/

cd $GC_INST/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/
tar -cvf - . | gzip > $DST_DIR/

cd $GC_INST/WebTierIH1/diagnostics/logs/OHS/ohs1
tar -cvf - . | gzip > $DST_DIR/webtier.ohs1.log.tar.gz

cd $GC_INST/WebTierIH1/diagnostics/logs/OPMN/opmn
tar -cvf - . | gzip > $DST_DIR/webtier.opmn.log.tar.gz

Good luck!

Oracle Database Time Model Viewer in Excel 2

March 1, 2011 (Updated March 2, 2011) (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) In the previous blog article in this series, we examined the output generated by one of my programs.  Most of that output was centered on the analysis of the time model statistics in Oracle Database [...]