Oracle ACE
After less than 2 years after becoming Oracle ACE Associate, I’m happy to share that I have been promoted to Oracle ACE! I have recently changed my focus from Oracle Database to MySQL, but as it is currently owned by Oracle, I hope I will…
Do Not Format Invalid Code in SQL Developer
Introduction What happens when you call the formatter in SQL Developer for invalid code? Until recently SQL Developer tried to format it anyway. This produced strange results in some cases. Starting with SQL Developer version 21.2.0 there is a hidden option to suppress formatting when…
Lightweight Formatter for PL/SQL & SQL
TL;DR Bye bye heavyweight formatter. Long live the lightweight formatter. Are you using Oracle’s SQL Developer or SQLcl? Then install these settings and press Ctrl-F7 to produce code that conforms to the Trivadis PL/SQL & SQL Coding Style. A compromise between conformity and individuality. Heavyweight…
COMMON_USER_CONNECT lockdown profiles feature in Oracle Database 19c
After upgrading some CDBs to 19c, we hit the problem of not being able to connect as common users to the PDBs. In all affected CDBs, lockdown profiles were in place with following definition regarding common user connection part: It worked well in 12c, but…
PostgreSQL’s foreign data wrapper to Oracle: hide passwords using secure external password store
Hi there, customer is worried about the credentials that are stored in PostgreSQL dbwhen using foreign data wrappers. In that case to Oracle, using oracle_fdw.It is possible to query a stored password from data dictionary. Only privileged users can do it, but still kind of…
FAN events and FCF for SEHA
With Oracle database version 19.7 we got Standard Edition High Availability as a kind of replacement for Standard Edition RACs which cannot be used as of 19c any more. See https://blogs.oracle.com/maa/standard-edition-high-availability-officially-released In a recent discussion I wondered whether FAN events and Fast Connection Failover might…
Connecting via JDBC to the Oracle Cloud
You can connect to an Oracle Autonomous Database in different ways. This is well documented in here. It’s a bit different from what we know from on-premises environments. In this blog post, I show the steps to connect to an Autonomous Database from a third-party…
Performance Comparison: Snowflake vs Oracle Autonomous Data Warehouse
Which data warehouse cloud platform is faster: Oracle Autonomous Data Warehouse or Snowflake Cloud Data Warehouse? The short answer: it depends. For a more detailed answer, read this blog post. Skiing is not recommended at the moment. Because of the current pandemic situation, it’s better…
Accessing Snowflake from SQL Developer
My first day of work this year was a training day. As a participant in a “Snowflake Fundamentals” training course. I opted for the four-day, multi-week option so that I would have time to better absorb what I had just learned. Tomorrow is my third…
Smart Sizing of Fast Recovery Area in Cloud Environments
This is just to let you know about my recent article, published in Oraworld magazine. If you want to learn how to size FRA in a smart way, don’t hesitate to have a look – Oraworld Edition #23, December 2020.