(stewashton) A reader called chris asked me a good question about optimistic locking: why not use a “user-defined” scn (e.g. timestamp) as an extra column to achieve the same goal as ORA_ROWSCN? Well, chris, you’d have to use one per row, not one per transaction.
Tag: Oracle
Oracle JET Router State Control
(Andrejus Baranovskis) In my use case there is requirement to navigate to JET module, without displaying it in menu structure.
Oracle’s Autotrace Can Lie to You
(David Fitzjarrell) Query tuning is part art, part science and it depends upon reliable information from Oracle, most often in the form of query execution plans. There are several ways to generate such plans, three of which are ‘autotrace traceonly explain’, ‘explain plan’ and the dbms_xplan package
Read Oracle Database 12.2 New Features Manual
(Bobby Durrett) I just finished reading the Oracle database 12.2 new features manual. I have postponed looking at 12.2 until now because for a long time 12.2 was not available for download even though it was available in Oracle’s cloud.
Parameterizing Jmeter for testing APEX
(Kris Rice) A while ago we needed to stress a system by using the APEX Brookstrut demo application. The obvious choice for this was Jmeter.
Combining Resource Consumer Groups with Application Modules in #Oracle
(Uwe Hesse) This article contains a complete working example for the Resource Manager on the command line for those of you who can’t use the Enterprise Manager fort it. Believe me, I feel your pain
Reading AWR Report – Part 2
(amitzil) In the previous part I explained the top part of the report. In this part I’ll continue with the actual information about database activity, what we are looking for and other important things we can find in the report.
Oracle JET Modular Architecture Example
(Andrejus Baranovskis) One of my favourite parts in Oracle JET – modular code structuring support. This allows to split application functionality into modules and reusable functions
Oracle Mobile Cloud Service (MCS): Overview of integration options
(Maarten Smeets) Oracle Mobile Cloud Service has a lot of options which allows it to integrate with other services and systems. Since it runs JavaScript on Node.js for custom APIs, it is very flexible.
ADF BC Attribute – Collection Storage Mode Property
(Andrejus Baranovskis) I would like to describe one interesting property for ADF BC attribute. This property is called Storage. There are two possible values: row (default) and collection.