Tag: Oracle

Log rotation for Oracle database

Most of you may already know how to configure the log rotation for your database alert log or the listener log etc,. As root, you can manually create a configuration file as below, and put it into /etc/logrotate.d/. /u01/app/oracle/diag/rdbms/test1/TEST1/trace/alert_TEST1.log {…

Read More >

Oracle 12.2 ASM Filter Driver Installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With the new image based Oracle Grid installation I expected this to be easy. To be fair, it was fairly easy,…

Read More >

Oracle GoldenGate Microservices Architecture – first try.

Three or four months ago Oracle released a new 12.3 version of the Oracle GoldenGate (OGG) software. The release did not only include a number of new features related to support of data types and some new features but, even…

Read More >

Oracle service secrets: more performance with less load-balancing

A huge but often overlooked aspect of tuning cluster databases is workload management. That means controlling on which and how many nodes a RAC database should actively work. The default service and most intuitive configuration is to spread the workload…

Read More >

Oracle database upgrade on RDS AWS and SPM baselines

A couple of days ago I saw a question posted online asking about how AWS upgrades an RDS Oracle database and what happens with SPM baselines. To be more precise whether the existing Oracle SPM baselines would survive the upgrade…

Read More >

Locating Most Current Record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Very often when reading data, we need to locate the most current record for a set of conditions. One typical example is that we read the data to find the most recent order for a particular customer. In this simple…

Read More >

The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)

We tend to configure a server following Oracle best practices for the kernel parameters, but what once was a server of a couple instances, soon becomes a huge and heavy environment with four, six or ten instances running on it…

Read More >

Coming to UKOUG 2017? Meet up with Pythian

UKOUG Applications Conference & Exhibition, Tech17 is just around the corner. The event will take place December 4-6, 2017 in Birmingham England. It is the largest gathering of UK Oracle Database professionals, and we’re really looking forward to it! Pythian…

Read More >

Standardizing the Oracle GoldenGate Home Path (OGG_HOME)

I don’t work with Oracle GoldenGate extensively but when I do I find it somewhat remarkable that there aren’t more standards with something as simple as the Oracle GoldenGate software home path (OGG_HOME). With the Oracle Database, in recent years…

Read More >

Datascape Podcast: Episode 16 – Recapping Oracle OpenWorld 2017

Today we’re going to recap some of the most interesting concepts from the recently completed Oracle OpenWorld 2017 and to help us navigate this I have invited Simon Pane back to the show. Simon is an accomplished Principal Consultant, who…

Read More >
Page 1 of 14812345...10...Last Page »