X

Multitenant delivers isolation, agility and economies of scale

Recent Posts

Configurable Isolation

Economies of scale through consolidation are of limited use if that consolidation comes at the expense of isolation. In 12.2 we introduce some very sophisticated capabilities in this area that can ensure great isolation between PDBs and avoid what is colloquially referred to as “the noisy neighbor problem”. Importantly, this is configurable so that the level of isolation can be tailored appropriately for the use case. In general when considering the topic of PDB isolation – one that is especially important in a highly consolidated environment such as a Database Cloud – we need to consider all of the potential risks of sharing. These fall into several categories: Contention for shared computing resources System access File system access Network access Common User or Common Object Access Administrative Features In 12.2 we build on what was already a powerful suite of isolation capabilities to deliver a comprehensive model, which can simply be configured to deliver precisely the appropriate level of isolation for a particular use case. These capabilities will be explored in more detail shortly, but before then it is important to understand why a “one size fits all” approach to isolation is not appropriate for the Database Cloud, and why the true requirement is configurable isolation. When considering this topic, it’s helpful to consider a familiar real-world analogy: residential security. At first thought, one might think that the more security the better, but in reality security is a trade-off with convenience. “Maximum Security” is a phrase associated more with a prison than with a home. A home might be more secure with bars on the windows, surrounded by a high wall topped with barbed wire, armed sentries and triple locks on a steel door, but it probably wouldn’t be very nice to live there. On the other hand, leaving all the doors and windows unlocked, while making it easy for the kids to come and go, is likely to result in loss of property. One tries to find the appropriate balance, and that balance will be different in different circumstances. In a dense city environment one is likely to take more precautions than in a suburb where the neighbors are better known. In small towns people sometimes don’t bother to lock at all. Everybody knows what everybody is doing. Security in business hotels is interesting to consider. There’s typically 24-hour security, with cameras in all common areas, security guards and sophisticated keys providing access to the guest rooms. Isn’t it interesting to think how alarming is the prospect that a guest in another room might have access to yours, yet we typically learn to have very little concern that the hotel staff have access to the room literally at countless times during the day without our knowledge (except that perhaps the beds are made and the bathroom is cleaned) and in general even when we’re in the room at night. Somehow in this situation it becomes perfectly acceptable to delegate security to the hotel management. Similar considerations apply to the Database Cloud in different use cases. In Database as a Service (DBaaS) on a Public Cloud, it’s reasonable to assume that “adjacent” tenants may be competitors. This is a particularly challenging use case because each tenant wants both powerful administrative capabilities within his own PDB, but also that this PDB is fully isolated from all PDBAs in adjacent PDBs. A good residential analogy here is condominium ownership. One wants full sovereignty over one’s own space. Everything on the inside of the front door is one’s responsibility. DBaaS on a Private Cloud is a very productive configuration for development teams. Each developer needs to be isolated from the others to the extent that one developer’s test does not interfere with another’s, but it’s typically a collaborative environment in which there is an expectation that everybody will respect everybody else’s environments. A good analogy here is sharing a large house with friends. Everybody has a key to the same front door and the individual bedroom doors are usually left unlocked. There are some common areas and common equipment but there’s a reasonable expectation of privacy in one’s own bedroom. Software as a Service (SaaS) may be compared to staying in a hotel. For the price of your room you delegate all maintenance and security to the hotel management and within reason expect them to respect the sovereignty of the contents of your room even though they have access more or less at any time. (Perhaps in this case we’d use the in-room safe to secure anything sensitive from the housekeepers.) Everyone understands that there are other guests in the hotel and there is a well-founded expectation that no guest from another room with have access to yours. It is with these considerations in mind that we designed a configurable isolation model for Multitenant. 

Economies of scale through consolidation are of limited use if that consolidation comes at the expense of isolation. In 12.2 we introduce some very sophisticated capabilities in this area that can...

Multitenant

Isolation and Agility with Economies of Scale

It’s not just about scale. Scale on its own can be viewed as a negative. As organizations scale beyond a single office, communication gets more difficult and you need more layers of management. It’s harder to be agile – analogies with turning around an oil tanker come to mind. These problems show how cost can increase exponentially with scale. With sophisticated automation, technologies associated with first-generation clouds can improve this cost model to a nearly linear function. Let’s consider a development environment, for example. To support ten developers, you might need ten virtual machines (VMs). To support twenty developers, you’ll need 20 VMs. There is an intrinsic cost to each VM, even if it’s not carrying any great workload. Hence the linear relationship between cost and scale. However, this was still an important step in the right direction. Oracle Multitenant is the architecture for the next-generation Database Cloud. Multitenant changes the situation completely. Multitenant delivers true economies of scale. The expensive model of a VM containing a database is replaced by a pluggable database (PDB). Because there is negligible intrinsic cost to a PDB, the cost of each developer’s PDB is reduced to the actual work they do. All developers’ PDBs can be consolidated into a single multitenant container database (CDB) and the costs of running that CDB can be shared among those developers. In terms of compute resources that’s because there’s a single set of background processes and a single shared memory area (the SGA). In terms of administration, that’s a single CDB to be backed up, configured for high availability, patched, etc. Economies of scale through consolidation are of limited use if that consolidation comes at the expense of isolation and agility. In the multitenant architecture of Oracle Database 12c Release 2 (12.2) we build on what was already a powerful suite of isolation capabilities to deliver a comprehensive model, which can simply be configured to deliver precisely the appropriate level of isolation for a particular use case. With great isolation it becomes realistic to consolidate at great scale because the individual workloads being consolidated do not interfere with each other. Agility puts in positive terms the avoidance of cumbersome consequences of consolidation conveyed by the analogy of turning the tanker. Scale can reduce unit costs through vast purchasing power but those gains are offset if scale comes at the expense of agility. In database terms, agility is about the speed and efficiency of creating, cloning (and even destroying) databases. It’s about moving them between servers, between data centers, between data centers and the Cloud, and moving them around in the Cloud. This can be for all sorts of reasons; as equipment is retired and replaced with capacity in the Cloud, for load balancing, for changing service levels or for handling peak loads. These are essential capabilities for the modern enterprise and the sophisticated functionality of Multitenant makes them as frictionless as possible. The key point about economies of scale is that if the savings outweigh the costs of scale, there is true return on investment. The beauty of Multitenant is that the economies of scale are so great that the return on investment is far more readily achieved than with other models. Multitenant delivers true economies of scale, and the two go hand-in-glove. Multitenant delivers isolation and agility with economies of scale.

