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(…)
Database Administration & Monitoring OCM 12c preparation: Data Guard with OEM 18.12.2015 by Oracle Team 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(…)
Database Administration & Monitoring OCM 12c preparation: documentation 18.12.2015 by Oracle Team 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(…)
Database Administration & Monitoring OCM 12c preparation: Explain fast refresh 17.12.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle OCM 12c preparation: Transportable Tablespaces 15.12.2015 by Oracle Team 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(…)