My new website about reverse engineering challenges/exercises/problems/tasks: challenges.re
"I know one thing for certain; it is much harder to tell whether you are lost than whether
you were lost, for, on many occasions, where you are going is exactly where you are.
I recently experienced a problem when upgrading an old Oracle 10.2.0.4 database to 18.104.22.168 that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was reported by the upgrade script:
Recently I have been looking at the href="https://vaultproject.io/" target="_blank">Vault project as a means to manage secrets for applications and end-users. One of the use cases that immediately drew my attention was the ability to create dynamic role-based MySQL credentials.
There are a few reasons why dynamic credentials would be beneficial, all of which can be handled by Vault, including:
There are currently some limitations to when pragma UDF will speed up your calls to PL/SQL functions.
In my post introducing the new pragma UDF feature of Oracle 12c I explained how it can be used to reduce the impact of context switching when you call a PL/SQL function from SQL.
What makes a great blog post? We all have our pet criteria: sharp prose. Enlightening content. Stunning photos. (“Lots of GIFs?” Sure, why not?) Beyond its style or tone, a standout post invites us to take a peek into another person’s home or field of expertise, and offers a glimpse of that individual’s mind at work.
Here’s an updated presentation I first delivered at Hotsos Symposium 2015.
It’s about lots of concurrent PX direct path insert ant CTAS statements that, when clashing with another bug/problem, caused various gc buffer busy waits and enq: TX – allocate ITL entry contention. This got amplified thanks to running this concurrent workload on 4 RAC nodes:
I used to think that a user with SELECT ANY TABLE and SELECT ANY DICTIONARY could see anything in a database. I found out today that these 2 privileges do not allow you to SELECT from another user’s sequence. You can see what I mean in the example below, which I tested in an Oracle 11.1 database.