It’s not just about scale. Scale on its own can be viewed as a negative. As organizations scale beyond a single office, communication gets more difficult and you need more layers of management. It’s...

Enough of the Oracle Guys!

I'm really pleased with how our sessions have gone this week. Thanks for all the supportive feedback! Yesterday we handed the reigns over to four great customers in the Multitenant Customer Panel, and we proceed in a similar vein today with three more Multitenant customers. Each has a different story to tell about their use of Multitenant. Each story is good! Grab an early lunch and head over to Park Central - Franciscan I for these three sessions. Bring a pad and a pen.  Multitenancy at Wells Fargo Bank [CON3139] Gerald Bowers, Database Administrator, Wells Fargo Michael Anderson, Database Administrator, Wells Fargo Thursday, Sep 22, 12:00 p.m. - 12:45 p.m. | Park Central - Franciscan I Migrating Oracle Real Application Clusters Databases to Oracle Multitenant [CON2718] David Hickson, Database Administrator, British Telecom Thursday, Sep 22, 1:15 p.m. - 2:00 p.m. | Park Central - Franciscan II Agile Development, Cost Saving, and More with Oracle's Multitenancy Solutions [CON1668] Alain Fuhrer, Oracle Database Administrator, Mobiliar Versicherungen AG Thursday, Sep 22, 2:30 p.m. - 3:15 p.m. | Park Central - Franciscan I As you can see, we've saved some of the best sessions for last, so be sure not to miss any of these! Here's a great link to our recommended sessions this week. Follow me  I tweet @OraclePDB #Multitenant #OOW16 +Patrick Wheeler

I'm really pleased with how our sessions have gone this week. Thanks for all the supportive feedback! Yesterday we handed the reigns over to four great customers in the Multitenant Customer Panel, and...

OOW Thursday - Caffeine and Adrenaline

Are your ears ringing after the Elton John show at Treasure Island? What a performance! Well, today it's back to Moscone for some database rock stars.  Demogrounds are closed now of course, and for the first year in several we don't have a Multitenant session on Thursday to close the show. I've got a packed agenda with customer meetings, but today's your last chance to catch our Hands-on Lab. It's fully booked but there's always a chance that someone doesn't show up, particularly at the end of the week, so if you want to get your hands dirty with Multitenant 12.2, pop over to the Nikko. You're looking for "HOL10485: Multitenant Hands-On Lab" at 11am. Remember, it takes about 15 minutes to walk over there from Moscone.  Have a great last day of OpenWorld!  We at Oracle all work extremely hard to prepare for OpenWorld. It's a privilege to be able to show off our technology and interact with so many thousands of customers, many of whom have come from far and wide to be with us for this big event. We're sincerely grateful. We hope that you have had an enjoyable time in beautiful San Francisco. It remains to wish you a safe journey home and every success with your deployment of Oracle Multitenant.  Full details of Multitenant sessions are available in the Focus On Multitenant page. Alternatively, if you're fed up with the stale old FoDs, check this one out.   Follow me  I tweet @OraclePDB #Multitenant #OOW15 +Patrick Wheeler

Are your ears ringing after the Elton John show at Treasure Island? What a performance! Well, today it's back to Moscone for some database rock stars.  Demogrounds are closed now of course, and for the...

Wednesday at OOW - Island Fever

If you've paced yourself properly you'll be nicely in your groove at OpenWorld by now, finally got your bearings at Moscone, moving smoothly between the sessions and the demo grounds. Today's the last day of DemoGrounds, remember. There are some great general sessions to look out for too. Here are my top recommendations for today.  At 12:15pm in Moscone South-308 (where else?) John McHugh's going to deliver his standing-room-only "CON6781: Oracle Multitenant: Best Practices". This one's a winner every year. The point is that it's the same abstract but always fresh content. The basic philosophy of our Best Practices is "this document is never finished." Come and hear John talk about some of the major lessons learned with some of our strategic customer deployments.  Grab a coffee and then head over to Moscone South - 301 (change of scene!) at 1:45pm for "CON8358: Oracle Multitenant: Customer Panel". I'm playing MC but you won't have to put up with much from me. We've got some top-notch speakers: Tom Bolick, Database Administrator, Cisco Systems Shravan Devulapalli, Principal Technologist, GE Alex Gorbachev, CTO, The Pythian Group Inc. Nataraj Hegde, Oracle Database Architech, Charles Schwab  You don't want to miss this one. After that, catch your breath and put on your party dress and dancing shoes. Hop on a bus to Treasure Island and enjoy the show that Elton John's going to put on. Still awesome after all these years. Full details of Multitenant sessions are available in the Focus On Multitenant page. Alternatively, if you're fed up with the stale old FoDs, check this one out.   Follow me  I tweet @OraclePDB #Multitenant #OOW15 +Patrick Wheeler

