Cost-Based OR Expansion Transformation
OR expansion not working properly in Oracle 12.2 Continue Reading
Oracle
Event Propagation in Oracle 12.2
Troubleshooting event propagation in Oracle 12.2 Continue Reading
Debugging Session Creation
Attaching gdb to a dedicated process immediately after forking Continue Reading
Memory Leak During Parsing
Memory leak during parsing in Oracle 12c Continue Reading
Checkpoint Analytics
Analyzing checkpoint information in alert log with SQL analytic functions Continue Reading
Large TCHK Allocations in Shared Pool
Large TCHK allocations in shared pool caused by create table as select Continue Reading
How to Prevent Overwriting of Oracle local bin Scripts
Invoke root.sh with -bindir option to prevent overwriting of Oracle scripts in /usr/local/bin. Continue Reading
Oracle JDBC Security
Some JDBC drivers use lower, less secure authentication protocols than the regular clients of the same version. Continue Reading
Bind Variable Peeking vs. Parameter Sniffing
Comparison of bind variable peeking in Oracle with parameter sniffing in SQL Server Continue Reading
Comparison of a Cardinality Estimate in Oracle and SQL Server
This blog post is a short observation on assumptions that Oracle and SQL server optimizers make for estimating cardinality of a rowset obtained after applying an equality predicate which contains different columns of the same table. Continue Reading