★ Native JSON Support in Oracle Database 12c

json

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 an upcoming new feature in Oracle Database 12c.

This new feature allows the storage of (more...)

★ Now Available for Download: Presentations from Oracle OpenWorld 2013

Oracle OpenWorld 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 their sessions available.

Via the Oracle OpenWorld Blog.


© Eddie Awad's Blog, 2013. | Permalink | Add a (more...)

★ Oracle Database 12c In-Memory Option Explained

12c

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) in columnar format in a dedicated area of the SGA. The data is kept up to date in real time, but (more...)

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

12c 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 new in Oracle Database, SQL and PL/SQL from 9iR1 until 12cR1.

With a new release comes new (more...)

★ When Versioning Support Interferes With Saving Your Relational Model

Oracle SQL Developer Data Modeler icon 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 not save the model. It appeared to be saved but when I reopened the . (more...)

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 available since 11g or SQL Profiles available from 10g.


© Eddie Awad's Blog (more...)

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 and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce (more...)

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.
  • public synonyms are public – no one owns them.

So, instead of public synonyms…

create PRIVATE synonyms or (more...)

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 latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond (more...)

★ Oracle News Aggregator OraNA No Longer Powered by Google Reader

OraNA.infoYou 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 GR was not just a place I visit several times daily to get (more...)