Search

Top 60 Oracle Blogs

Recent comments

January 2021

Terraform tips’n’tricks: getting the latest Oracle Linux 7 image OCID programatically

As with all cloud providers you need to specify an operating system image when creating virtual machines using Terraform in Oracle Cloud Infrastructure (OCI). This can either be an Oracle supplied image, or a custom image you built. This post describes how to fetch the most recent Oracle-provided image for Oracle Linux 7 in Terraform. I am planning another post for Oracle Linux 8 in the future.

Terraform versions

When writing this post Terraform 0.14.5 was the latest and greatest release. The terraform init command downloaded release 4.10.0 of the OCI provider.

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to Oracle and SQL is the “mystery” of why Oracle is not using an index when it is totally obvious to us as the developer that it should be.  The demo code is always along the following lines

Oracle Database 19c Automatic Indexing: Index Compression Update (New Morning)

  I was reminded in a recent comment by Rajeshwaran Jeyabal that I hadn’t updated my post on Automatic Indexing with Advanced Compression that’s in need of a couple of amendments. Initially when Automatic Indexing was released, the ability to set Advanced Compression was NOT included in the official documentation, although the EXEC DBMS_AUTO_INDEX.CONFIGURE( ‘AUTO_INDEX_COMPRESSION‘ […]

Index Hints

At the end of the previous post on index hints I mentioned that I had been prompted to complete a draft from a few years back because I’d been sent an email by Kaley Crum showing the optimizer ignoring an index_rs_asc() hint in a very simple query. Here, with some cosmetic changes, is the example he sent me.

Index Hints

I’ve lost count of the number of times I’ve reminded people that hinting (correctly) is hard. Even the humble /*+ index() */ hint and its close relatives are open to misunderstanding and accidental misuse, leading to complaints that “Oracle is ignoring my hint”.

Strange though it may seem, I’m still not 100% certain of what some of the basic index hints are supposed to do, and even the “hint report” in the most recent versions of dbms_xplan.display_xxx() hasn’t told me everything I’d like to know. So if you think you know all about hints and indexing this blog note is for you.

I’ll start with a brief, and approximate, timeline for the basic index hints – starting from 8.0

Building Single-Page Websites on WordPress.com

WordPress.com supports a wide range of features for building your online presence: blogs, online stores, newsletter signup forms, and more. These tools are invaluable for many customers, but they can seem excessive for folks who are just looking to create a straightforward single-page website. If that’s you, read on for examples of how you can also create one-page websites here on WordPress.com. 

Both examples use WordPress.com’s freshly-launched Blank Canvas theme, which is optimized for single-page websites. It comes with no header, navigation menus, or widgets, so the page you design in the WordPress editor is the same page you’ll see on the front end. The theme also comes with a handful of ready-made Block Patterns to help kick start your site. 

Video : Long Identifiers in Oracle Database 12.2 Onward

In today’s video we’ll quickly demonstrate long identifiers, introduced in Oracle database 12.2.

The video is based on this article.

Eleven Table Tennis: Basics

Assuming you are an IRL player who wants to get as close to the real thing as possible, that’s what I’d recommend:

New Year … new idea … new channel

I’ve done a lot of presentations over the years, written a ton of blog posts, and over the past  5 years cranked out hundreds of tech videos of my YouTube channel.

But with the current state of the world, I also know that over the last year we’ve been awash with tech content that now comes exclusively over a virtual medium that generally requires us to stop our “day jobs” in order to focus on the content, whether it be a live presentation, recorded video or reading a long form blog post.

Announcing SLOB 2.5.3

This is just a quick blog post to inform readers that SLOB 2.5.3 is now available at the following webpage: click here.

SLOB 2.5.3 is a bug fix release. One of the fixed bugs has to do with how SLOB sessions get connected to RAC instances. SLOB users can surely connect to the SCAN service but for more repeatable testing I advise SLOB 2.5.3 and SQL*Net services configured one per RAC node. This manner of connectivity establishes affinity between schemas and RAC nodes. For example, repeatability is improved if sessions performing SLOB Operations against, say, user7’s schema, it is beneficial to do so connected to the same RAC node as you iterate through your testing.

The following is cut and pasted from SLOB/misc/sql_net/README: