Category Archives: Oracle

NZOUG 2014 Auckland Conference November 19th/21st

It seems the end of the year is the time for conferences, and my favourite conference of them all is coming up, the New Zealand Oracle User Group conference Wednesday-Friday 19th-21st November in Auckland. With all due respect to our Oracle market…

AUSOUG 2014 Perth Conference 6th/7th November

For the Perth Australia regulars, the Australian Oracle User Group is running their annual conference on the 6th & 7th November, and for what I think is my 9th year (I’ve lost track) in a row I’ll be presenting. This year’s topics focus on…

Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used?

This is the first entry in a series of random articles about some useful internals-to-know of the awesome Oracle Database In-Memory column store. I intend to write about Oracle’s IM stuff that’s not already covered somewhere else and also about some general … Continue reading

Abstract Review Tips

Yes, this is for my RMOUG abstract reviewers, but it may help other conferences and user groups, too.  We have some incredible content at RMOUG, (Rocky Mtn. Oracle User Group) Training Days conference and its all due to a very highly controlled, thought out process that has evolved over time to ensure that we have […]



Copyright © DBA Kevlar [Abstract Review Tips], All Right Reserved. 2014.

Linux Multipathing when booting from SAN

We hit an interesting issue this week with multipathing. (RHEL5U6). We had configured /etc/multipath.conf to set the UID and GID for multipath devices provisioned to support ASM disk groups. [oracle@server1]$ ls -l /dev/mapper/ora_data1 brw-rw—- 1 oracle dba 253, 3 Jun 14 09:00 ora_data1 I decided that I wanted to change the GID from the dba group […]

Intel Xeon Processors – Hyper Threading and Turbo Boost

Over the last 18 months I have been running a standard CPU performance test on every system I encounter. The test measures the time taken by a single core to process a block of anonymous PL/SQL code. This takes anything from around nine seconds to six minutes to run depending on the CPU type. I include some of […]

Linux Shell Limits

Most Oracle database installations on Linux require configuration of shell limits. A typical configuration requires the following changes Add the following lines to /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 Additional memlock limits are required if large pages are configured. The values of these limits […]

Oracle Grid Infrastructure Installation Issues on Solaris

This post discusses some issues encountered installing Oracle on a two-node Solaris 5.10 SPARC cluster The Grid Infrastructure installation failed when running on the second node with the following error: root@server21 # /data/app/oragrid/11.2.0/grid/ Running Oracle 11g root script… The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /data/app/oragrid/11.2.0/grid Enter the full pathname […]

DBMS_METADATA and hashed passwords

In the wonderfully named “ORAganism” blog (don’t try oragasm – it is used for something QUITE different) Neil Johnson remarks on the privilege requirements for DBMS_METADATA. I like DBMS_METADATA. In the old days, you had scripts that tried to re-engineer CREATE scripts from DBA_TABLES and so on. They were complicated and worked in most situations. DBMS_METADATA is […]

Wish List IV – Read only and mean it

Did you know that the SELECT privilege actually allows you to do a SELECT … FOR UPDATE ? Yes, that means a user with just that privilege could lock an entire table. I want a SELECT_NOLOCK privilege. The user can still do a SELECT, but they cannot have a lock on the table. Okay, while […]