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…
IT-Tage 2020: Privilege Analysis mit der Oracle-Datenbank
Herzlichen Dank allen, die meinem Vortrag auf den IT-Tagen 2020 unter dem Titel „Oracle Security: Von ‚Was hättet ihr denn gerne?‘ zu ‚Was braucht ihr wirklich?’“ über das Feature „Privilege Analysis“ zugehört haben. Den Vortrag gibt es hier zum Download. Nachdem ich 2019 zum ersten…
PDB_OS_CREDENTIAL and external jobs
After introduction of Multitenant option, Oracle provided additional ways to ensure proper isolation between pluggable databases. PDB_OS_CREDENTIAL initialization parameter is part of them. It allows to use specified operating system user while interacting with operating system from a PDB. According to documentation, it is taken…
How to generate DDLs of existing lockdown profiles
In my last blog post I mentioned that I’ll write a new one on how to generate DDLs to recreate existing lockdown profiles – the time has come :). When I had to do it for the first time, I thought it would be as…
Behind the Scenes: Preparing a Live Demo
One of the extensions in Oracle 20c is the possiblity to use the In-Memory Database option for Partitioned External Tables and Hybrid Partitioned Tables. In my opinion, this opens up many possibilities to perform efficient ad-hoc queries on Data Lakes. That’s why I prepared a…