Category Archives: Uncategorized

Our Week at UKOUG

Earlier this month, Noel (@noelportugal) and I (@joybot12) represented the AppsLab crew at the UKOUG Apps 14 and Tech 14 conferences in Liverpool.
I conducted customer feedback sessions with users who fit the “c-level executive” user pro…

Happy Christmas from oracle-base.com

Happy Christmas to everyone out there, whether they observe the whole Christmas thing or not.
I often take a look at the website stats on occasions like this to see who is hanging about and this is what I can see at 08:00 UK time on Christmas day morni…

Install Nagios on a Synology DiskStation DS415+

December 24, 2014 (Back to the Previous Post in the Series) This article describes how to compile and run Nagios 4.0.8 (with 2.0.3 plugins) on a Synology DiskStation DS415+ (64 bit), which utilizes an Intel Atom Avoton processor (cat /proc/cpuinfo ind…

last partition

if you really need to quickly find the latest partition per table, I have written this little gem

WITH FUNCTION d (b BLOB, len number) RETURN DATE IS
  d DATE;
BEGIN
  IF DBMS_LOB.SUBSTR (b, 1, 1) = hextoraw('07') and len…

Skin Game

Skin Game by Jim Butcher is the 15th book in The Dresden Files series.
For a quick recap, Harry Dresden is a wizard for hire. Look him up in the Chicago Yellow Pages. Magic is real. Ghosts are real. Fairies are tall, so beautiful it’s almost pa…

Oracle REST Data Services (ORDS) 3.0 on Tomcat 7

What started out being a quick dabble with Oracle REST Data Services (ORDS) 3.0 spawned a bunch of different things…
First, I needed a fresh APEX installation to play around with. Most of the APEX stuff I’ve been using recently has been a…

Just in case

For those who don’t read Oracle-l and haven’t found Nikolay Savvinov’s blog, here’s a little note pulling together a recent question on Oracle-L and a relevant (and probably unexpected) observation from the blog. The question …

Data Guard and Oracle Restart, aka relink always !!!

During my early years with PC I love to play “Leisure Suit Larry” (especially part 1 to 3 which has running on CGA or Hercules graphics card). Author of this games, Al Lowe had a good sense of humor and every time you failed your mission or stuck in a …

Do you have a partition in 2015

You need to check the high_value from dba_tab_partitions.
Or you you could metadata.
With metadata, it is not a long, it either clob or clob-xml.

  SELECT t.table_name,
         MAX (
  &nbs…

OLTP type 64 compression and ‘enq: TX – allocate ITL entry’ on Exadata

Recently we’ve seen a strange problem with the deadlocks at the client database on Exadata, Oracle version 11.2.0.4 . Wait events analysis showed that sessions were waiting for “enq: TX – allocate ITL entry” event. It was strange becaus…