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.
PDB_OS_CREDENTIAL and PL/SQL external libraries
In the previous blog post I have described PDB_OS_CREDENTIAL initialization parameter and when it can help you in isolating PDBs from each other. Today I’ll show you an example of how it works with PL/SQL external libraries. Of course we need to setup the whole…
2020: A Virtual Year
I just presented my last session this year on Trivadis DevDays 2020. Like most conferences in 2020, it was a virtual event. 13 of 16 conference sessions in the last twelve months I was presenting from home. Time to look back to this very special…
Social Media @trivadis