Category Archives: Oracle

Writing a new conference presentation

At the weekend I put together two new talks. One is a session for a local University, which I will blog about when it is confirmed. The other is a new conference presentation called “Pluggable Databases : What they will break and why you should …

Oracle Scratchpad 2015-02-08 04:12:05

I think the “mini-series” is a really nice blogging concept – it can pull together a number of short articles to offer a much better learning experience for the reader than they could get from the random collection of sound-bites that…

Little Things Doth Crabby Make – Part XVIII. Automatic Storage Management Won’t Let Me Use My Disk For My Files! Yes, It Will!

It’s been a long time since my last installment in the Little Things Doth Crabby Make series and to be completely honest this particular topic isn’t really all that fit for a LTDCM installment because it covers something that is possible bu…

Robert G. Freeman on Oracle 2015-02-06 20:24:17

I always run an Exacheck before patching an Exadata box. It’s just a good practice. In many cases I’ll ask the DBA at the customer to run it for me and send me the results. There is one consistent problem that I want to address in this blog and that’s …

Robert G. Freeman on Oracle 2015-02-06 01:00:00

This is part two of my response to the deprecation of the non-CDB model at some point in the future and some of the responses that have been made in relation to this announcement.
In Part One I addressed the initial comments that were made indica…

Robert G. Freeman on Oracle 2015-02-04 22:56:44

Oracle has announced the deprecation of the non-CDB architecture as seen in this blog entry here. Of course, the knee jerk, negative, FUD ridden comments are starting to come out. One of these kinds of responses can be seen in this blog.
Edit: I wa…

Statistics Collection Enhancements on Oracle Database 12c

I’ve been having a play around with the enhancements to the statistics collection in 12c. I’ve put together this top-level post with links to all my other articles on this subject.

Statistics Collection Enhancements in Oracle Database 12c…

Call vs Exec

Just a reference to a really simple difference between CALL and EXEC.
I thought I had mentioned this before but couldn’t find it so…
EXEC/EXECUTE is a SQL*Plus command which wraps the proc call in an anonymous BEGIN … END; block.
CALL…