Oracle 12c Multitenant workshop – Bangalore chapter

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!!



Oracle 12c Technical Hands-On Workshop

I have been running many tech events and briefings on Oracle 12c for India Partners. This time around, I thought of posting my latest event reviews.

This week, I wrapped up the Oracle 12c Technical Hands-On workshop in Oracle facility, Gurgaon. It was a 2-day event from Oracle Database Product Management. The focus of the workshop was primarily on Oracle 12c Multitenant architecture along with the hands-on labs using a virtualbox image. The audience was comprised of the representatives from the key Oracle partners in the NCR area. I appreciate their interest and in spite of odds like the last night rain and massive traffic, they showed up in time. I was the lead instructor for this event along with my senior colleague Mr. Rick Pandya. Thanks to Rick who has flown from Chicago, to be with me for several partner events in India.

Here was the agenda of the workshop –

  • Introduction to Oracle 12c Multitenant Architecture
  • Administration and Management of Multitenant Databases
  • Cloning, Consolidation, Relocating, Backup/Recovery, Security
  • Migrating to Multitenant Architecture
  • Upgrading to 12c CDB using DBUA
  • Performance Monitoring and Resource Management
  • Heat Maps and ILM, Temporal Validity, In-Database Row archiving

For all reasons, Multitenant was the focus and area of interest. Certain excerpts like share-able components of a Container Database, PDB provisioning, remote cloning, spfile, control file and common users were the area of exploration. Some of the folks were good to find that – in a pluggable container, the instance name (from V$INSTANCE) and db name (from V$DATABASE) appears to be the container name because of the obvious reasons.

The real challenge was the hands-on part of the workshop where the participants were required to carry the high-end configuration laptops, but only few of them could manage it. An 8G laptop with 100G of space was expected to run the exercises on database upgrade, backup and migration. We gave a shot by trimming the vbox image to run on 4G lappe. It did worked but host OS performance was in a toss.

My next stop is in Chennai where I’ll be driving this event for specific Partners. See you all 🙂

Saurabh K. Gupta