Most Recent

There’s a thread on the OTN database forum at present asking for advice on optimising a query that’s trying to find “the most recent price” for a transaction given that each transaction...
0 comment

Performance Problems with Dynamic Statistics in Oracle 12c

I’ve been making some tests recently with the new Oracle 12.1.0.2 In-Memory option and have been faced with an unexpected  performance problem.  Here is a test case: create table tst_1 as with q as...
0 comment

Re-optimization

The spelling is with a Z rather than an S because it’s an Oracle thing. Tim Hall has just published a set of notes on Adaptive Query Optimization, so I thought I’d throw in one extra little...
0 comment

Adaptive Query Optimization in Oracle Database 12c

Over the holiday period I finally decided to tackle the Adaptive Query Optimization stuff in Oracle 12c, which resulted in these articles. Adaptive Query Optimization in Oracle Database 12c Release 1...
0 comment

“a SQL” or “an SQL”?

This is an age old question and of course the answer depends on how you say “SQL”. … a Structured Query Language statement… … a Sequel statement… … an Es Queue...
0 comment

2014 Year in Review

As many bloggers and sites do this time of the year, here is my review of 2014. It was a great year and it was a lot of fun, as well as educational reviewing all the data. DBAKevlar Blog Busiest Day on...
0 comment

UKOUG Annual Conference (Tech 2014 Edition)

The conferenceThis year the UKOUG's tour of Britain's post-industrial heritage brought the conference to Liverpool. The Arena & Convention Centre is based in Liverpool docklands, formerly the source of...
0 comment

Free Oracle E-Business Suite Video Series

A Guest Post by Jim Vonick, Sr. Product Manager, Oracle University Explore the latest features, strategies and roadmaps for Oracle E-Business Suite with the following series of free instructional videos. ...
0 comment

Watch: Riak vs. Oracle

Every data platform has its value, and deciding which one will work best for your big data objectives can be tricky—Alex Gorbachev, Oracle ACE Director, Cloudera Champion of Big Data, and Chief Technology...
0 comment

How to Migrate a Database Using GoldenGate

There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of datapump and GoldenGate to migrate your database on cross-platform will minimize your...
0 comment