★ Native JSON Support in Oracle Database 12c

If you want JSON support in your Oracle database today you can use PL/JSON, an open source JSON parser written in PL/SQL. However, as Marco reported from Oracle OpenWorld, native JSON support may be...
0 comment

★ Now Available for Download: Presentations from Oracle OpenWorld 2013

Head to the Content Catalog and start downloading your favorite sessions. No registration needed. Sessions will be available for download until March 2014. Note that some presenters chose not to make...
0 comment

★ Oracle Database 12c In-Memory Option Explained

Jonathan Lewis explains the recently announced Oracle Database 12c in-memory option: The in-memory component duplicates data (specified tables – perhaps with a restriction to a subset of columns)...
0 comment

★ Oracle Database 12c Bookmarklet, Search Plugin and New Features

The blogosphere continues its buzz about Oracle Database 12c and what feels like an unlimited supply of new features in this latest cloud enabled release. Speaking of new features, here is what’s...
0 comment

★ When Versioning Support Interferes With Saving Your Relational Model

To reverse engineer an existing database into a relational model, I used SQL Developer Data Modeler, a free data modeling and database design tool from Oracle. I had a problem with the tool. I could...
0 comment

SQL Plan Stability and CBO Statistics Myths Busted

Carlos Sierra: Since lack of Histograms or freezing CBO Statistics do not guarantee Plan Stability, do not rely on these two myths. If what you are looking for is Plan Stability use then SQL Plan Management...
0 comment

Logger: a PL/SQL Logging and Debugging Framework

Martin D’Souza: Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago...
0 comment

Not a Fan of Public Synonyms, Here is Why

Tom is not not a fan of public synonyms, here is why: public synonyms pollute the namespace. public synonyms can lead to security issues. public synonyms can lead to a maintenance headache. ...
0 comment

When You Should Consider Flash for Database Storage

@flashdba: If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database: I/O wait times are high. Essentially we are looking for high...
0 comment

★ Oracle News Aggregator OraNA No Longer Powered by Google Reader

You probably heard that Google is going to shut down Google Reader (GR) on July 1st, 2013. There are many theories, speculations and analysis as to why Google took the decision to kill Reader. To me...
0 comment