Oracle 12c helps developers
I’m super excited about two aspects of 12c (among many). First is Oracle 12c EM Express which gives light weight access to Oracle performance information without all the agents and heavy infrastructure. You basically just point a browser at the database via a setup port and voila. Since EM Express has limited functionality but gives powerful insight into performance on the database it’s perfect for developers to use and see the impact of their code in the databases where they are running their code.
The other feature in 12c that is exciting is pluggable databases. Why? Because for me as someone who clones 100s to 1000s of databases using virtual databases via Delphix where creating a clone is 4 clicks of a mouse, almost no storage usage and takes a few minutes, it means I can clone more databases. Why? Because each of these “free” virtual databases I create with Delphix still creates it’s own SGA which is at a minimum about half a gigabyte. Now with pluggable databases that will go down to about 100 megabytes or 1/5 the size, which means I’ll be able to put a couple of hundred Delphix virtual databases on a machine thanks to Oracle pluggable databases.
What does all this mean? It means that each developer can have their own full copy of production with a shared disk foot print, a shared memory caching footprint (only available in Delphix) and shared SGA components and instance processes. On top of that the developers can get clear and powerful views into the impact of the code they run on their databases.
Have an article in the latest Oracle magazine, but don’t see a way to link the article in so here it is. There is also a video that goes along with the article at the bottom of this post.