Database Administration & Monitoring

Oracle 12c and RMAN switch datafile to copy, is it really so easy?

By William Sescu Oracle incrementally updating backups are used quite often because they are easy to setup and restoring a datafile is very fast. It is very fast because you are not really restoring a datafile, you are switching to(…)

Oracle 12cR2: DDL deferred invalidation

By Franck Pachot . In a previous post I described the new V$SQL views about rolling invalidation. I did the example with dbms_stats which is able to do rolling invalidation since 11g. But more is coming(…)

Running PostgreSQL on ZFS on Linux – Compression

In the last posts in this little series we looked at how to get a ZFS file system up and running on a CentOS 7 host and how snapshots and clones can be used(…)

Oracle 12c and RMAN automatic datafile creation

By William Sescu A lot of new features popped up with RMAN 12c, like  Expansion of Multi-section support, or Simplified cross-platform migration and many many more. However, in this post I would like to highlight a small, but very helpful(…)

Running PostgreSQL on ZFS on Linux – Fun with snapshots and clones

In the last post we looked at how to get a ZFS file system up and running on a CentOS 7 host and how to enable the auto mount of the ZFS file systems. In this post(…)

Running PostgreSQL on ZFS on Linux

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement(…)

Connecting your PostgreSQL instance to an Oracle database – Debian version

Some time ago I blogged about attaching your PostgreSQL instance to an Oracle database by using the oracle_fdw foreign data wrapper. This resulted in a comment which is the reason for this post: Doing the same(…)

Oracle 12cR2: IS_ROLLING_INVALID in V$SQL

By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as 'rolling invalid' and(…)

Modern software architecture – what is a database?

By Franck Pachot . This blog post is focused at developers and software architects. I'm probably not writing at the right place. You're on an infrastructure experts blog and the author is an Oracle DBA. So what can you learn(…)

Ravello

By Franck Pachot . I'm at Oracle Open World and I'm rather focused on database rather than all those Cloud topics, but one product caught my attention at the Oracle ACED Briefing. Oracle bought Ravallo systems at the beginning of(…)