Database Administration & Monitoring

SQL Plan Directives in 12cR2. Behavior is different than in 12cR1.

During the Frankfurter IT Tage I provided a presentation about SQL Plan Directives and how to reproduce a testcase in a test environment for a plan with used SQL Plan Directives (SPD). In that context I did a couple of(…)

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

By William Sescu Security is a quite important topic, especially when running Oracle in the cloud. To make your DataGuard a little bit more secure, you can enable the TCP.VALIDNODE_CHECKING feature. I call it SQL*Net Firewall. Enabling the SQL*Net Firewall(…)

Oracle 12cR2: AWR views in multitenant

By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)

RMAN> TRANSPORT TABLESPACE

By Franck Pachot . In a previous post I explained how to use transportable tablespace from a standby database. Here I'm showing an alternative where you can transport from a backup instead of a standby database.

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image :(…)

Dataguard Oracle 12.2 : Support for Multiple Automatic Failover Targets

By Mouhamadou Diaw In a previous blog, we talked about Fast-Start Failover with the MaxProtection mode. With Oracle 12.2 Oracle Data Guard now supports multiple failover targets in a fast-start failover configuration. Previous functionality allowed(…)

Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments(…)

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

By Mouhamadou Diaw With Oracle 12.1 the one requirement to configure Fast-start Failover is to ensure the broker configuration is operating in either Maximum Availability mode or Maximum Performance mode. With 12.2 Fast-Start Failover can be now configured with(…)

Oracle Database 12c Release 2 Multitenant (Oracle Press)

By Franck Pachot . Here it is. The multitenant book is out for sale...

Oracle 12cR2 – Is the SYSDG Administrative Privilege enough for doing Oracle Data Guard Operations?

By William Sescu For security reasons, you may want that your DataGuard operations are done with a different UNIX user and with a different Oracle user which is not so highly privileged like the SYSDBA.  This is exactly where the(…)