Страницы

▼
суббота, 11 июля 2020 г.

ORA-600 [kglobpg_is_pkp] During Rolling RU 19.7 Apply

›
I came across this issue while applying RU 19.7 to my RAC database. That was the old ORACLE_HOME: [oracle@rac1 dbhome_1]$ OPatch/opatch ls...
суббота, 13 июня 2020 г.

CURSOR Expressions Return Wrong Results in 18c/19c

›
That is a wrong results issue I stumbled upon this morning. A developer told me that one of their queries started returning wrong results af...
вторник, 9 июня 2020 г.

OR Expansion and Virtual Columns: Changes in 19c

›
This post is a continuation of my previous one: OR Expansion and Virtual Columns . The last post demonstrated that OR Expansion can somehow ...
четверг, 21 мая 2020 г.

OR Expansion and Virtual Columns

›
The following test case can be used to demonstrate a little peculiarity of the OR Expansion transformation, that was introduced in 12.2. It...
четверг, 30 апреля 2020 г.

Secure Use of Runtime.exec Functionality in Oracle Database

›
Developers wanted to call external programs from the database using a Java class. By default, those commands are run under the database user...
вторник, 3 марта 2020 г.

Using LogMiner to Identify Redo Tag for Transactions

›
I was asked if there is a way to identify what redo tag was set for a specific transaction. There is a document that answers the question ...
суббота, 1 февраля 2020 г.

Tracing SQL Macro Expansion

›
I decided to take a look at what events Oracle provides to diagnose or troubleshoot SQL Macro Expansions. For that, I took almost the same ...