In many cases we see a new child cursor for existing SQL. You can see the children and their information in V$SQL (where CHILD_NUMBER identifies the child). To see the
Did You Know #34 – DST Patches with PDBDid You Know #34 – DST Patches with PDB
When I worked on Oracle Cloud 20c for my Data Dictionary Changes post, I ran into a problem with DST difference. Oracle 20c (20.2) is coming with DST V34 while
Creating a Public Accessible 20c Database VM on Oracle CloudCreating a Public Accessible 20c Database VM on Oracle Cloud
Lately I started playing with Oracle 20c and the cloud. I had a few issues with configuring the DB VM and accessing it from home, so here is a short
19.6 vs. 20.2 Data Dictionary Changes19.6 vs. 20.2 Data Dictionary Changes
In this post I’ll show what’s new in 20.2 Data Dictionary. To see comparison between other versions, check this post. Interesting additions are: Blockchain tables SQL macros Some details related
Scratch Projects for KidsScratch Projects for Kids
As you probably know, I live in Vancouver, BC, Canada. BC for now is not under a complete lock down, but schools are closed (and it’s unclear what will happen
Oracle Data Dictionary ChangesOracle Data Dictionary Changes
As Oracle releases new versions, there is a lot of information about new major features, but sometimes small changes are unnoticed. I decided to check the differences in the Oracle
18.9 vs. 19.6 Data Dictionary Changes18.9 vs. 19.6 Data Dictionary Changes
In this post I’ll show what’s new in 19.6 Data Dictionary. To see comparison between other versions, check this post. Interesting additions are: Views/columns related to automatic indexing Some V$ALL
12.2.0.1 vs. 18.9 Data Dictionary Changes12.2.0.1 vs. 18.9 Data Dictionary Changes
In this post I’ll compare the Data Dictionary tables and columns between 12.2.0.1 and 18.9. To see comparison between other versions, check this post.
Cancelled ConferencesCancelled Conferences
Two weeks ago I published a post about upcoming conferences I will be presenting at. Well, things have changed…
Did You Know #33 – Updating an Entire RowDid You Know #33 – Updating an Entire Row
The background story for that is long and complex, so I won’t get into it. I’ll just say that it was related to replication and I wrote a procedure to