Infrastructure at your Service

Tag

CDB Archives - Page 10 of 12 - Blog dbi services

Oracle Team

PDB snapshot copy for continuous integration testing

By | Database Administration & Monitoring | 5 Comments

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is not optimized for DDL. Restoring the database takes too long. Even if you data is small, there is those SYSTEM, SYSAUX tablespaces. Flashback database can help, but it still takes time because it requires to…

Read More
Oracle Team

OCM 12c preparation: RAT in multitenant

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I have several customers that have cases where Real Application Testing can be interesting, but they don’t use it because it’s an expensive option. Which is why it’s probably the topic listed for OCM 12c exam where I’ve the less experience. And I don’t even know at which level (CDB or PDB) it has to be run in multitenant. So I’ve tested it and came to a surprise.

Read More
Oracle Team

OCM 12c preparation: Transportable Tablespaces

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . I use transportable tablespaces a lot since 8i, here are just a few examples. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Create a plugged-in tablespace by using the transportable tablespace feature. this is the TTS feature…

Read More
Oracle Team

OCM 12c preparation: Manage PDB

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Let’s see the different ways to create a PDB, with different tools. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. Documentation…

Read More
Oracle Team

OCM 12c preparation: Create CDB in command line

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam – so don’t expect any clue about the exam here. It’s based only on the exam topics, and only those points I wanted to brush up, so don’t expect it to be a comprehensive list of points to know for the exam. Let’s start by…

Read More
Oracle Team

OOW15 – Day 1- No fog on Golden Gate brige but Cloud everywhere at Moscone center

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Here are the two sides of the Oracle Open World: marketing and community. Of course Oracle organizes that big event for marketing: show the future products and explain how they are better than all competitors ones. But it’s not only that. There is a community around Oracle, of users, partners, technologists, speakers, authors, etc. And Oracle Open World is also the place to meet.

Read More
Oracle Team

Multitenant vs. schema based consolidation

By | Database management, Oracle | 4 Comments

By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have one database and multiple pluggable databases Of course, this is exactly the reason for pluggable databases: multitenant. You have good isolation but still share resources. A lot of reasons have been given why multiple schema –…

Read More