I upgraded a test database not too long ago to 18.6 (to do proper testing before we start upgrading productions) and got a feedback from dev that one of the
Tag: bug
Upgrade Oracle Restart to 18cUpgrade Oracle Restart to 18c
It seems like there are not many Oracle Restart environments (or there are but Oracle doesn’t pay too much attention to them). Otherwise, I can’t explain why I couldn’t find
Strange Index BehaviorStrange Index Behavior
During a performance problem I had with a query I wanted to create an index on the table. Since this was a large table I wanted the index to include
Top-N QueriesTop-N Queries
This is an old story. It started in 2015 when I found a problem with TOP-N query performance. I wrote a blog post about it and later an update. Here
Bug When Patching ProductionBug When Patching Production
I had a bad night last Thursday.After patching two test RAC databases and one production RAC with 180417 DB Bundle Patch (and some one-offs), I got to the point where
One-off Patch FrustrationOne-off Patch Frustration
Lately I started patching a client’s database (12.1.0.2) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time
Non-existent Objects (and possibly a bug)Non-existent Objects (and possibly a bug)
This post is following a question I found on LinkedIn. A DBA pasted a strange test case in 11.2.0.4 and I managed to reproduce it in 12.1.0.2 (non-multitenant) and 12.2
Researching a BugResearching a Bug
A few months ago we hit an Oracle bug related to streams replication crash after creating an index (bug 21320182). There is a patch so we installed the patch in
Datapach issuesDatapach issues
This week I worked on a messy patch. I have a RAC environment with 12.1.0.2 and an old PSU and all kind of one-off patches and I wanted to install
V$LOCK Missing InformationV$LOCK Missing Information
In our first BCOUG Tech Day conference, I presented my session “Look Inside the Locking Mechanism”. I presented this topics before a few times and prepared a few demos to