Oracle Scratchpad

June 28, 2013

12c Debug

Filed under: 12c,Bugs,Oracle — Jonathan Lewis @ 8:45 am GMT 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).

6 Comments »

  1. Do we have also list of bugs which were introduced in 12c? I am working for Bank sector, one customer moved to 11.2.0.3 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 11.2.0.3 since there were two many bugs in 11.2.0.1 and 11.2.0.2). 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 GMT Jun 28,2013 | Reply

  2. Here’s a reference to a comment describing a bug related to “default column values”: http://jonathanlewis.wordpress.com/2013/07/14/12c-histograms/#comment-58319

    Comment by Jonathan Lewis — July 24, 2013 @ 12:50 pm GMT 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:

    http://dbaworkshop.blogspot.it/2013/08/The-first-bug-on-Oracle-Database-12c-how-to-create-a-PDB-by-cloning-a-remote-existing-pluggable-database.html

    Comment by Marco Vigelini — August 13, 2013 @ 3:12 pm GMT 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,422 other followers