Oracle

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(…)

Oracle Public Cloud: create a database from command line

By Franck Pachot . You love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line? Easy with the CURL and REST API.

Dbvisit replicate when you flashback the target

By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is(…)

2 x ODA X6-2S + Dbvisit Standby: Easy DR in SE

By Franck Pachot . What's common with Standard Edition, simplicity, reliability, high performance, and affordable price? Dbvisit standby can be an answer because it brings Disaster Recovery to Standard Edition without adding complexity ODA Lite (the new X6-2S and 2M)(…)

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(…)

Feedback on my session at Oracle Open World 2016

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(…)

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(…)

How to destroy your performance: PL/SQL vs SQL

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing(…)

OTN Appreciation Day – tnsping

By William Sescu Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. I do have a lot of favorite(…)