Infrastructure at your Service

Tag

CDB Archives - Page 7 of 12 - Blog dbi services

Oracle Team

Oracle 12cR2 multitenant: Local UNDO

By | Database Administration & Monitoring | 10 Comments

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 data and metadata are in separate tablespaces belonging to the PDB. And this is what makes the unplug/plug available: because PDB tablespaces contain everything, you can transport their datafiles from one CDB to another. However,…

Read More
Oracle Team

Datawarehouse ODS load is fast and easy in Enterprise Edition

By | Database Administration & Monitoring | No Comments

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 directly from the production database because TTS requires that the tablespace is read only. But you can transport from a snapshot standby. Both features (transportable tablespaces and Data Guard snapshot standby) are free in Enterprise Edition without option. Here…

Read More
Oracle Team

Feedback on my session at Oracle Open World 2016

By | Database Administration & Monitoring | One Comment

By Franck Pachot . I was a speaker at Oracle Open World and received the feedback and demographic data. this session took place on the Sunday, which is the User Group Forum day about Multitenant, defining what is the multitenant architecture and which features it brings to us even wen we dont’ have the multitenant option. Unfortunately, I cannot upload the slides before the next 12c release is available. If you missed the session or…

Read More
Oracle Team

CDB resource plan: shares and utilization_limit

By | Database Administration & Monitoring | 2 Comments

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 removing slides, I usually share them in blog posts. Here is the basic concepts of CDB resource plans in multitenant: shares and resource limit.

Read More
Oracle Team

Multitenant thin provisioning: PDB snapshots on ACFS

By | Database Administration & Monitoring | No Comments

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 be accessed by all cluster nodes. But then, storage vendors and other providers came with snapshots, compression and thin provisioning and Oracle had to answer: they implemented those storage features in ACFS and allowed database…

Read More
Oracle Team

ODA X6 database classes and shapes

By | Database Administration & Monitoring | 12 Comments

By Franck Pachot . On the Oracle Database Appliance, like on the Oracle public Cloud, you define the CPU capacity with ‘shapes’. On the latest ODA, the X6, we have a new interface to provision a database. Let’s look at the different shapes available. ODACLI You can provision a new database with the command line ODACLI which replaces the OAKCLI you used in ODA X5: [[email protected] ~]# odacli create-database Usage: create-database [options] Options: * –adminpassword,…

Read More