An early July blog…

Blogs of the Week

1. Announcing SQL Developer, SQL Developer Data Modeler, & SQLcl versions 20.2

Jeff Smith says, “However, there are bug fixes that we need to get into your hands, and our developers have never stopped working on new features, so we ARE releasing version 20.2, TODAY.”

He then links to the following downloads:

SQL Developer 20.2

SQL Developer Data Modeler 20.2

SQLcl 20.2

“ORDS and SQL Developer Web version 20.2 will be available shortly. Just a few more tires to kick.”

2. The size of a thumb

“The size of a thumb was used by humans as a measurement for very long time. Used by craftsmen, the size of body parts like a thumb, hand, forearm, foot and so on were both good enough to be used within a team, and even the ratio between those measurement were acceptable accurate and comparable for each individual. But such a system comes to its limits. Different regions had different commonly agreed definitions for the same unit. This makes it hard to properly compare and convert, especially when it comes to written contracts between different regions…”

“For me it seems, this problem is also exists in rules of thumb. Some of them are similar, still different. My current example is a rule of thumb to decide, if an access path of a SQL statement is acceptable.”

Read on for more…

3. More info on Oracle Always Free APEX upgrades

This post is a continuation of the series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

4. ODA — “Patch your ODA with ODA Patch Bundle” – Stay away from PSUs, CPUs and/or other patches

Erman Arslan writes, “I want to inform you on an important subject.. It is about patching Oracle Database Appliance. You may already know this, but in some cases you may want to take the risk and apply one-off patches, PSUs or CPUs on your Oracle Database Appliance environments…”

He links to the following documentation.

5. My interview with Heli Helskyaho

Watch the video!

6. Oracle ACFS / ASM Filter Driver and Oracle Enterprise Linux

Gary Gordhamer writes, “In the world of Oracle databases, DBA’s and system administrators don’t always see eye to eye.  Mostly I have found that this is really just about coming at challenges from different angles.  Some of the major changes in Oracle since 10g version has been the introduction of Oracle Automatic Storage Management or ASM.  This has led to many features such as ASMLIB, ASM Clustered Filesystem (ACFS), and now the ASM Filter Driver (AFD or ASMFD).  These features require OS specific compatible libraries, and kernel modules.”

For this blog, he focuses on Oracle Enterprise Linux (OEL)

7. Finding the Weblogic Password for the Oracle Enterprise Manager Marketplace Image

Alfredo Krieg writes, “Oracle Enterprise Manager (EM) 13.4 is available in the Oracle Cloud Infrastructure Marketplace. This image is very flexible and allows you to choose between different EM Deployment sizes ranging from Simple (Single node) to Large (Multi-node) setups.”

8. Provisioning Oracle Fusion Analytics Warehouse

Dayne Carley says, “Oracle Analytics for Applications (FAW / OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle Autonomous Data Warehouse (ADW). FAW extracts and loads data from your Oracle Fusion Applications Cloud into an instance of ADW and provides a semantic model with prebuilt KPIs, dashboards, and reports in OAC.

The Oracle document here lists the currently regions available for provisioning.

This post describes the OCI and Fusion Applications components required to provision FAW, the components created by the provisioning process and a step-by-step guide to the process.”

9. Getting the Most from your Oracle Support

“Nobody will argue that Oracle Support is a word class experience.  Like it or not, the service is here to support thousands and individuals can get lost in the process.  If you navigate the process correctly, you can get results.”

10. How to get the Data Guard broker configuration from a SQL query?

Ludovico’s blog begins with:

“Everybody knows that you can get the Data Guard configuration in dgmgrl with the command:

1show configuration;

but few know that this information is actually available in x$drc”

Read the rest of the blog for more information…

This week on Twitter

UKOUG tweeted a link to some virtual events, taking place this July.

Nitin Vengurlekar posted about the (Virtual) ODTUG Database Community Beach Party! Tuesday July 21st…

Alan Blakely shared some Webinar information. The next one is 12th August. See more information here.

Stories from, and

Videos such as:

#OracleJET: Deferred Rendering for Faster App Performance | J. B. Brock

Part 4 of REAL Webinars on Oracle Cloud Native App Development – Oracle Kubernetes Engine