Kyle Hailey knows that the relationship between DBAs and developers can be rocky. But new capabilities in Oracle Database 12c have the potential, he says, to smooth things out. I ran into Hailey, a DBA and Oracle ACE, at the 2013 ODTUG Kscope13 conference as he was preparing to lead a session for application developers. “I want to show developers how to tell if their SQL statements are tuned well or not,” says Hailey. “I can show them how they can see the effect of their code before a DBA comes to yell at them for negatively impacting database performance.”
Oracle Database 12c introduces an administration console called Oracle Enterprise Manager Database Express, a “light” version of Oracle Enterprise Manager that developers can access through a browser. “Now DBAs can give the developers read-only access to a simplified database management console so they can see the impact of their code,” says Hailey.
This is a big change from the traditional setup, where the effect of code was seen only in the DBA’s world. “The DBA has this privileged access to see what’s happening with the database,” Hailey says. “He can see load go up and see who caused it, but the poor developer writes some code, runs some code, and maybe sees some text on a screen—but there’s no visual impact. The developer doesn’t know what’s going on in the database, and that’s not fair. The DBA comes and complains that the developers are making a mess, and the developer says, ‘How am I supposed to know?’ With [Oracle Enterprise Manager Database Express], developers will be able to see the effect of their code and, if there’s a problem, shut it down before the DBA comes calling.”
Oracle Database 12c offers a new architecture and database option called Oracle Multitenant, which Hailey thinks will improve his day—and his relationship with developers. His work includes cloning databases, he explains, and “every time I start a clone I’m taking up memory resources, and I can only put so many clones on a machine. Now with Oracle Multitenant I can put up to 250 clones on a single machine.”
In Oracle Database 12c, each clone is a pluggable database, which plugs into a container database. “I can manage a bunch of pluggable databases through a single container database,” he says. “The [Oracle Multitenant option] means I’m going to need less time to manage the database, and I’ll need less hardware because I can consolidate. I can take databases off a bunch of disparate machines and put them on a single machine in a single container database.”
More importantly for his relationship with developers, Oracle Multitenant will help Hailey serve them faster. “If I’ve got developers sharing a database, I can’t change the schema for one of them, because it might impact another developer—so it takes a week to get sign-off that a change doesn’t affect anybody else,” says Hailey. “But now with Oracle Multitenant, I can spin up these pluggable databases right away and developers can get their own copies, make all the changes they want, and then create a merged copy in the end.”
With Oracle Database 12c, developers get a faster, smoother database as a service from Hailey through Oracle Multitenant, and Hailey gets better code against his database from developers, who can see the effects of their code by using Oracle Enterprise Manager Database Express. Thanks to Oracle Database 12c, this relationship just might work out.
Photography by Jakob Owens, Unsplash
Jeff Erickson is content strategist for database and data-driven innovation at Oracle. An award-winning script writer and columnist, Erickson is a former editor of Database Insider News and has more than 15 years of experience writing for and about the smart, curious people who keep our digital world humming.