In these pre-OOW 2013 days, everyone is excited about new features of Oracle 12c. Which allows to observe all OS activity. This was enough for me to start investigating it.

I have been working with Oracle database performance for many years now, but for me it is time to make a change. Today I start with an exciting new and nimble company MemSQL. MemSQL has created an incredible streamliner. Even time you run a SQL, a sp.

Pages on this site and a few other sites. If you want to use the more traditional blog entry point you can bookmark. This URL for ordinary postings. This is also the URL for the page referenced to the right as. In the panel to the right there is a link to. The greatest enemy of kno.

Is Standard Edition Database something for the Enterprise? This is a blog about stuff related to the license agreement that a DBA must remember when working in a Standard Edition Database environment. Can I use this? .

The code suffered heavily from the Context Switch. He literally was called millions of times. We set ourselves the goal of having a single Bulk Collect to read all data from the database . How does the select look like? Posted in Oracle Performance Riddle.

Notes about Oracle SQL, PLSQL and APEX. Copy ACLs during Upgrade to Apex 5. The following works in 12c only. In previous database versions the package to set ACLs had other modules. The script does not call any deprecated functions. Copy and unzip the file into a.

This blog post describes how to partially rescue data from corrupted table segments if you find yourself in a miserable position of not having a valid backup at your disposal. Density Calculation with Hybrid Histograms.