Minimum sga_target
Database won’t start after a hardware/OS change or a database upgrade?
You can monitor critical conditions and prevent unpleasant surprises. Continue Reading
Author: Nenad Noveljic
Flashback Data Archive DDL Bottleneck
Undocumented flashback data archive internals Continue Reading
Bypassed Subquery Unnesting for Anti Join
Columns instead of constants in the SELECT clause of a NOT EXISTS subquery can lead to bad execution plans. Continue Reading
Anti Join with Range Predicate
Performance issue in the Avaloq backend/frontend interface Continue Reading
Why Replacing an OJDBC Driver in Oracle Cloud Control Installation is a Bad Idea?
A custom OJDBC driver can break patching Continue Reading
Improving Chia Farm Resilience
Monitoring, autocorrection and boot scripts for Chia farming services Continue Reading
Using Spare Windows Machines for Chia Plotting
Automated Chia plot transfer from Windows to the farming node Continue Reading
Automating Chia Plotting on Ubuntu
Chia plotting is both CPU and IO intensive. You can run several plots in parallel until you hit a bottleneck. Plotting in parallel will increase the processing time, but also the throughput. The goal is to maximize the number of… Continue Reading
TNS-12599: TNS:cryptographic checksum mismatch
Older JDBC versions causing TNS-12599: TNS:cryptographic checksum mismatch Continue Reading
Three Ways to Suspend an Oracle Process
While analyzing complex problems and researching internals in Oracle database, I’ve often had to observe process interaction in slow motion. This requires temporarily suspending a process until another process finishes a relevant chunk of work, and then resume the suspended… Continue Reading