Oracle 12c Top New Features

I figured I would give my top new features for the recently released Oracle 12c database. I think one of the most interesting new features is the Pluggable Database, but it seems like everyone is talking about that. So I’ll focus on other new features that I am interested in. This list is in no particular order.

  • Default Values for Columns Based on Oracle Sequences – This will simplify coding since you won’t have to create a trigger for a new row. This leads to…
  • IDENTITY Columns – I work with a lot of developers that come from a SQL Server background that may appreciate this functionality.
  • Adaptive Query Optimization – The ability for the CBO to recognize that it got the plan wrong and switch to a new plan without DBA intervention is a big leap for Oracle’s SQL execution. This leads to…
  • Dynamic Statistics – Oracle can detect that the stats led to a bad execution plan and use new stats the next time the query is executed. On many occasions, I find that the nightly Stats Gathering autotask is not updating tables’ stats because they are not considered “stale” yet they should be. Too many times, I fix poorly performing SQL simply by updating stats on a table and its indexes when it should be done automatically for me.
  • Concurrent Execution of UNION and UNION ALL – The ability to parallel-ize these branches will lead to much faster executions. In my shop, we do use UNION and UNION ALL in many places in our application.
  • Automatic Data Optimization (ADO) – The ability to automatically move older data to a different storage tier will reduce the DBA’s workload.
  • In-Databaase Archiving – The ability to mark rows as “archived” and hide them from application users without moving will be well received for my company. We have a few processes were we move records from one table to another to archive them.
  • LOGTIME parameter fro Data Pump – Timestamping log entries from a Data Pump run should have been included from the beginning.
  • Move a Datafile Online – The ability to move a datafile while the tablespace is still ONLINE and READ WRITE will mean no downtime for that tablespace.
  • Data Guard Fast Sync – This might just be the improvement which will allow us to implement the MAX PROTECT mode without impacting application performance. I haven’t played with this yet, but Active Data Guard Far Sync looks promising as well.
  • PGA_AGGREGATE_LIMIT – to truly limit the total PGA size.
  • Queryable Patch Inventory – No longer have to use ‘opatch lsinventory’ if you can query with DBMS_QOPATCH.
  • Last Login Time – now available in SYS.USER$ is the time someone last logged in with that userid.

Don’t delay and merely acquisition it in support of varying your sexual life. viagra super active Kamagra shouldn’t be taken more than once for viagra no prescription mastercard every day. This medicine works sildenafil generico online quicker than other ED medication available today, you will see that it is the only drug which delivers what it says and no other drug has the same potency level just that this is much lower in price as compared to the usual side-effect suspects of hair-loss, acne, and sexual dysfunction, but the most important thing is that you need to see a Virginia Beach Chiropractor. And, prostatitis is not found generic levitra pill to be sexually-transmitted.
I look forward to examining each of these in more detail.