ORA-56904 when using Pivot with partitioned tables and Oracle Database In-Memory
By: Date: April 15, 2016 Categories: ORA-56904,Oracle,Oracle Database In-Memory,Pivot

I was contacted by the application developers to check a query which resulted in an ORA-56904 in a 12.1.0.2 Oracle Database.  The query used Pivot to select data from a partitioned table which was stored in memory (INMEMORY clause). Without the INMEMORY clause the query was running fine. To recreate the scenario I used the following simplified test-case:…

Read More →
Avaloq script terminating Oracle Processes
By: Date: March 12, 2016 Categories: Avaloq,Database Crash,modelcache,Oracle

One of our Avaloq Databases crashed with the following information in the alert log: Wed Mar 02 19:10:22 2016 PMON (ospid: 26747): terminating the instance due to error 471 Wed Mar 02 19:10:23 2016 System state dump requested by (instance=1, osid=26747 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file /u00/oracle/orabase/diag/rdbms/ora5prim/ORA5/trace/ORA5_diag_26774_20160302191023.trc Instance terminated by…

Read More →
Using the LogMiner to search for transactions in the Oracle database
By: Date: February 27, 2016 Categories: LogMiner,Oracle

Oracle offers the dbms_logmnr package to look inside the archivelogs of the database. you can only view every DML with the LogMiner if you have previously enabled at least minimal supplemental logging. To verify if it is enabled you can run the following query: SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database; SUPPLEME ——– YES   Now let’s say we need to…

Read More →