January 2016 - All-round Database Topics

Excessive query parsing time with extended statistics and long in-lists

January 21, 2016Nenad Noveljic 2 Comments

Excessive query parsing time with extended events and long in lists were observed on a 12c database. As a workaround set the undocumented parameter _optimizer_extended_stats_usage_control to 224. Continue Reading →

How to implement file locking in Perl

January 16, 2016Nenad Noveljic Leave a Comment

The post explains how to implement file locking in Perl Continue Reading →

Avaloq Database Crash

January 7, 2016Nenad Noveljic Leave a Comment

Setting session level to zero can crash the database if there are local JDBC connections from the application users (i.e. users that are registered in K.SEC_USER and at the same time a core database background process is running under the PID 1234. Continue Reading →