Category Archives: Oracle

SQL Developer: Viewing Trace Files

Just a quick plug for looking at raw sql trace files via SQL Developer.
There is a nice Tree View:

Which can be expanded:

Also summary view of statistics, filterable:

And a list view, filterable and orderable:

Some sort of right click summary for b…

Exadata Documentation Available

Please join me in welcoming the Exadata product documentation to the internet. It’s been a long time coming, but glad it’s finally made an appearance!

Everything I Needed to Know About Enterprise Manager I Learned at Collaborate 2015

Collaborate 2015 at the Mandalay in Las Vegas is just around the corner and the sheer amount of Enterprise Manager focused content is phenomenal!  Oracle partners and power users around the world come together each year to provide the lucky attendees …

Real time sql monitoring – bulk bound statement

Moving through some observations of an ongoing investigation tackling the easiest ones first.
Previously I observed the slow execution of a recursive delete of statistics history but coming not from MMON but from a number of application processes which…

COUNT STOPKEY – NVL

Yesterday I mentioned issues with a recursive delete operation on statistics history.
This is a quick illustration of the last points I made on that post regarding the lack of a COUNT STOPKEY optimisation because of the use of NVL.
COUNT STOPKEY is an …

Understanding vs Resolution – Statistics History Cleanup

Today I helped resolve a problem quickly but to the detriment of my understanding of exactly what was going on and why.
And as part of the quicker resolution, I had to destroy the evidence which would have helped understand better.
So… now need t…

Exadata X5 – A Practical Point of View of the New Hardware and Licensing

Oracle recently announced its latest iteration of Exadata – X5-2. It includes a refresh of the hardware to the most recent Xeon® E5-2699 v3 CPUs. These new CPUs boost the total cores count in a full rack to 288. This is higher than the current 8 soc…

255 columns

Here’s a quick note, written and some strange time in (my) morning in Hpng Kong airport as I wait for my next flight – all spelling, grammar, and factual errors will be attributed to jet-lag or something.
And a happy new year to my Chinese …

Robert G. Freeman on Oracle 2015-02-18 23:14:41

This is somewhat of a personal post, but it’s also related to Oracle. I’ve been involved in some discussions about 12c Multitenant and the fact that Oracle will be doing away with the 12c Non-Multitenant architecture someday.

These discussions have…

Robert G. Freeman on Oracle 2015-02-18 22:28:34

In a Multitenant database,you can create user accounts within the PDB’s just like you normally would. For example this command:

SQL> show con_name

CON_NAME
——————————
TESTPDB

SQL> create user dbargf identified by robert;

W…