Oracle

Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy

After the good article “A short glance at Attunity replicate” from Franck Pachot, I will continue to explain our test on Attunity Replicate with datatype and how this(…)

When a query has read 350TB after 73K nested loops

By Franck Pachot . According that you have Tuning Pack, SQL Monitor is the right way to see what a query is currently doing. A query was running for days and the first figure I see is that it has(…)

Testing Oracle on exoscale.ch

By Franck Pachot . My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland(…)

Can you become a PaaS provider for an Oracle Database service?

By Franck Pachot . This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has(…)

APEX Connect 2016 – Day 2 – APEX

After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics: – Dynamic Actions 5.1 – APEX and Oracle JET – Enterprise UX(…)

I/O Performance predictability in the Cloud

By Franck Pachot . You don't need good performance only for your system. You need reliable performance. You need performance predictability.

A short glance at Attunity replicate

By Franck Pachot . If you follow my blog, you should know that I really like Dbvisit replicate because it's simple, robust, has good features and excellent support. But that's not a reason to ignore other alternatives (and this is(…)

The (almost) same sample schema for all major relational databases (2) – Oracle

In the last post we looked at how to install the "Dell DVD Store Database Test Suite" into a PostgreSQL 9.5.2 database. In this post we'll do the same with an Oracle database.

Transparently externalize BLOB to BFILE

By Franck Pachot . Storing documents within the database is the easiest, especially because you get them consistent with the metadata stored in the database. If you store them externally, then you need to manage their backup, their synchronization to(…)

Single-Tenant vs. non-CDB: no reason to refuse it

By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First(…)