Search

Top 60 Oracle Blogs

Recent comments

August 2018

Gooey GUIDs

Do a quick Google search and you’ll find plenty of blog posts about why GUIDs are superior to integers for a unique identifier, and of course, an equal number of posts about why integers are superior to GUIDs. In the Oracle world, most people have been using sequence numbers since they were pretty much the only option available to us in earlier versions. But developers coming from other platforms often prefer GUIDs simply due to their familiarity with them.

A tribute to Natural Join

By Franck Pachot

.
I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often.

A tribute to Natural Join

By Franck Pachot

.
I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often.

A tribute to Natural Join

By Franck Pachot

.
I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often.

Masterclass – 1

A recent thread on the Oracle developer community database forum raised a fairly typical question with a little twist. The basic question is “why is this (very simple) query slow on one system when it’s much faster on another?” The little twist was that the original posting told use that “Streams Replication” was in place to replicate the data between the two systems.

Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!

I’m happy to announce that I plan to seriously geek out for the next 6 months or so! Some of the time I will use for research and development of new stuff (some of it is secret stuff for Gluent, but more about the other plans below). As a part of the tech geek-out, I’ll also run my tuning & troubleshooting training again in 2018 & 2019, see more details here:

Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!

Updated (2020-05-17): Added 2020 training dates.
I will run my Oracle/SQL/Linux tuning & troubleshooting training again in 2020, see more details here:
Advanced Oracle SQL Tuning training - June 2020 Practical Linux Performance & Application troubleshooting training - September 2020 Advanced Oracle Troubleshooting training - TBD (end of 2020 or early 2021) After a class, the attendees will get downloadable video recordings for their own personal use.
Here are some example slides from the AST class for eye-candy :)

Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!

Updated (2020-05-17): Added 2020 training dates.
I will run my Oracle/SQL/Linux tuning & troubleshooting training again in 2020, see more details here:
Advanced Oracle SQL Tuning training - June 2020 Practical Linux Performance & Application troubleshooting training - September 2020 Advanced Oracle Troubleshooting training - TBD (end of 2020 or early 2021) After a class, the attendees will get downloadable video recordings for their own personal use.
Here are some example slides from the AST class for eye-candy :)

Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!

I’m happy to announce that I plan to seriously geek out for the next 6 months or so! Some of the time I will use for research and development of new stuff (some of it is secret stuff for Gluent, but more about the other plans below). As a part of the tech geek-out, I’ll also run my tuning & troubleshooting training again in 2018 & 2019, see more details here:

Installing ZFS on OEL7 UEK4

Here are the commands I use to setup ZFS on Oracle Linux

#This was tested on OEL 7.2 in Oracle Cloud Compute Classic and OEL 7.5 in Oracle Cloud infrastructure
set -x
cat /etc/oracle-release
yum -y install kernel-uek-devel-$(uname -r)
yum install -y yum-utils
yum-config-manager --enable ol7_developer_EPEL
yum install -y dkms
rpm -Uvh http://download.zfsonlinux.org/epel/zfs-release.el7_5.noarch.rpm
sudo yum install -y zfs
dkms status
/sbin/modprobe zfs
systemctl -a | grep zfs
echo "ZFS Pool creation on the last disk added:"
zpool create -f myzpool -m /mnt/myzpool /dev/$(lsblk | awk 'END{print $1}')
zpool status
zpool list

The full blog is on:

Installing ZFS on OEL7 UEK4 for Docker storage - Blog dbi services