A question about the subject appeared on Oracle-L today here asking how to trace a known SQL statement executed by a certain user. This post is written to demonstrate my solution to this problem.
There has been a tweet recently saying that VARRAY is faster than CLOB.
I found that it is generally not the case, and conducted additional tests to support this statement in this post.
Since 21c it is now possible to use credential objects in database links. This post demonstrates the new capability.
Encountered an error related to clock synchronization checks ran during Grid Infrastructure configuration. This post demonstrates how the issue was analyzed and resolved.
Oracle introduced a new parameter read_only in 21c which is not documented in Database Reference yet at the time of this writing.
It allows to enable read-only mode for a user session, preventing any writes.
This post demonstrates how it works.
Creating a pluggable database (PDB) by plugging an unplugged PDB in 19.12 can fail with the ORA-7445 kpdbfSourceFileSearch error.
Somehow there is no information about this error on MOS, so that I am sharing it in this post along with the solution that helped in my case.
ORA-22835 was encountered following a database upgrade.
This post explains why it happened and provides an undocumented workaround.
There was a Linux server that got periodic kernel: blk_update_request: I/O error, dev fd0, sector 0 errors in /var/log/messages.
This post demonstrates how I troubleshooted the issue.
Encountered an ORA-15066 preventing an ASM disk group mount.
This post shows how the issue was analyzed and a workaround found.
Let us investigate how to make DBMS_SCHEDULER.CREATE_JOB support transactions.