MySQL 5.6 vs 5.7

Whitelist preview of Performance Insights has just started on RDS MySQL and it gave me a chance to visually compare load profiles of MySQL 5.6 and 5.7.

I first tried to use sysbench and ran into some curious anomolies.

The test I ran was

sysbench \
           --test=oltp \
           --oltp-table-size=10000000 \
           --oltp-test-mode=complex \
           --num-threads=10 \
           --max-time=0 \
           --max-requests=0 \
           --mysql-host=$host \
           --mysql-user=$user \
           --mysql-password=$password \
           --mysql-db=sysbench run

Load chart on MySQL 5.6 and (more...)

ODC Latin America Tour : Barranquilla

When I woke up the first thing I had to do was figure out how I was going to do a cloud demo when I didn’t have WiFi at the venue. The building was really new and they hadn’t sorted out the networking yet. I re-purposed a Docker container running Oracle 18.3 and got some of my demos working, that were meant to be running on Oracle Cloud DBaaS or Autonomous Transaction Processing. I (more...)

Automatic Table Reorganization in #Exasol

Exasol Logo

One Exasol key feature is the low maintenance effort it has compared to many other database systems. Automatic Table Reorganization is an example for this approach:

SQL_EXA> open schema adam;
EXA: open schema adam;

Rows affected: 0

SQL_EXA> create or replace table t1 as
         select rownum as id from (select 1 from dual connect by level<=1e6); 
EXA: create or replace table t1 as... Rows affected: 1000000 
SQL_EXA> select table_name,table_row_count,delete_percentage from exa_user_tables;
EXA: select table_name,table_row_count,delete_percentage from  (more...)

RMAN Commands

Note to self to configure and clear settings, and all things RMAN.

Will add more as time goes by.

catalog backuppiece '/u01/app/oracle/backup/HAWK_3241949199_20180816_bctand12_1_1.bkp';
++++ Remove summary to get full details.
list backup of archivelog all summary completed after 'sysdate-1';
list backup of archivelog from sequence 243 summary;
list backup summary completed after 'sysdate-1';

list backup of controlfile summary tag=STBY;
list backup of controlfile summary;
list backup of spfile summary;

list backup by file;

backup incremental (more...)

Let’s talk about Techiquette

I’m typing this at about 38,000 feet in the air. I’m travelling home from the Oracle Latin America tour – it was a great event, but I’ll save the details for another blog post. In reality, I should be sleeping, but as luck would have it one of the lights on our plane is malfunctioning. So whilst the rest of the plane is sleeping happily in restful darkness, my row and the rows around it (more...)

“Let’s Talk Database” coming to Wellington, Auckland, Brisbane and Perth in September.

Due to popular demand, I’ve been asked by Oracle to again run some more “Let’s Talk Database” events in September. Dates and venues are as follows: Monday, 2 September – Wellington (Wellington Oracle Office): Registration Link. Tuesday, 3 September – Auckland (Auckland Oracle Office): Registration Link. Wednesday, 12 September – Brisbane (Brisbane Oracle Office): Registration Link. Thursday, 13 September – Perth (Perth Oracle Office): Registration Link. […]

Modern apache authentication with Azure AD

