The pluggable database is inherently more efficient for a number of reasons, Rajamani later explained. Today, a server running 100 databases must switch rapidly between all those databases, which creates a lot of overhead. "A hundred binaries are going to 100 context switches," he said. A single database eliminates all this task switching. Also, each database has a large number of background processes that need to run continuously, and reducing all of these processes to a single set saves resources.
Also, having a single copy of database software to handle multiple user databases reduces the amount of disk space needed, since it eliminates the multiple copies of the host database software. (Oracle did not disclose how this new architecture would affect licensing costs.)
In the past, organizations have tried to consolidate their data onto a single database, but they may have encountered a number of difficulties. For one, they may have run into namespace problems, where the names of columns of one user database table may be identical to those in another, which then must be reconciled on an individual basis. Also, it is difficult to effectively control access to multi-use databases. Different users require different tables, but establishing access rights for each user at the database level can be a time-consuming and error-prone process.
The pluggable database architecture could solve these problems, however. In separate user databases, the namespaces would be entirely independent of one another, so duplicate names would not be a problem. It also solves the access problem. Oracle is promising that the separation between two pluggable databases will be as strong as the separation between two totally independent databases today.
Pluggable databases will also make upgrades and database transfers between machines more efficient, Oracle argued. As the name implies, pluggable databases could be easily decoupled from the container database. A user database can be cleanly moved from one copy of Oracle 12c to another copy of Oracle 12c. Also, Oracle is updating its Enterprise Manager and other database management software so it can allow administrators to apply changes across multiple user databases through a single action.
Upgrading Oracle 12c and subsequent editions should be easier as well. An administrator can install the new copy of the database and then, in a single operation, switch all the pointers in the user databases to the new copy on the root database, an operation that should take only a few seconds. Upgrading the database software is "1,000 times faster, because you are just updating the metadata," Rajamani said.
The pluggable approach also allows easy database cloning, which should simplify back-up operations as well as give developers an easy way to test new products against an identical copy of a working database.
Attendees of the sessions seemed excited about the changes for the most part, although they peppered the speakers with questions to learn as much as they could.
Ajai Gupta, a network manager at NetApp, praised the new architecture, noting that organizations are increasingly using a single database for multiple applications, which requires a lot of security management at the application and networking layers. This approach also makes it more difficult to move databases from location to location. The pluggable architecture "provides continuity across clouds and data centers," he said.
Gupta did note that the new architecture would also raise a number of challenges. Organizations may have to rethink how to allocate computational resources, he said. Database administrators will have to determine the new workload characteristics of running multiple databases on a single server. The optimum size of a server, in reference to memory and storage space, may also need to be reconsidered.
"Databases coming from separate servers to one server will pose some challenges in performance management," Gupta said.