If you've paced yourself properly you'll be nicely in your groove at OpenWorld by now, finally got your bearings at Moscone, moving smoothly between the sessions and the demo grounds. Today's the last...

Cruise-day Tuesday

We're on a roll now, but I do confess it was tough to drag myself out of bed this morning after last night's hospitality event. It's great to hang out with our customers in a relaxed atmosphere. So many customers are going out of their way to say good things about their experiences deploying Multitenant and it's nice to be able to give a small amount back, in classic Oracle style. Oracle knows how to par-tay. I'm talking about one of dozens of events last night. If I didn't see you last night, I hope you had fun wherever you were - but not so much fun that you're not ready for today. 'Cos today's got some solid stuff coming too.  Deba Chatterjee is going to drill into the enhancements we've built into Multitenant in 12.2 specifically aimed at Software as a Service. And before you think "that's very interesting, but I'm not a SaaS company", you'd be surprised at how widely applicable the new Application Container technology is. If you run a car dealership, a fro-yo shop, maybe want to kick off a new coffee franchise business, we've got something for you here. Moscone South-308 is the venue again and the session is "CON8357: Oracle Multitenant: Ideal Architecture for World-Class SaaS". Be there at 12:15.I'm greatly looking forward to Larry's Tuesday keynote. On Sunday he promised that he would demonstrate moving a PDB to the cloud at the touch of a button, and without taking any application outage.   Charles Schwab and company are having some great success with their Multitenant deployment. I'm looking forward to hearing what Nataraj Hegde has to say about all this in my customer panel tomorrow, but now I'm getting ahead of myself. Today at 4pm in Moscone South-308 (Multitenant HQ!) Mark Meredith of Charles Schwab will present "CON5882 - Speed Up or Lag Behind: Charles Schwab Increases Agility with Private DBaaS" along with Oracle's Bob Ure. I had a chat with Mark the other day and this is a very interesting use case from a very serious business. These people do things right. You don't want to miss this one. Full details of Multitenant sessions are available in the Focus On Multitenant page. Alternatively, if you're fed up with the stale old FoDs, check this one out.   Follow me  I tweet @OraclePDB #Multitenant #OOW15 +Patrick Wheeler

We're on a roll now, but I do confess it was tough to drag myself out of bed this morning after last night's hospitality event. It's great to hang out with our customers in a relaxed atmosphere. So...

And we're under way!

We had to wait a few weeks more than usual but yet again the big show is on in San Francisco. Last year Larry made us wait until Tuesday's keynote to show off Multitenant, but it was worth the wait... Who can forget the demonstration of moving a PDB to the cloud at the touch of a button? Can he possibly top that? Well, maybe there are some tricks built into Oracle Database 12cRelease 2 (aka 12.2) which will allow him to do so. In yesterday's keynote he promised to demonstrate in his Tuesday keynote how to move a PDB to the cloud at the touch of a button... without taking any application outage! I know you gonna dig this. Well, today is the first full day of OpenWorld and we're already in top gear. Sunday's keynote always whets the appetite, and now you can explore the various general sessions, demo stations and hands-on labs to get some more in-depth insight into what's new with 12.2. (Hint: a lot!) I'd suggest starting with Andy Mendelson's general session, this morning at 11am in Marriott Marquis 7/8/9. The session is "GEN6765 Next-Generation Data Management Architecture". I've seen a preview of what Andy's going to announce and I've no idea how he's going to cram it all into one hour. Well, if I know one thing about Andy it's that he's not going to back down from a challenge. You don't want to miss this one, especially because he's going to talk about some of the goodies coming with Multitenant in 12.2. If there's time we'll even see a cameo appearance by my counterpart in development, Multitenant Architect himself, Kumar Rajamani. Kumar and I have to run out of Andy's session after it's over without delay - and so should you - because at 12:15pm back in Moscone South-308, we're doing our double-act for CON8356: Oracle Multitenant: the Road Ahead. I've been polishing these slides for a while and we should be in good shape. Stop by at the end to talk to Kumar and me. Several members of the development team will be on hand as well. It's always nice to hear your reaction after announcing new features.  Be sure to pace yourself during the day, because there's a great session at 5:15 in Moscone South-302. Kevin Hacker of Northern Trust will present "CON7527: Northern Trust’s Strategy for Adopting Multitenant as a Foundation for DBaaS" along with Oracle's Randy Swanson. We've been working closely with Northern Trust over the past few months on their rollout, which has been very smooth. They're taking a very interesting approach to this - all-Exadata, and Platinum tier systems first. Don't believe me? Check out the session. Two great speakers with a great story to tell. There's only one good excuse for missing Northern Trust's session and that is that you're going to hit the first of our Hands-on Labs. It's unfortunate that these clash but some things can't be helped. Much of the content of these labs is based on the on-site Beta we ran a few weeks ago. We've now announced the public availability of the 12.2 beta, so here's your chance to get a preview of some of the Multitenant goodies that you can try out when you download the beta for yourselves after the show's over. Full details of Multitenant sessions are available in the Focus On Multitenant page. Alternatively, if you're fed up with the stale old FoDs, check this one out.   Follow me  I tweet @OraclePDB #Multitenant #OOW15 +Patrick Wheeler

