(Liron Amitzi) I wrote lately a couple of post about upgrading to 18c (why research is important and OCR and Voting disks on 18c and 19c).
Tag: Oracle
Backtracking
(stewashton) By popular request, here are my thoughts about the impact of “backtracking” on performance when using the MATCH_RECOGNIZE clause.
maximum size of ORALCE_SID
(Martin Berger) The maximum length of ORACLE_SID environment variable seems to be a mystery in many places.
DML error logging redux
(Connor McDonald) I posted a nice little feature of DML error logging recently, and a comment came in mentioned that caution is needed with DML error logging because the errors are logged persistently.
Cloning Oracle Homes in 19c Part 2
(mdinh) You didn’t think there was going to be a part 2 did you?
ORA-40478: output value too large (maximum: )
(Flavio Casetta) If you are hitting the following error while executing a query containing a JSON_TABLE function like this:
What’s new with Oracle database 18.8 versus 18.7
(Frits Hoogland) The amount of changes between version 18.7 and 18.8 is truly minimal. There’s one spare parameter renamed to an underscore parameter, which seems to be a back port of functionality created version 19:
Cloning Oracle Homes in 19c
(mdinh) You may find conflicting information from Oracle’s documentation where Cloning an Oracle Database Home shows to use clone.pl and Database Upgrade Guide 19c shows Deprecation of clone.pl Script
How to Script Workspace Provisioning on Oracle Autonomous Database
(Jason Straub) A recent Oracle APEX patch was applied to Oracle Autonomous Database Serverless that enabled the following:
User-editable Application Setting
(Jeffrey Kemp) A nice addition to APEX release 18.1 is the Application Settings feature. This allows the developer to define one or more configuration values that are relevant to a particular application.