There is one feature change in this release: node-oracledb now
builds with Node.js 0.10, 0.12 and with io.js. Huge thanks to href="https://github.com/Bigous" >Richard Natal for his href="https://github.com/oracle/node-oracledb/pull/43" >GitHub pull
request that added support.
diginomica hit: Radical evolution in the ERP/MRP space – by Brian Sommer and Den Howlett quotage: “When parts have virtually zero labor costs included, virtually no scrap or rework, what is left for cost accountants to quantify or do? There may only be two costs that matters and that’s the raw material for the printer […]
Jon Reed has been involved in enterprise communities since 1995. These days, Jon is a roving blogger/analyst, and als
Click on the link for the full text/media - @jonerp
12c is coming with more dynamic sampling, now called dynamic statistics and using the new Adaptive Dynamic Sampling algorithm. The goal is to have better estimations and better estimations gives better execution plans. However, this new approach will increase parse time because dynamic sampling kicks in more often, reads more blocs, and run more queries.
"It seems to me that almost everything is a waste of time."
- Norton Juster, The Phantom Tollbooth
Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:
One of my favorite tools for query optimization is profiling. But recently I noticed this warning:
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon.
However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c databases including legacy and container databases.
The following simple SQL and sqlplus techniques can be used to make a “universal script” that is compatible with all versions.
This Log Buffer Edition covers various valuable blog posts from the fields of Oracle, SQL Server and MySQL.