We had to wait a few weeks more than usual but yet again the big show is on in San Francisco. Last year Larry made us wait until Tuesday's keynote to show off Multitenant, but it was worth the wait......

IOUG 12 Months of DB12c / Arup Nanda

I recently did a joint presentation with Oracle Ace Arup Nanda as part of IOUG's "12 Months of Database 12c" series. (So we've just completed our seventh quarter since launching DB12c, but who's counting? Time flies, when you're having fun, after all!) As usual IOUG did a great job of setting this up. I like their introductory blurb, so here it is in their very words: You’ve heard about the multitenant feature of Oracle Database 12c, but why does it matter to your company? Lots of reasons. Join Oracle’s foremost Multitenant expert Patrick Wheeler, and Oracle guru Arup Nanda as they dig into the multitenant architecture, how it simplifies consolidation and enables DBaaS, how it can have a significant impact on the cost of delivering database services, and how your regular activities--backup, recovery, data guard, security, etc--will change after you change over to multitenant.  Featured Speakers:  Arup Nanda, Principal Database Architect at Starwood Hotels & Resorts Worldwide, Inc.;  Patrick Wheeler, Senior Director, Product Management, Oracle Corporation  I thought the presentation went very well. It was very interesting to hear Arup clearly explain how Starwood Hotels are using Multitenant to consolidate their Siebel databases. In case you missed it, or you can't get enough and want to hear it again, here's a link to the replay on the IOUG site.  Follow me  I tweet @OraclePDB #Multitenant #OOW14 +Patrick Wheeler

I recently did a joint presentation with Oracle Ace Arup Nanda as part of IOUG's "12 Months of Database 12c" series. (So we've just completed our seventh quarter since launching DB12c, but who's...

Thursday and We're Still Going Strong!

A final push to the finish line! If you went to Treasure Island for the party last night I hope you had a great evening. With luck, your ears aren't ringing too badly from the music so that you'll be able to hear the presentations today. It wasn't that many years ago that Thursday at OpenWorld was a slow day with not much going on. Those days are gone.  The Great Escape (from MS SQL Server)! Tom Michelini and OB Rashid were the drivers behind this great story. If you have any applications you'd like to upgrade from SQL Server to Oracle, don't miss this session. The way OB tells it: "I wish I'd had this paper before we started this project." (OK, we'd all like a time machine.) CON7307 Oracle Multitenant: Successful Migration of Oracle Taleo Business Edition Cloud Service. If you're looking for a way out of SQL Server, don't miss this one. 9:30am Moscone North - 130.I've been telling you all week about CON12068 Oracle Multitenant: Ask the Experts. That's today at 10:45! It was a late addition and didn't make it into the printed catalog, but it's on! Tweet your deep technical questions to our top developers - use #PDBexperts #OOW14. At noon in Moscone South - 308 I'll be joined by James Anthony of e-DBA for CON2785. James is an Oracle Ace and e-DBA are Engineered Systems Partner of 2014 in UK, EMEA and Globally (a sweep!). They're also one of the very first customers in production with Multitenant and now have over a year of production experience to share with you. It's a great story, which James tells very well. My job is to get the introduction over quickly so that you can hear from him.  Full details of Multitenant sessions are available in the Focus On Multitenant page.  Follow me  I tweet @OraclePDB #Multitenant #OOW14 +Patrick Wheeler

A final push to the finish line! If you went to Treasure Island for the party last night I hope you had a great evening. With luck, your ears aren't ringing too badly from the music so that you'll...

Wednesday is Customer Appreciation Day

Wednesday at OpenWorld tends to be the hardest one for me. There's been so much excitement already that it feels like the show's already run for a week, but we're barely half way through it. Today we've got a ton of great content during the day and they there's Aerosmith tonight on Treasure Island! (I'm going to catch up on sleep next week!) Before the party there are some great Multitenant sessions to focus on. I'm doing my "Multitenant: Seven Sources of Savings" talk at 10:15 in Moscone North - 130. Well make that seven plus a bonus... And then another bonus, which is that I'll be joined by Shravan Devulapalli who'll share details of how he was able to demonstrate these savings with his project team at GE.   We're very proud of the stunning success enjoyed by PulteGroup with their production deployment of Oracle Multitenant on Exadata. It's a true total solution story, including GoldenGate, Active Data Guard and a great project run by Oracle ACS along with members of my team. On the way, they upgraded to Exadata and saved $1.6m with Multitenant! Brian Pawlik of Pulte is a great guy and an excellent speaker. Don't miss this session: CON3203 Finding the Bleeding Edge Without Hemorrhaging. Moscone North - 130 at 3:30pm. At 4:45 in Moscone South - 307, come and learn about the Multitenant deployment at Sherwin-Williams.  Full details of Multitenant sessions are available in the Focus On Multitenant page. Don't forget to sign up for CON12068 Oracle Multitenant: Ask the Experts, Thursday at 10:45. It was a late addition and didn't make it into the printed catalog, but it's on! Tweet your deep technical questions to our top developers - use #PDBexperts #OOW14. Follow me  I tweet @OraclePDB #Multitenant #OOW14 +Patrick Wheeler

