Explore >> Select a destination

You are here

 jonathanlewis.wordpress.com
Clean it up | Oracle Scratchpad
| | mikedietrichde.com
Adding the Oracle 19.14.0 OCW / GI bundle patch to my database home
6.9 parsecs away

Travel
| | Adding the Oracle 19.14.0 OCW / GI bundle patch to my database home is an interesting topic - do you need to apply the GI RU to the DB Home?
| | antognini.ch
Impact of Direct Reads on Delayed Block Cleanouts - Striving for Optimal Performance
3.9 parsecs away

Travel
| |
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
4.8 parsecs away

Travel
| | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....
| | mauro-pagano.com
"When the going gets tough, the tough get going" aka SQLT XPLORE | Mauro Pagano's Blog
22.5 parsecs away

Travel
| When upgrading a database sometime you find that one or more SQLs run slower because ofa new and suboptimal execution plan. Usually the number of those SQLs is pretty small compared to the overall workload but it's not straightforward to understand what caused the plan change so even a small number can become tricky to...