Author: Jared Still

Select vs Assign – How To Assign PL/SQL Variables

When writing PL/SQL, should you use ‘select from dual’ to assign variable values? The answer may surprise you.

Read More >

How to Make Oracle Use the Correct Index

Learn a simple method to make Oracle use the index required for a SQL Query.

Read More >

Installing OCI Command Line Utilities in Linux and Windows

There are multiple documented methods for installing the Oracle Cloud Infrastructure command line utilities (oci). Some methods work better than others, but sometimes none of them meet your needs. This is a story of getting the installation done to meet our needs.

Read More >

Oracle RAC: Network Performance with Jumbo Frames

When configuring virtual servers to run Oracle RAC, be sure to use Jumbo Frames for the private network interconnect , just like you would on physical servers.

Read More >

World Backup Day – Protect Your Oracle Databases

How do you know your Oracle Backups can be used to restore a database? Here is how to find out.

Read More >

Backup Oracle to Amazon AWS S3 – Part 1

Backups of Oracle Databases can be made directly to s3, without licensing additional software.

Read More >

Using FreeRadius to Authorize Oracle Connections

Jared Still shows you how to setup the open source RADIUS server FreeRadius so it may be used to authenticate database connections.

Read More >

How to create an Oracle 18c client image in Docker

Use docker and Oracle Dockerfile to easily install new Oracle client software.

Read More >

How to use Oracle Instant Client Docker images

Learn how to use Oracle Instant Client Docker images in your environment.

Read More >

Improve Oracle performance with ASM filter driver

It has been asked “Why user Oracle’s ASM Filter Driver?”. Here’s one reason I found: ASM Filter Driver performs 20% better then ASMLib.

Read More >
Page 1 of 512345