Oracle Pluggable和分布式设计.pptx

Copyright ? 2019 Oracle and/or its affiliates.;Distributed Data Architecture Using Application Containers and Container Databases;Presentation Objectives;Presentation Objectives;Overview;Presentation Objectives; Database (Storage Structures);;;CDB_xxx All objects in the multitenant container database across all PDBs;Terminology; ;Provisioning a Pluggable Database;;There are two possible ways to switch a connection between containers within a CDB: Reconnect Use the ALTER SESSION statement: ;NOMOUNT;Mounting a CDB;;OPEN;Automatic PDB Opening;CDB OPEN;Shutting Down a CDB Instance;Changing PDB Mode;Modifying PDB Settings;Instance Parameter Change Impact;Instance Parameter Change Impact: Example ;Using the ALTER SYSTEM Statement on PDB;Configuring Host Name and Port Number per PDB;;;;Creating Common Profiles in CDB and PDBs;;Operations on Data-Linked Objects;Enabling Common Users to Access Data in PDBs;Finding Information About CONTAINER_DATA Attributes;Restricting Operations with PDB Lockdown Profile;Restricting Operations with PDB Lockdown Profile;Auditing Actions in CDB and PDBs;Managing Other Types of Security Policies in Application Containers;Securing Data with Oracle Database Vault;DV Enabled Strict Mode;12c;18c;Keystore Management Changes for PDB;Defining the Keystore Type;Tuning a CDB;Sizing the CDB;Testing the Estimates;Managing SGA for PDBs;Managing PGA for PDBs;Monitoring PDB Memory Usage;AWR and ADDM Behavior ;PDB-Level Snapshot Views;AWR Report;ADDM Tasks: At the CDB Level Only;Basic Rules: Statistics for Common Objects;Allocating Resources in the CDB;Resource Manager and Pluggable Databases;Managing Resources Between PDBs;CDB Resource Plan Basics: Limits;PDB IO Rate Limit;CDB Resource Plan: Full Example;;Managing Resources Within a PDB;Putting It Together;Presentation Objectives;Application Containers;Application Containers: Other Features;Types of Containers;Creating Application PDBs;Application Name and Version;Installing Applications;Patching