Database Administration & Monitoring PDB Snapshot using dbms_dnfs.clonedb_renamefile 02.01.2016 by Oracle Team By Franck Pachot . In the previous post I've explained how to use 'snapshot copy' PDB creation for thin provisioning and quick restore of initial state for continuous integration tests. If you don't have the multitenant(…)
Database Administration & Monitoring PDB snapshot copy for continuous integration testing 01.01.2016 by Oracle Team 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(…)
Database Administration & Monitoring Phantom session environment in multitenant? 27.12.2015 by Oracle Team By Franck Pachot . In multitenant a session can switch from one container to another. There are a few restrictions such as a transaction cannot span multiple containers. But how do sessions parameters behave? It seems that there is a(…)
Technology Survey Journées SQL Server 2015: Retrouvez nos sessions sur SlideShare et Youtube! 24.12.2015 by Stéphane Haby Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et(…)
Database Administration & Monitoring Delete an orphan user-database under SSISDB 24.12.2015 by Stéphane Haby I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB… I discovered this by a customer and it was very tricky to find the explanation and the solution. This is the reason why(…)
Database Administration & Monitoring How fast can you setup a standby database with PostgreSQL? 22.12.2015 by Daniel Westermann While setting up a PostgreSQL infrastructure at customer today my colleague Pierre Sicot and I discussed on how time consuming it is to setup standby databases if you compare different vendors. Lets make a challenge out of(…)
Database Administration & Monitoring OCM 12c preparation: restore Voting disks, OCR and ASM spfile 21.12.2015 by Oracle Team By Franck Pachot . As in the previous posts, here are a few commands I used to check that I know how to restore the cluster mandatory files in 12c. It's what I'm doing while preparing the OCM 12c exam,(…)
Database Administration & Monitoring Watching sql statements in PostgreSQL 21.12.2015 by Daniel Westermann Back in 2012 I wrote a small blog post about watching the results of commands in Linux. Well, the same can be done in psql: (postgres@[local]:4448) [postgres] > create table t1 ( a(…)
Database Administration & Monitoring OCM 12c preparation: RAT in multitenant 20.12.2015 by Oracle Team 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(…)
Database Administration & Monitoring Setting your cluster name in PostgreSQL 9.5 20.12.2015 by Daniel Westermann PostgreSQL 9.5 introduces a new parameter which is called: cluster_name. So, what is this good for? Imagine you have two (or even more) PostgreSQL clusters running on the same host. When looking at the operating system processes(…)