Wednesday at OpenWorld tends to be the hardest one for me. There's been so much excitement already that it feels like the show's already run for a week, but we're barely half way through it. Today...

Tuesday at OpenWorld... Pace Yourself!

Yesterday was a blur of activity - one of those days that went by in a flash but what happened in the morning feels like last week! Odd how that happens (or is it just me?) I'm feeling well and truly in the groove today, which is just as well because it's going to be another busy one. It's an early start to catch Thomas Kurian's keynote at 8am. Tough time of day but don't miss it. There's been a lot of buzz around HQ in the last few weeks about all the demos Thomas is going to do. I've no idea how he manages it - seeing is believing.  Larry Ellison's second keynote is at 1:30. If Larry's Sunday keynote is packed, this one will be overflowing. Do try to get a seat in there, though, because there's going to be a great demo of my favorite product. I've seen previews and this one is very cool.  No pressure, then, for Maria Colgan and me as we present "Multitenant Meets Database In-Memory" at 5pm in Moscone South 5pm. We're hoping that Thomas and Larry left you wanting more! Full details of Multitenant sessions are available in the Focus On Multitenant page. Don't forget to sign up for CON12068 Oracle Multitenant: Ask the Experts, Thursday at 10:45. It was a late addition and didn't make it into the printed catalog, but it's on! Tweet your deep technical questions to our top developers - use #PDBexperts #OOW14. Follow me  I tweet @OraclePDB #Multitenant #OOW14 +Patrick Wheeler

Yesterday was a blur of activity - one of those days that went by in a flash but what happened in the morning feels like last week! Odd how that happens (or is it just me?) I'm feeling well and truly...

OOW14 In Full Swing

Need to make sure I get to Caltrain in plenty of time because we're getting a very fast start to OpenWorld today!  We got our Demo Booth all set up yesterday and it looks great. I thought we did a decent job last year but this year it's even better. There are lots of great sessions today and an excellent place to start as always will be Andy Mendelsohn's keynote. Of course he's got lots of good stuff to share about Multitenant, Database In-Memory and the rest of Database 12c.  That puts the pressure on me to follow his show with my own first session (of five!) - CON7302 Multitenant New Features. There's lots of good new stuff in 12.1.0.2. Join me in Moscone South 102 and I'll tell you all about it. Barely time for a cup of coffee as I join Randy Wilcox of SAS OnDemand to talk about SaaS at SAS. Ahem. Bad pun, great implementation story. SAS is a great company and you don't get as far as they have without looking after your customers' data. That's why they turned to Multitenant on Exadata for their OnDemand offering. Listen as Randy shares the details in Moscone South -130.   Head back to Moscone South - 102 at 2:45 and hear John McHugh talk about Multitenant Best Practices. You know it's going to be packed in there - don't be late. There may be time for a brief refreshment before heading over to Moscone South - 301 to hear the success story of a major international health insurer. It's projects like this where John McHugh has developed his best practices.  Full details of Multitenant sessions are available in the Focus On Multitenant page. Don't forget to sign up for CON12068 Oracle Multitenant: Ask the Experts, Thursday at 10:45. It was a late addition and didn't make it into the printed catalog, but it's on! Tweet your deep technical questions to our top developers - use #PDBexperts #OOW14. Follow me  I tweet @OraclePDB #Multitenant #OOW14 +Patrick Wheeler

Need to make sure I get to Caltrain in plenty of time because we're getting a very fast start to OpenWorld today!  We got our Demo Booth all set up yesterday and it looks great. I thought we did a...

Multitenant Sessions by Oracle at OOW14

