Thanks to all folks who attended Oracle 12c Multitenant workshop in Bangalore. It was really a great session and well received by all the participants. I appreciate all your interests to know about Multitenant, play with the new architecture and explore the changes.
Few points to make note from this event –
1. The question ‘Oracle 12c Multitenant exposes a single point of failure’ is not new to me. This is the very first question whenever I start with any of the 12c briefing. Excellent question – but first understand and know the point of failures. Oracle 12c architecture doesn’t plays with the database rules but make organizational changes. The system metadata or the system component of the database has been fixed at the container level and it is sharable across all your pluggable databases. System components are nothing but the one which build up your instance i.e. SGA, background processes, control file, spfile and yes, redo logs and undo tblsp. You can always multiplex control file and redo logs. When you consolidate multiple application databases onto a single bench, wouldn’t you think of a DR setup? Shouldn’t you have a standby site for container? Think again from a manageability perspective, Multitenant in Oracle 12c offers you ‘Manage many as ONE’ capability and at the same time, gives you the liberty to control individual pieces at their level. For example, you can backup your whole container but still do a PITR at PDB level. A new PDB on primary container will be auto-discovered at your standby site. You can patch multiple pluggable containers in a single action by simple patching the container db. Once again, think what you buy from your investments.
2. Cloning the pluggable databases is an interesting feature – Oracle 12c supports snapshot copy feature on copy-on-write supported filesystems. Right now, Netapp, ACFS and ZFS support copy-on-write feature. On the normal filesystem, net time consumed in the cloning activity is the total time taken in copying the data files from one location to the new location.
3. Surprisingly, only few knew about Oracle’s advanced compression. Oracle 12c brings in new concepts of Heat Map and ADO to perform compression and storage tiering. One must try these features out to know more about these powerful features. Arguments like other storage subsystems do perform archival and compression strategies, but understand that these storage subsystems are not aware of your data. Beauty of heat-map and ADO lies in the fact that your tiering policies are now data aware. Based on the age of the data i.e. its relevance to the application and business, you can compress the data using different techniques and optionally, move it to a low cost storage.
Overall, I found these two days interactive enough to understand your view thoughts on Oracle 12c. I know everybody can’t be the candidate for cloud or consolidation right away – but one must keep on exploring opportunities. What Oracle 12c offers is better manageability. You can start with single-tenant and easily move to multitenant as in when the business comes in. Apart from Multitenant, there are many other areas to explore like GDS, Data Guard, Flex clusters and ASM, Security and Compression. Alright, that’s all I had to share with you all. See you in future again!!