One of the key topic areas for us at the moment is modernizing our applications - in most cases this is trying to move to more cloud native architectures like PaaS. However another aspect of this is dealing with the authentication process for applications - over time we (as most other companies will have) have built up a huge array of different authentication mechanisms (and authorization - but I'll ignore that for now). Users have (more...)

Using DBCA in Silent Mode

One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version is to create silent installation scripts. These scripts are for Windows and used for demo and testing environments. I did that for 11.2 and for … Continue reading Using DBCA in Silent Mode

ODC Latin America Tour : Quito to Barranquilla

There was about six of us all on the same flights from Quito to Barranquilla, so the original plan was to meet up at about 06:00 and head off for the airport, but our first flight was delayed, so we left the hotel at about 06:45. The traffic hadn’t started to pick up yet, so it only took about 30 minutes to get there.

Once checked in and through security it was just a case (more...)

VirtualBox 5.2.18

VirtualBox 5.2.18 was released yesterday.

The downloads and changelog are in the usual places.

I’ve installed this on my Windows 10 laptop and all seems OK. In fact, it seems to have made a difference to an annoying timeout I was seeing between some Docker containers running inside a VirtualBox VM. I’m not sure if this was just a fluke of the reinstall, or a real fix. Either way, it’s welcome. 🙂




ODC Latin America Tour : Quito

The first event of the Oracle Developer Community Latin America Tour (Northern Leg) was in Quito, Ecuador. A group of us met in the hotel lobby at about 07:30 and went across to the conference venue. The event began with an introduction by Paola Pullas and Marco Galarza. This was followed by Pablo Ciccarello with an introduction to the Oracle Developer Community, the Oracle ACE program and Oracle Developer Champion program.

It was a three (more...)

ODC Latin America Tour : Birmingham to Quito

The day started at 03:00, which is a silly time to start the day. I got a taxi to the airport and after a short queue for bag drop, I was waiting for the gate to open.

The first flight from Birmingham to Amsterdam went well and we arrived ahead of schedule. After about 90 minutes I was on the plane for the journey from Amsterdam to Quito. I could see there were some free (more...)

Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP)

A few days ago Oracle announced the general availability of the Autonomous Transaction Processing service on Oracle Cloud. This is the next member of the Autonomous Database family of products.

I’ve already written about provisioning the Autonomous Data Warehouse service and now I’ve used the Autonomous Transaction Processing service also.

I also wrote about loading (more...)

PreBuilt Oracle Database 18c with Docker

In this post, we can use Docker service to pull the prebuilt Oracle Database 18c. Docker must be installed and running for this feature prerequisite.

In your VM or Bare Metal, check the status and version of Docker if it is installed.

[root@docker ~]# docker info
[root@docker ~]# docker version
 Version:           18.06.0-ce
 API version:       1.38
 Go version:        go1.10.3
 Git commit:        0ffa825
 Built:             Wed Jul 18 19:08:18 2018
 OS/Arch:           linux/amd64

Catalog Database in RMAN

Purpose of Catalog Database

A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.

Catalog Database can be two types

  • Base recovery catalog
  • Virtual private catalog.

For more details

Create the tablespace for catalog user

SQL> create tablespace rman_cat datafile  (more...)

Basic of RMAN Backup and Recovery Scenario

Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database.
Check the archive log status

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 17

Next log sequence to archive 19

Current log sequence 19

Create a dummy table for testing

SQL> create  (more...)

RMAN Time Based Recovery

RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps.
First, take the full backup.

RMAN> run


allocate channel c1 device type disk;

allocate channel c2 device type disk;

backup database and archivelog all delete input;


Create a table

SQL> create tableb01(name varchar(100));

Table created.

SQL> insert intob01 values(‘Test’);

1 row created.

SQL> select to_char(sysdate,’YYYY-MM-DD hh24:mi:ss’) from dual;


Generating AWR report from Active Dataguard

Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd.

We need to perform the following steps to enable AWR reporting from a physical standby database.

Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used to administer Remote Management Framework, including the remote Automatic Workload Repository (AWR).

SQL>alter user sys$umf identified by oracle  (more...)

Learn Linux With Docker and Microsoft Container Image

I just finished teaching an 8 hour pre-con at SQL Saturday Indianapolis on Essential Linux for the DBA.  The focus of the class was on what the Microsoft DBA would need to know as more SQL Server environments begin to run on Linux.

The obstacles and demands of them will be a bit different than the Oracle crowd, as they may not have the Linux Admin or Unix expertise onsite for support and have (more...)

Which Oracle Release are you using?

Post Date: August 2018!

Recently an awesome Oracle Guru friend of mine questioned someone who was installing with the word “seriously”, which is think shows that Oracle staff sometimes don’t live in the same technological world as the rest of business.

My response was: is normal. In the real world:

– large corps mostly use old versions
– consultants look at current versions
– Oracle staff look (more...)