In yesterday's post I mentioned some of our customers' sessions at OpenWorld. They're going to be very interesting - if you have a chance, please try to catch some of them. Today, however, I want to focus on Multitenant sessions by Oracle speakers.  CON7674 Maximum Availability with Oracle Multitenant: Seeing is Believing Mon 11:45 Moscone South - 104 Frank Kobylanski and Joe Meeks are two of our top experts on MAA  CON7302 Oracle Multitenant: What's New in Oracle Database 12c Release 12.1.0.2? Mon 1:30pm Moscone South - 102 Patrick Wheeler is Senior Director, Product Management for Oracle Multitenant CON7303 Oracle Multitenant: Best Practices Mon 4pm Moscone South - 102 John McHugh is Senior Principal Product Manager for Oracle Multitenant and learned this stuff in the trenches CON7305 Oracle Multitenant: The Beating Heart of Database as a Service Tue 10:45 Moscone South - 102 Deba Chatterjee is Principal Product Manager, Oracle Multitenant and has a strong background in OEM too. I've had a preview and this will be a great session which will leave your mouth watering. You'll know what I'm talking about after you've been there! CON7648 How an Oracle Database 12c Upgrade Works in a Multitenant Environment Tues noon Moscone South - 306 Joseph Errede will tell you the ins and outs of the Multitenant upgrade story, and there's lots of cool stuff to tell! CON7435 Supercharge Oracle Application Express with Oracle Multitenant Tues noon Moscone South - 307 David Peake will be competing for Multitenant attention with Joe Errede next door at the same time! David's an APEX guru and most APEX experts will still have a few things to learn from him.  CON7306 Oracle Multitenant Meets Oracle Database In-Memory Tues 5pm Moscone South - 102 Maria Colgan & Patrick Wheeler will explain how these two flagship products work (better!) together CON7304 Oracle Multitenant: Seven Sources of Savings Weds 10:15am Moscone North 130 Patrick Wheeler's going to have to talk fast to get through all of these in half an hour and leave enough time to hear from Shravan Devulapalli about how the theory translated into reality for him and his team at GE. CON7649 How and Why to Migrate from Schema Consolidation to Pluggable Databases Weds 11:30 Moscone South - 306 Dean Gagne will go beyond the obvious answers - "easily" and "now" - to explain how to make this leap. CON7307 Oracle Multitenant: Successful Migration of Oracle Taleo Business Edition Cloud Service Thu 9:30am Moscone North - 130 The Great Escape (from MS SQL Server)! Tom Michelini and OB Rashid were the drivers behind this great story. If you have any applications you'd like to upgrade from SQL Server to Oracle, don't miss this session. The way OB tells it: "I wish I'd had this paper before we started this project." (OK, we'd all like a time machine.) CON6990 How to Best Consolidate and Live-Migrate Databases with Oracle Multitenant Thu 10:45am Intercontinental B Nicolas Michael and Yixiao Shen were behind the famous Multitenant on T5-8 scalability study, and along with Bryan O-blanguet will explore this important approach to maintaining application continuity during unplug/plug. CON12068 Oracle Multitenant: Ask the Experts Thu 10:45 Moscone South - 308 Kumar Rajamani, Jaebock Lee and Thomas Baby are three of the lead developers of Multitenant. If you want to know how it really works, these are the guys to ask. (They're the guys I ask!) We're live-tweeting questions for the session - use #pdbexperts #OOW14 Full details are available in the Focus On Multitenant page. We hope to see you at OpenWorld. It's going to be a great show! Follow me  I tweet @OraclePDB #Multitenant #oow14 +Patrick Wheeler

In yesterday's post I mentioned some of our customers' sessions at OpenWorld. They're going to be very interesting - if you have a chance, please try to catch some of them. Today, however, I want...

Multitenant Customer Sessions at Oracle OpenWorld

Oracle OpenWorld is nearly upon us and the agenda is packed with interesting sessions. Prominent among these are several sessions by customers who are able to share their stories of success with Oracle Multitenant. Please try to attend these sessions and hear how they have been able to benefit from Multitenant in their organizations: SAS Institute CON6328 SAS Solutions OnDemand: A Multitenant Cloud Offering  Mon 2:45pm Moscone North 130 Major International Health Insurer CON6379 Oracle Multitenant Customer Success Story Mon 5:15pm Moscone South 308 GE Aviation CON7304 Oracle Multitenant: Seven Sources of Savings Weds 10:15am Moscone North 130 Pulte Group CON3203 Finding the Bleeding Edge Without Hemorrhaging Wed 3:30pm Moscone North 130 Sherwin-Williams CON6387 Oracle Multitenant Deployment on Oracle Exadata Weds 4:45pm Moscone South 307 Taleo CON7307 Successful Migration of Taleo Business Edition Cloud Service Thurs 9:30am Moscone North 130 e-DBA CON2785 Rolling Out a PaaS with Oracle Multitenant Thurs noon Moscone South 308 We're very proud of Oracle Multitenant and the benefits it can deliver. It's always great to hear from our customers that they have been able to realize these benefits in their organizations.  There are plenty more sessions about Multitenant and I'll mention them in a future blog. Full details are available in the Focus On Multitenant page. We hope to see you at OpenWorld. It's going to be a great show! Follow me  I tweet @OraclePDB #Multitenant #oow14 +Patrick Wheeler

Oracle OpenWorld is nearly upon us and the agenda is packed with interesting sessions. Prominent among these are several sessions by customers who are able to share their stories of success...

Single Tenant Configuration

In Oracle Database 12c, Multitenant is a pure deployment choice. It is possible to upgrade from, say, Oracle Database 11g to Oracle Database 12c, non-CDB and stop there. Of course I wouldn't recommend it! I would encourage every customer to take the next step and adopt that database as a PDB by plugging it into a CDB. Note that if that is the only PDB plugged into the CDB this is what we call the single tenant configuration (using the multitenant architecture). The single tenant configuration does not require nor trigger the Multitenant licensed option.  So, in summary, with Oracle Database 12c you have three choices: Non-CDB (the old architecture). Multitenant architecture in single tenant configuration (one PDB per CDB). No license required. Multitenant architecture with multiple PDBs per CDB. Requires licensed option but of course you can manage many as one and get all the other benefits. An interesting question of course is, what's the point of the single tenant configuration? Well, there are still some advantages: You will be able to upgrade (beyond 12.1.0.1 - say to 12.1.0.2) via unplug/plug, which we expect to be significantly faster than a "full upgrade". Unplug/plug has intrinsic value as what my colleague, Distinguished Product Manager Bryn Llewellyn (author of the excellent Multitenant White Paper), calls "Third generation Data Pump". In other words, if Data Pump (using "full database" exp/imp) is valuable (and we must assume that it is!) then unplug/plug is yet more valuable for the same use cases. This by no means implies crossing Oracle Database software version. But that is among the use cases (also for Data Pump, of course). You can clone from a PDB in a single tenant configuration CDB into a different, as yet empty, CDB. It enforces the "separation of duties" between the CDB Admin and the PDB Admin. Eventually there will only be one architecture and if you don't pay for the Multitenant option you'll have to run in single tenant configuration. Get used to it now! Each of these is an advantage over the non-CDB architecture. What I like about the single tenant configuration is that, even without requiring a license, it demonstrates a few of the key benefits of the new multitenant architecture. In this way customers can become confident of the new capabilities at no cost. Of course many of the key cost-savings benefits - CapEx reduction by consolidating multiple applications per server and OpEx reductions by managing many as one (retaining granular control where appropriate) only come from the true multitenant use case. But the single tenant configuration is a great way to dip one's toes in the water. Follow me  I tweet @OraclePDB #OracleMultitenant +Patrick Wheeler

