(Brendan Tierney) If you are a user of the Oracle Data Miner tool (the workflow data mining tool that is part of SQL Developer), then you will have noticed that for many of the algorithms you can specify a Case Id attribute along with, say, the target attribute.

(Kris Rice) I saw Stephen’s example of checking reserved words in the database from Vertan’s day and figured I’d do the same in SQLcl.

(David Fitzjarrell) Oracle provides two parameters that affect the PGA that look very similar but operate very differently. One of these parameters is the well-known pga_max_size and the other is a hidden parameter, _pga_max_size.

(Christian Antognini) Before describing the issue that lead to this post, let’s shortly review how the handling of initialization parameters works in a multitenant environment.

(Ben) In this article, I’ll explain what the Oracle CHARTOROWID function is and show you an example.

(cj) Want a fast way to spool CSV or JSON from Oracle Database? Check out the new SQL*Plus 12.2 SET MARKUP CSV option and the new Oracle Database 12.2 JSON_OBJECT operator.

(Andrejus Baranovskis) ADF Faces LOV component can be easily enabled with auto suggest functionality.

(Kevin Closson) I recently had some cycles on a freshly installed Dell EMC XtremIO Storage Array. I took this opportunity to prepare a blog entry about the never-ending topic of whether or not storage arrays are able to reduce physical data capacity through deduplication of blocks in Oracle Database

(Brendan Tierney) The Oracle 12.2c Database has been released and is currently available as a Cloud Service. The on-site version should be with us soon

(Uwe Hesse) With the current release 12.2, flashback can be done on the PDB layer. As a prerequisite, the database must be put into local undo mode. That means that each PDB has its own undo tablespace.