Using LetsEncrypt Certs with Oracle E-Business suite

Optimizing CPU cores and threads for Oracle on AWS

A Smarter Way to Scale: Custom CPU Options on AWS About a couple of weeks ago, AWS introduced a new option to manage ...

Oracle Database 18c schema only accounts

One nice new feature of Oracle Database 18c is that schemas can be created without a password. These are called " ...

Tackling time troubles - how to use dates correctly in Oracle

For the Oracle Code series of events I have delivered an older but still relevant talk called "Tackling Time Troubles." ...

Using AI for database administration automation - extracting useful information from log files

When talking about automation for Oracle Database Administration, besides automation of software installation and ...

Oracle parallel query hints - part 3: PX_JOIN_FILTER

In part one of this series on Oracle Parallel Query Hints, I looked at PQ_DISTRIBUTE, and part two was about ...

Oracle parallel query hints reference - part 5: PQ_DISTRIBUTE_WINDOW

Welcome to part 5 of the series.

Using Oracle Wallets and SEPS with Perl, JDBC, and ODBC

A few years ago I wrote a couple of popular blog articles on using Secure External Password Stores (SEPS) and ...

Oracle 18c Non-CDB databases in the Oracle Database Cloud Service (ODBCS)

Oracle is implementing a cloud first approach and hence the newest releases such as Oracle Database 18c first appear in ...

Oracle parallel query hints. A reference series part 2: PQ_REPLICATE

The Mechanics of PQ_REPLICATE in Oracle 12.2 In part 1 of this series, we talked about the basic mechanics of the ...

Oracle’s Database Security Assessment Tool (DBSAT) Version 2 (2.0.1)

Background Oracle recently released a new version of their Database Security Assessment Tool (DBSAT) - version 2.0.1. ...

Why is my Forms 12c Application so slow?

After a recent upgrade Users cannot work with the forms application anymore; it has been a few weeks since an upgrade ...

RDP Issue - CredSSP encryption Oracle remediation

Introduction We have recently had some issues accessing a few client servers and found it is related to a Windows ...

An Oracle "oraenv" script solution for Windows with PowerShell

The idea Due to the nature of my consulting work, I mostly work in Linux environments and use bash for scripting. But ...

gh-ost with Amazon RDS / Aurora

Doing online schema changes in a managed database environment is not as straight-forward as one may think. Using gh-ost ...

Log buffer #551: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

Database migration: how to handle large tables

In the previous blog, we presented a simple database migration approach using Apache Nifi. Following our previous blog, ...

Fun with Oracle Data Guard Broker

The beginning So, there we were attending to our jobs and tending to our customers when an emergency alert came in: a ...

EBS 12.2 issues seen in the wild

Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS production environment. ...

Log buffer #549: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle, SQL Server and MySQL.

Log buffer #548: a carnival of the vanities for DBAs

This log buffer edition covers blog posts from Cloud, Oracle and MySQL.

Improve Oracle performance with ASM filter driver

Context Sometimes the results found in performance testing can be a bit of a surprise. I have recently been preparing ...

How to efficiently back up and restore crontab

When a database environment is being patched, entries from crontab are commented and then removed when patching is ...

Debugging CBQT OR expansion with 10053 trace

I had been working with a client to add a little bit of functionality to an analytical view that we had been running ...

Installing Oracle 18c using command line

Introduction Just three days ago Oracle released Oracle 18c for general installation on-premises. We've had a taste of ...

How Linux Hugepages work to improve Oracle performance

This post is not intended to be an in-depth discussion of how Linux Hugepages work, but rather just a cursory ...

Getting started with Oracle Database Backup Service in 2018

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found here. ...

HugePages for Oracle database in Oracle Cloud

I recently published a blog post about large pages support in AWS RDS for Oracle and someone asked me if and how it ...

Creating dynamic tasks using Apache Airflow

What's Airflow? Apache Airflow is an open source scheduler built on Python. It uses a topological sorting mechanism, ...