In Oracle Database 12c, Multitenant is a pure deployment choice. It is possible to upgrade from, say, Oracle Database 11g to Oracle Database 12c, non-CDB and stop there. Of course I wouldn't recommend...

How Many CDBs?

Fact: A CDB can contain up to 252 PDBs.  Trick question: If I have 200 PDBs, how many CDBs do I need?  Easy, right? One CDB!  Wrong! (At least, probably!)  With Multitenant, we can plug many PDBs into a single CDB, sharing overheads of background processes and SGA. This can increase hardware utilization - dramatically in some cases - and so reduce capital expenses by supporting more applications per server. Great! But wait, there's more! We also reduce operating expenses by managing many as one. But that doesn't mean that you should only have one CDB. In fact, we think you're likely to want several. Let me explain.  I've talked to a lot of customers in the last few weeks about their consolidation plans - specifically using Multitenant, of course. For a few there has been a hesitation… "We don't want to consolidate all these applications because we don't want our air traffic control app running alongside our eBusiness Suite and certainly not alongside all those smaller departmental apps!" "Well," I tell them, "that's ok. I probably wouldn't want to do that either - at least that's not where I'd start my consolidation project!" I've also heard a complaint that "this 'manage many as one' business is too inflexible. Why can't I configure NOARCHIVELOG mode at a PDB level?" Those apparently unrelated concerns end up with the same answer: It's ok to have more than one CDB! A prominent reason to have more than one CDB is to support different Service Level Agreements (SLAs). SLAs typically include specifications of availability and recoverability; things which tend to correspond to Oracle options such as Real Application Clusters (RAC), Active Data Guard (ADG) or perhaps settings like ARCHIVELOG mode (my customer's question above). Remember that with Multitenant these things are defined at the CDB level and all PDBs plugged into the CDB inherit these characteristics. This is the "manage many as one" message. So you'd typically have at least one CDB per SLA. Perhaps you'd have a CDB configured for your "Bronze" SLA with weekly full RMAN backups. For your "Silver" SLA you might have a CDB with Active Data Guard and daily incremental backups. (Of course there'd be a corresponding CDB on the standby side.) For the "Gold" SLA maybe you'd have all that and Real Application Clusters (RAC) as well for even higher availability and scalability. Of course you could configure additional CDBs to support any number of SLAs but in general you'd want to standardize on a few.  With Multitenant, don't think in terms of configuring these things at the application database level. Instead think in terms of the SLA requirements of the application and plug the application's PDB into the appropriate CDB to achieve the required SLA. It's so much easier because there are far fewer moving parts. Of course you can easily unplug/plug to move the PDB to a different CDB if the SLA requirements change! Besides supporting various SLAs, here are some other reasons you'd want to create additional CDBs. (Active) Data Guard - one primary CDB and one standby CDB One for each combination of incompatible system parameters (Oracle version, character set, endianness…) One spare for each CDB above, for patching/upgrading via unplug/plug One for low throughput (but still business-critical) applications; one (in single-tenant configuration) for each mission critical one (and maybe one for a few medium-scale apps) So you could easily end up with one or two dozen CDBs - and you'd be doing it right. Of course you'd still be getting the benefit of Multitenant because companies with a legitimate need for this many CDBs are used to managing hundreds of databases... some of our customers have thousands of them! With Multitenant, by using this approach, this nightmare is replaced by the relatively simple requirement to manage a few groups.  I really like the message "manage many as one" but perhaps I should be looking for a new slogan... Entries on a postcard, please. Follow me  I tweet @OraclePDB #OracleMultitenant +Patrick Wheeler

Fact: A CDB can contain up to 252 PDBs.  Trick question: If I have 200 PDBs, how many CDBs do I need? Easy, right? One CDB!  Wrong! (At least, probably!)  With Multitenant, we can plug many PDBs into a...

Introducing Oracle Multitenant

