October 2015 archive

Oct 28

My OOW15 Trip Is Complete

I’m leaving Open World 2015 a day early. I managed to pack in an awful lot of activity into the three days I was here and I met up with some very nice people. I expect that my OOW experience was similar to many others. There was so much to do and not enough time. …

Continue reading »

Oct 28

Cursor Obsoletion Dump

After our recent upgrades to Oracle 12.1.0.2, we noticed a few non-production databases that were filling up the DIAGNOSTIC_DEST. There were huge trace files in there which contained this type of information: —– Cursor Obsoletion Dump sql_id=6aca4drrt76x3 —– Parent cursor obsoleted 1 time(s). It appears this is a known bug in 12.1.0.2. Oracle turned on …

Continue reading »

Oct 26

Oracle 12.2 Sharding

I’ve been working with MongoDB a bit and one of the things I like about it is how sharding helps the platform achieve high performance. MongoDB is not the only database platform that uses sharding, just one of the more mainstream ones. While I’ve been working with MongoDB and admiring sharding and the ability to …

Continue reading »

Oct 26

12.2 RAC/GI New Features

I attended a session today at Oracle Open World 2015 by Markus Michalewicz which highlighted some new features we can look forward to for Oracle Grid Infrastructure 12.2, currently in beta.  There were lots of new features, but a few stood out as major changes to the architecture. Oracle 12.1 introduced Flex Clusters about two …

Continue reading »

Oct 26

Oracle 12cR2 now in Beta

Today at Oracle Open World 2015, I learned that Oracle12cR2 is now in beta. I attended a session from Oracle VP Andy Mendelsohn where he highlighted a few of the new features found in 12.2. This is not an exhaustive list, but contains some highlights from that session.   Sharding for web-scale applications Table and …

Continue reading »

Oct 23

SQL Developer 4.1.2

SQL Developer 4.1.2 was just released today. The new version can be downloaded from the usual place on OTN. I had no problems installing it on my MacBook Pro.  

Oct 21

Oracle 12c Upgrade Issues

I recently upgraded a critical production system from Oracle 11.2.0.4 to 12.1.0.2. This is also a 3-node Oracle RAC database. I ran into a few issues which needed resolution after the upgrade. Hopefully this helps out others in their upgrades. The first issue was related to a Global Temp Table that is central to our …

Continue reading »

Oct 14

Oracle Live SQL

Over the years, I’ve seen people ask questions on where they can access a demo Oracle database so that they can practice and learn SQL or PL/SQL. Until today, I never knew of any available Oracle testbed for public consumption. Now, Oracle Corp has provided us with LiveSQL.oracle.com and the only thing you need to …

Continue reading »

Oct 02

12c Adaptive Plans in SQL Developer

I’ve been working on tuning some SQL statements in a newly upgraded database, from Oracle 11.2.0.4 to 12.1.0.2. As I typically do, I like to use SQL Developer to see the Explain Plan. I was surprised to see some gray text in the Explain Plan output, which you can see below.         …

Continue reading »