Страницы

▼
суббота, 11 мая 2019 г.

Concatenation and filter subqueries oddity

›
While investigating a poor query performance issue, I came across the following Real-Time SQL Monitoring report from a 12.1 database: Globa...
понедельник, 8 апреля 2019 г.

PL/SQL Create or Replace Optimization

›
Oracle said in their Student Guide for 12c that a local user cannot utilize system privileges on a common user's schema. When I initial...
суббота, 30 марта 2019 г.

wget one liners to download data from *.oracle.com without human intervention

›
When the topic of downloading Oracle software comes up, there is a common misconception that it requires a human intervention to accept the ...
воскресенье, 17 марта 2019 г.

Bitmap Conversion to Rowids with Global Indexes

›
While working with developers on optimizing a query, I discovered a limitation of the "BITMAP AND" operation. Here is an example ...
понедельник, 25 февраля 2019 г.

Index full scan min/max scans returning wrong results on partitioned tables

›
A developer has recently shown me an interesting wrong results issue in one of our 12.1.0.2 databases. Having investigated it, I identified...
воскресенье, 30 апреля 2017 г.

Asynchronous Global Index Maintenance and Recycle Bin

›
Got Oracle error ORA-38301: "can not perform DDL/DML over objects in Recycle Bin" in an alert.log: ORCL(3):Errors in file /u01/ap...
среда, 15 марта 2017 г.

SQL*Plus 12.2 and searching path of login.sql

›
Having installed Oracle Database 12.2 on a client, I have noticed that the login.sql script, which is placed in a custom directory specified...