Bug 30324180 SQL Macro should be backported to 19.5
While reviewing the list of bugs fixed in 19.6, I found that Oracle backported SQL Macros to 19.6 judging by the bug description.
While reviewing the list of bugs fixed in 19.6, I found that Oracle backported SQL Macros to 19.6 judging by the bug description.
A practical demonstration of performing unattended Grid Infrastructure Out of Place patching using opatchauto and property files.
SQL92_SECURITY has changed its default value to TRUE
starting from 12.2.0.1: Upgrade Guide.
That might lead to ORA-01031: insufficient privileges
errors being thrown in runtime as this post demonstrates.
I have recently optimized one of processes working with LOBs and decided to write a blog post about it.
Our developers were using WWV_FLOW_API.SET_SECURITY_GROUP_ID
and were surprised to find that that procedure behaves differently in 12.2 than in 12.1.
A practical demonstration of how to use custom wrap tables to affect Oracle wrap behavior.
In this blog post, I will show how I discovered the Oracle Wrap substitution table by reverse engineering Oracle binaries.
I have stumbled upon this bug after upgrading one of my databases to 12.2.0.1 when one of application queries started returning extra rows.
I remember watching a video about Amazon Aurora Serverless where it was demonstrated that your database can be started on demand when the first connection comes. Although it is not something that you might want for your 24x7 OLTP database, it can come in handy for Development environments that have the intermittent usage pattern. I decided to write a blog post about how that can be done for an Oracle Database server working on a systemd-based Linux Operating System.
Database triggers are notoriously known for slowing down DML operations. Yet, they lead to a remarkable consequence while applying to the first post of this series in which I demonstrated statement restarts within a single user session updating a non-partitioned table.