A developer came to me the other day to ask me about an ORA-04036 error he encountered.
The goal of this blog post is to provide steps to troubleshoot the ORA-04036 error without modifying the source code.
That is another optimizer issue I came across this week while working with developers on tuning application queries.
I have recently investigated why there are some databases in my environment which are shown with empty OSDBA or OSOPER groups.
I was migrating several databases from AWS EC2 non-Nitro based instances to Nitro-based ones when I came across one issue with Oracle Recovery Manager (RMAN). This blog post is about it.
ORA-01031 select V$RESTORE_POINT in PL/SQLThis blog post is about an issue with V$RESTORE_POINT and ORA-01031 that I encountered after upgrading one database to 12.2.
After applying the 12.2.0.1.190416 Release Update (RU) patch, I noticed that the target version had not been updated.
While investigating a poor query performance issue, I came across the following Real-Time SQL Monitoring report from a 12.1 database.
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 interventionWhen the topic of downloading Oracle software comes up, there is a common misconception that it requires a human intervention to accept the license terms.
ROWIDs with Global IndexesWhile working with developers on optimizing a query, I discovered a limitation of the BITMAP AND operation.