How to Send Messages to AWS SQS from PL/SQL Using UTL_HTTP
This blog post provides a complete example showing how to send messages to an AWS SQS queue.
2021¶
Patching with OPatch Failed with Undefined Reference to __libc_csu_fini __libc_csu_init due to Wrong Libc Library
Patching an Oracle Home failed on one cluster node with the error undefined reference to __libc_csu_fini.
Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
I was intestigating why a simple SELECT * FROM GV$SQL started working much slower in 19c compared to 11.2.0.4.
It turns out Oracle introduced some changes there in 18c.
This blog post is written to demonstrate the new behavior.
Strict Redaction Semantics
A DBMS_REDACT issue has recently popped up on SQL.RU.
This post analyzes the issue and shows a possible workaround.
Oracle to PostgreSQL Replication: Numbers Truncated to 6 Decimal Places
I configured an initial load from Oracle to PostgreSQL, and found that some numbers were truncated after the load, e.g. Oracle number 123.0123456789 happened to be 123.012346 in PostgreSQL.
Let us find out how to avoid this.
Create Standby Skip Pluggable Database
This post demonstrates how to create a standby database excluding some pluggable databases of the primary database.
CHA Alert CHA_DBWR_CKPT_IO_COMPLETE in OEM
A customer was getting the CHA_DBWR_CKPT_IO_COMPLETE alerts from Oracle Enterprise Manager (OEM).
This post investigates the root cause.
SU bypassed: More than 1 column in connect condition
A recent thread on Oracle-L discussed a CBO regression that was encountered following 19.8->19.9 Release Update application.
Tracing Library Cache Locks Using _kgl_debug
A recent blog post from Nenad Noveljic prompted me to review the library cache tracing facilities available in Oracle database.
Diagnosing Cluster Verification Utility (CVU) Errors
A cluster verification utility (CVU) command failed with the PRVF-5157 and PRVF-5431 errors.
This post demonstrates how the errors were diagnosed and the root cause was identified.