The First Database Designed for the Cloud Today Oracle announced the general availability (GA) ofOracle Database 12c, the firstdatabase designed for the Cloud. Oracle Multitenant, new with Oracle Database12c, is a key component of this – anew architecture for consolidating databases and simplifying operations in theCloud. With this, the inaugural post in the Multitenant blog, my goal is tostart the conversation about Oracle Multitenant. We are very proud of this newarchitecture, which we view as a major advance for Oracle. Customers, partnersand analysts who have had previews are very excited about its capabilities andits flexibility. This high level review of Oracle Multitenant will touch onour design considerations and how we re-architected our database for the cloud.I’ll briefly describe our new multitenant architecture and explain it’s keybenefits. Finally I’ll mention some of the major use cases we see for OracleMultitenant. Industry Trends We always start by talking to our customers about thepressures and challenges they’re facing and what trends they’re seeing in theindustry. Some things don’t change. They face the same pressures andthe same requirements as ever: Pressure to do more with less; be faster,leaner, cheaper, and deliver services 24/7. Big companies have achieved scale.Now they want to realize economies of scale. As ever, DBAs are faced with the challenges of patching and upgrading large numbers of databases, and provisioning new ones.  Requirements are familiar: Performance, scalability,reliability and high availability are non-negotiable. They need ever more securityin this threatening climate. There’s no time to stop and retool with newapplications. What’s new are the trends. These are the techniques to useto respond to these pressures within the constraints of the requirements. Withthe advent of cloud computing and availability of massively powerful servers –even engineered systems such as Exadata – our customers want to consolidate manyapplications into fewer larger servers. There’s a move to standardized services– even self-service. Consolidation Consolidation is not new; companies have tried variousdifferent approaches to consolidation of databases in the cloud. One approach is to partition a powerful server betweenseveral virtual machines, one per application. A downside of this is that youhave the resource and management overheads of OS and RDBMS per VM – that is,per application. Another is that you have replaced physical sprawl with virtualsprawl and virtual sprawl is still expensive to manage. In the dedicated database model, we have a single physicalserver supporting multiple databases, one per application. So there’s a sharedOS overhead, but RDBMS process and memory overhead are replicated perapplication. Let's think about our traditional Oracle Database architecture.Every time we create a database, be it a production database, a development ora test database, what do we do? We create a set of files, we allocate a bunchof memory for managing the data, and we kick off a series of backgroundprocesses. This is replicated for every one of the databases that we create. Asmore and more databases are fired up, these replicated overheads quicklyconsume the available server resources and this limits the number ofapplications we can run on any given server. In Oracle Database 11gand earlier the highest degree of consolidation could be achieved by what we callschema consolidation. In this model we have one big server with one bigdatabase. Individual applications are installed in separate schemas ortable-owners. Database overheads are shared between all applications,which affords maximum consolidation. The shortcomings are that applicationchanges are often required. There is no tenant isolation. One bad apple can spoil thewhole batch. New Architecture & Benefits In Oracle Database 12c, we have a new multitenantarchitecture, featuring pluggable databases. This delivers all the resourceutilization advantages of schema consolidation with none of the downsides.There are two parts to the term “pluggable database”: "pluggable", which is new, and "database", which is familiar.  Before we get to the exciting new stuff let’s discuss whathasn’t changed. A pluggable database is a fully functional Oracle database.It’s not watered down in any way. From the perspective of an application or anend user it hasn’t changed at all. This is very important because it means thatno application changes are required to adopt this new architecture. There aremany thousands of applications built on Oracle databases and they are all readyto run on Oracle Multitenant. So we have these self-contained pluggable databases (PDBs),and as their name suggests, they are plugged into a multitenant containerdatabase (CDB). The CDB behaves as a single database from the operations pointof view. Very much as we had with the schema consolidation model, we only havea single set of Oracle background processes and a single, shared databasememory requirement. This gives us very high consolidation density, which affordsmaximum reduction in capital expenses (CapEx). By performing managementoperations at the CDB level – “managing many as one” – we can achieve greatreductions in operating expenses (OpEx) as well, but we retain granular controlwhere appropriate. Furthermore, the “pluggability” capability gives usportability and this adds a tremendous amount of agility. We can simply unpluga PDB from one CDB and plug it into another CDB, for example to move it fromone SLA tier to another. I'll explore all these new capabilities in much more detail in a future posting.  Use Cases We can identify a number of use cases for Oracle Multitenant.Here are a few of the major ones. Development /Testing where individualengineers need rapid provisioning and recycling of private copies of a few"master test databases" Consolidation ofdisparate applications using fewer, morepowerful servers Software as aService deploying separatecopies of identical applications to individual tenants Database as aService typicallyself-service provisioning of databases on the private cloud ApplicationDistribution from ISV / Installation by Customer Eliminating manytypical installation steps (create schema, import seed data, import applicationcode PL/SQL…) - just plug in a PDB! High volume datadistribution literally via diskdrives in envelopes distributed by truck! - distribution of things like GIS orMDM master databases …various others! Benefits Previous approaches to consolidation have involved atrade-off between reductions in Capital Expenses (CapEx) and Operating Expenses(OpEx), and they’ve usually come at the expense of agility. With Oracle Multitenantyou can have your cake and eat it: Minimize CapEx More Applications per server Minimize OpEx Manage many as one Standardized procedures and services Rapid provisioning Maximize Agility Cloning for development and testing Portability through pluggability Scalability with RAC Ease of Adoption Applications run unchanged It’s a pure deployment choice. Neither the database backendnor the application needs to be changed. In future postings I’ll explore various aspects in moredetail. However, if you feel compelled to devour everything you can aboutOracle Multitenant this very minute, have no fear. Visit the Multitenant page on OTN and explore the various resources we have available there. Amongthese, Oracle Distinguished Product Manager Bryn Llewellyn has written anexcellent, thorough, and exhaustively detailed White Paper about OracleMultitenant, which is available here.  Follow me  I tweet @OraclePDB #OracleMultitenant +Patrick Wheeler

The First Database Designed for the Cloud Today Oracle announced the general availability (GA) of Oracle Database 12c, the firstdatabase designed for the Cloud. Oracle Multitenant, new with Oracle...

Oracle

Integrated Cloud Applications & Platform Services