Blog - Page 5 of 25

Did You Know #35 – New Child Cursor Creation ReasonDid You Know #35 – New Child Cursor Creation Reason

April 30, 2020 | Liron Amitzi | 0 Comment | 9:06 am

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

April 21, 2020 | Liron Amitzi | 0 Comment | 9:41 am

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

April 16, 2020 | Liron Amitzi | 0 Comments | 4:06 pm

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

April 14, 2020 | Liron Amitzi | 2 Comments | 9:04 am

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

March 30, 2020 | Liron Amitzi | 0 Comments | 10:14 am

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

March 23, 2020 | Liron Amitzi | 4 Comments | 10:03 am

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

March 23, 2020 | Liron Amitzi | 0 Comment | 10:00 am

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

March 23, 2020 | Liron Amitzi | 0 Comment | 9:59 am

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

March 17, 2020 | Liron Amitzi | 0 Comment | 10:02 pm

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

March 10, 2020 | Liron Amitzi | 0 Comment | 8:32 am

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