Pluggable Databases

12cR2: Upgrade by unplug/plug in the Oracle Cloud Service

By Franck Pachot . 12.2 is available in the Oracle Public Cloud DBaaS. If you have a 12.1 DBaaS service, there's no button to upgrade it. I'll describe all the possible upgrade procedures and the first one, and the most(…)

12cR2 Single-Tenant: Multitenant Features for All Editions

By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)

Oracle 12cR2: MAX_PDBS

By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If(…)

Oracle 12cR2: Pluggable database relocation

By Franck Pachot . Here is, in my opinion, the most beautiful feature of the multitenant architecture. You know how I love Transportable Tablespaces. But here: No need to put the source in read/only No need to export/import the metadata(…)

12cR2 multitenant containers in SQL_TRACE

By Franck Pachot . In multitenant you session can switch between containers. For example, since 12.1, a common user can switch explicitly between CDB$ROOT and any PDB with the 'ALTER SYSTEM SET CONTAINER'. Any user connected to a PDB will(…)

Oracle 12cR2 multitenant: Local UNDO

By Franck Pachot . Pluggable Databases are supposed to be isolated, containing the whole of user data and metadata. This is the definition of dictionary separation coming with multitenant architecture: only system data and metadata are at CDB level. User(…)

Datawarehouse ODS load is fast and easy in Enterprise Edition

By Franck Pachot . In a previous post, tribute to transportable tablespaces (TTS), I said that TTS is also used to move data quickly from operational database to a datawarehouse ODS. For sure, you don't transport(…)

CDB resource plan: shares and utilization_limit

By Franck Pachot . I'm preparing some slides about PDB security (lockdown) and isolation (resource) for DOAG and as usual I've more info to share than what can fit in 45 minutes. In order to avoid the frustration of(…)

Oracle Database 12.2 – PDBaaS

By Franck Pachot . It's official, Larry Ellison made the announcement at first keynote and the database product team at oracle has released the version and the documentation publicly. Oracle Database Exadata Express Cloud Service is the 'Cloud First' environment(…)

Multitenant thin provisioning: PDB snapshots on ACFS

By Franck Pachot . Database on ACFS is a long story. At first, the main reason for ASM was to bypass a filesystem layer that is not required by the database. ACFS was for the non-database files that had to(…)