Author Archives

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…

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…

SSL with PKCS12 truststore

Many many moons ago I vaguely remember having a similar issue with java keystore / truststore and microsoft certificates stores.
When you start using SSL for your listener, you could potentially face a large number of issues amoung your toolsets. In m…

anonymous cypher suites for SSL (and a 12c pitfall)

If you configure your listener for encryption only, you do not really need authentication.
It works pretty fine until 11.2.0.2, I wrote multiple posts on ssl.
You add SSL_CLIENT_AUTHENTICATION=FALSE to your server sqlnet.ora and listener.ora and spec…

How to *really* send a script to the background

Let’s check this small script
– foo.sh

#!/bin/sh
echo foo.1:`date` | tee $HOME/tmp/foo.txt
sleep 3
echo foo.2:`date` | tee -a $HOME/tmp/foo.txt

$ $HOME/tmp/foo.sh
foo.1:Thu Nov 27 17:34:53 CET 2014
foo.2:Thu Nov 27 17:34:56 CET 2014

Ve…