Database Administration & Monitoring

Phantom session environment in multitenant?

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

Delete an orphan user-database under SSISDB

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

How fast can you setup a standby database with PostgreSQL?

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

OCM 12c preparation: restore Voting disks, OCR and ASM spfile

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

Watching sql statements in PostgreSQL

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

OCM 12c preparation: RAT in multitenant

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

Setting your cluster name in PostgreSQL 9.5

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

OCM 12c preparation: Data Guard with OEM

By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It's not that I don't like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually(…)

OCM 12c preparation: documentation

By Franck Pachot . The OCM exam advice says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. I've checked that I can find quickly the documentation related with each topic listed. Here(…)

OCM 12c preparation: Explain fast refresh

By Franck Pachot . There are some rules to be able to fast refresh a materialized view (which means, refresh it so that it is not stale, and without running the whole query). Documentation is in the Datawarehouse Guide, but(…)