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.
Заметки¶
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 initially checked that preposition, I was a little bit puzzled by the behavior discussed in this post.
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 license terms.
Bitmap Conversion to ROWIDs with Global Indexes
While working with developers on optimizing a query, I discovered a limitation of the BITMAP AND operation.
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 the root cause of that issue and constructed a simple test case that can be used to reproduce it.
Asynchronous Global Index Maintenance and Recycle Bin
Got an Oracle error ORA-38301: "can not perform DDL/DML over objects in Recycle Bin" in the alert log.
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 by SQLPATH, is not invoked anymore.
ORA-3180 on Active Data Guard standby database
Got a call asking me to provide advice on the cause of ORA-3180 error on an Active Data Guard standby database instance
DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
I have recently discovered a case when DBMS_METADATA.GET_SXML_DDL returns incorrect DDL for a trigger in an EBR environment.
A lot of log.* files in dirbdb directory
After adding ENABLEMONITORING in the GLOBALS file, I noticed that the $OGG_HOME/dirbdb directory started growing.