Database management system questions answers // IT Management Solutions

Database management system questions answers

Since the launch of Oracle Enterprise Manager 12 Release 3, we have received tons of questions around managing Oracle Multitenant, an Oracle Database 12 Enterprise Edition option, and pluggable databases (PDBs)—more specifically; questions about pluggable database as a service (PDBaaS). In this blog, we provide answers to some of the common questions from people.

Question: What qualifies a database to be pluggable?
Answer: A pluggable database must be a current Oracle Database 12c database, configured for multitenant through a new enterprise edition option called Oracle Multitenant. It delivers a new architecture that allows a multitenant container database (CDB) to hold many pluggable databases (PDBs). An Oracle Database in the old architecture (a “non-CDB”) may be upgraded to the multitenant architecture via a simple process known as “adopting the non-CDB as a PDB”. A PDB is a self-contained, fully functional Oracle Database, and includes its own system, sysaux and user tablespaces. You can learn more about Oracle Multitenant and pluggable database in this whitepaper.

Can the pluggable databases be plugged and unplugged across multiple platforms such as Solaris, AIX, and Linux?
The pluggable database must be endian compatible. Cross endian operations require OGG, Data pump or restore from backup.

In terms of database consolidation, what are the differences between using VMs, dedicated schemas and pluggable databases?
To describe the advantages of using pluggable database vs. other consolidation methods, it can be best illustrated in a simply comparison table.

Comparison of Database as a Service Consolidation Models

Pluggable database combines the best of all the other models and offers excellent consolidation, isolation, manageability and is suitable for any application that is certified to run on Oracle Database 12c. With the other models, we see certain shortcomings. For example, server virtualization offers good isolation but creates compliance and administrative headaches. Schema based consolidation offers ease of management and patching, but limited isolation.

You might also like

Internet Domain Name Functions

by gnostic2012


March 14, 2014
NTIA Announces Intent to Transition Key Internet Domain Name Functions

To support and enhance the multistakeholder model of Internet policymaking and governance, the U.S. Commerce Department’s National Telecommunications and Information Administration (NTIA) today announces its intent to transition key Internet domain name functions to the global multistakeholder community.
As the first step, NTIA is asking the Internet Corporation for Assigned Names and Numbers (ICANN) to convene global stakeholders to develop a proposal to transition the current role played by NTIA in the coordination of the Internet’s domain name system (DNS)

Cengage Learning Database Systems: Design, Implementation, and Management (with Premium Web Site Printed Access Card)
Book (Cengage Learning)
  • Used Book in Good Condition

互联网时代的网络自动化运维  — 中关村在线
CMDB(Configuration Management Database) 配置管理数据库(以下简称:CMDB),将IT基础架构的所有组件存储为配置项,维护每个配置项的详细数据,维护各配置项之间的关系数据以及事件、变更历史等管理数据。通过将这些数 ..

Jones & Bartlett Learning SAP® MM Questions and Answers (SAP Books)
eBooks (Jones & Bartlett Learning)
Pearson / Addison Wesley Fundamentals of Database Systems, 5th Edition
Book (Pearson / Addison Wesley)
Cengage Learning Database Systems: Design, Implementation, and Management
Book (Cengage Learning)
  • Used Book in Good Condition
Database: A Primer (Micro computer books)
Book (Addison-Wesley (C))

Related Posts



Copyright © . All Rights Reserved