New “Sales History” Sample Schema in Oracle 23c
This post was originally published on this siteThe newest version of the Oracle sample schema “Sales History” (SH) finally contains current data again and is easier to install than the previous versions. If you work with star schemas, the SH schema is a must. Last…
SQL Performance Tips in Execution Plans of Oracle 23c
This post was originally published on this siteOracle 23c is like Christmas for me. There are many surprises to be found. This weekend I discovered another nice little enhancement. In the last days, I developed and tested some demo scripts that I plan to show…
Enhanced Partitioning Metadata in Oracle 23c
This post was originally published on this siteOracle 23c has a lot of small, but useful enhancements that makes life of developers easier. For example two new columns in the data dictionary views for partition metadata. The description of the LONG data type in the…
Oracle Database 23c on a Mac with an M-Series Chip
This post was originally published on this siteStarting Position I got my MacBook Pro 16″ with an Apple M1 Max chip with 10 cores, 64 GB RAM and 4 TB disk in November 2021. At that time, the M1 chip had already been on the…
GROUP BY Extensions in Oracle 23c
This post was originally published on this siteSince a few days, Oracle Database 23c Free Developer Release is available. It contains many new features that are interesting for developers, especially some nice little extensions in SQL that we missed since years. Let’s start with an easy…
IslandSQL Episode 4: Expressions
This post was originally published on this siteIntroduction In the last episode, we extended the IslandSQL grammar covering the complete lock table statement. However, the support for expressions was very limited. It was not possible to use a date literal or to_date function to determine a…
IslandSQL Episode 4: Expressions
This post was originally published on this siteIntroduction In the last episode, we extended the IslandSQL grammar covering the complete lock table statement. However, the support for expressions was very limited. It was not possible to use a date literal or to_date function to determine a…
Memory leak in MySQL 8 with indexed generated virtual columns
This post was originally published on this siteSome time ago we have observed that memory for some MySQL instances has been constantly eaten away. Investigation pointed us to memory/innodb/memory area and databases with tables having generated virtual columns, which in addition were used in indexes….
IslandSQL Episode 3: Lock Table
This post was originally published on this siteIntroduction In the last episode we extended the IslandSQL grammar to cover all DML statements as single lexer token. Now it’s time to handle the complete grammar for one DML statement. The simplest one is lock table. A good…