(Martien van den Akker) In BPM12c there is a tight integration with BAM, like it was with 11g. However, BAM is not automatically installed in BPM. You need to do that seperately. But having done that, you need to get BPM acquainted with BAM and instruct it to enable process analytics.
Other News
pstop – a top-like program for MySQL (based on performance_schema)
(Simon J Mudd) I have been working with MySQL for some time and it has changed significantly from what I was using in 5.0 to what we have now in 5.6. One of the biggest handicap we’ve had in the past is to not be able to see what MySQL is doing or why.
Hash Join
SQL Server uses three different techniques when joining tables depending on the size of the table and the indexes available. When no good index exists on either table to implement an efficient join process, the query optimizer will often select a HASH Join. A hash join is performed by creating a hash value for the attributes used to join both […]
DB2 11 Index Cleanup Threads
(Troy L Coleman) IBM continues to focus on improving index management, with a goal of reducing the overall cost of storing and retrieving data from DB2 by helping customers avoid I/Os.
DB2 DBA Tip: UNIX script to find column names that have matching string
(Pavan Kristipati) In this blog post, I will share a quick UNIX script that I frequently use to find column names that have a string in them. This came out of a need a while ago when I had to frequently type a long SQL that would generate matching column names.
Discussing the innodb_log_block_size variable
(Chris Calender) Not a ground-breaking post here, but if you are interested in knowing more about the innodb_log_block_size variable, or if you use SSD cards and/or large InnoDB log files on ext4, then this is for you.
Controlling RMAN channels on RAC
(John Hallas) I have recently worked with the customer where standard RMAN backups of production 2-node cluster (11.2.0.3) were getting too big and taking longer than 24 hours to run.
Oracle AWR Reports: When Averages Lie
(flashdba) I was recently contacted by a customer who runs a busy ERP system on their Oracle database. Their users have been screaming for some time about unpredictable performance, where application screens which would usually open in under a second suddenly take an age.
Adding a DEFAULT column in 12C
(Neil Chandler) I was at a talk recently, and there was an update by Jason Arneil about adding columns to tables with DEFAULT values in Oracle 12C. The NOT NULL restriction has been lifted and now Oracle cleverly intercepts the null value and replaces it with the DEFAULT meta-data without storing it
The Semantic Database In Action
(Marc Clifton) The video is a great way to actually see process described in this article. It’s pretty raw, so at some point I might redo it to make it a bit more professional.