Oracle Scratchpad

June 28, 2013

12c Debug

Filed under: 12c,Bugs,Oracle — Jonathan Lewis @ 8:45 am BST Jun 28,2013

Now that 12c is out, here’s an idea that might save you some time even if you have no intention of migrating to, or even testing, the product for a couple of years. Download the “List of bugs fixed in 12c”: you may find that it’s the best starting point when you’re trying to solve a problem in your current version of Oracle.

A slightly more sophisticated version of the same thing – download and install the product, then take a dump of v$system_fix_control – that may also give you some insight into anomalies (that are not necessarily declared as bugs) in the way Oracle – and the optimizer in particular – behave. I updated the referenced note to add in a couple of figures for 12.1 – but one figure that’s not there is the number of database parameters: now at 368 in the v$ and 3,333 in the x$ (in my Beta 3 release).


  1. Do we have also list of bugs which were introduced in 12c? I am working for Bank sector, one customer moved to only 9 months ago. Logged more than 15 SR, 7 of them is still opened (development working). advanced cursor sharing is causing troubles instead of helping, shared pool is in poor state (f.e. share pool durations are disabled by default in since there were two many bugs in and Hope it would take oracle developmet at least additional 9 months to release 12c for AIX and customer won’move to 12c soonas as in 4 yeras

    Comment by Pavol Babel — June 28, 2013 @ 11:41 am BST Jun 28,2013 | Reply

  2. Here’s a reference to a comment describing a bug related to “default column values”:

    Comment by Jonathan Lewis — July 24, 2013 @ 12:50 pm BST Jul 24,2013 | Reply

  3. Few weeks ago while testing the different scenarios to create a pluggable database I discovered a bug on cloning a remote existing PDB.
    Here is my contribution:

    Comment by Marco Vigelini — August 13, 2013 @ 3:12 pm BST Aug 13,2013 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Theme: Rubric. Get a free blog at


Get every new post delivered to your Inbox.

Join 4,088 other followers