Oracle VM Site Review - Oracle VM Health Check
view counter

Feed items

node-oracledb 0.6.0 is on NPM (Node.js driver for Oracle Database)

Node-oracledb 0.6.0 is now out on href="https://www.npmjs.com/package/oracledb" >NPM. The Oracle
Database Node.js driver powers high performance Node.js
applications.

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.

Enterprise hits and misses – radical ERP evolution and robots-drive-trucks edition

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 […]

Author information

Jon Reed

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 Dynamic Sampling and Standard Edition

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.

Stop That!

"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:

MySQL Query Profiling with Performance Schema

One of my favorite tools for query optimization is profiling. But recently I noticed this warning:

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

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.

Log Buffer #424: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers various valuable blog posts from the fields of Oracle, SQL Server and MySQL.

Oracle:

OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users

OBIEE 11.1.1.9 was released this May and Robin and Mark wrote great posts about New Features from System Administrators and the new support for HiveServer2 and Cloudera Impala respectively. In this post, we will see some useful new featur

view counter