Database management

SQL Server: Change Data Capture for Oracle

This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables. In other words,(…)

Use a wallet to encrypt Oracle client passwords

In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised, we can assume that any password stored in clear text are also compromised. I had(…)

12c: shutdown abort a PDB?

By Franck Pachot . Can we shutdown abort a PDB? Let’s try: SQL> show con_id CON_ID ------------------------------ 3SQL> shutdown abort; Pluggable Database closed. But is it really a shutdown abort? The shutdown abort we know in non-CDB – or(…)

Index on trunc(date) – do you still need old index?

By Franck Pachot . Sometimes we have to index on ( trunc(date) ) because a SQL statement uses predicate on it instead of giving a range from midnight to midnight. When you do that you probably keep the index(…)

ODA 12.1.X.X.X – add a multiplexed control file under ACFS

Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA(…)

Venturing into bulk insert a SQL Server error log and data order

Have you ever attempted to bulk import a SQL Server error log in order to use the information inside a report for example? If yes, you have probably wondered how to keep data in the correct order in a query(…)

Oracle compression, availability and licensing

By Franck Pachot . Various methods of table compression have been introduced at each release. Some require a specific storage system Some requires specific options. Some are only for static data. And it’s not always very clear for the(…)

Generic query for multicriteria search – part II: BIND_AWARE (Adaptive Cursor Sharing)

By Franck Pachot . In the previous post I explained the performance issue encountered when using a generic query to deal with optional search criteria on multiple columns. The statement was shared by all executions, was marked as(…)

Generic query for multicriteria search – part I: USE_CONCAT (OR Expansion)

By Franck Pachot . You have a multicriteria search screen on the EMPLOYEE table where you can enter an employee id, a department id, a manager id or a job id. Either you put the value you want to(…)

RAC Attack! next month 12c in Las Vegas

By Franck Pachot . RAC is the most complex installation you can have for an oracle database. A RAC DBA is involved not only on database, but storage, network, and system as well. It involves also(…)