/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 antognini.ch
Impact of Direct Reads on Delayed Block Cleanouts - Striving for Optimal Performance
| | blog.tanelpoder.com
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) | Tanel Poder Blog
2.8 parsecs away

Travel
| | Hello all fellow Oracle geeks and technology enthusiasts! Long time no see ;-) In the hacking session about Oracle full table scans and direct path reads I explained how the direct path read decision is not done by the optimizer, but instead during every execution, separately for every single segment (partition) scanned in the query. I also explained how the _small_table_thresholdparameter and theX$KCBOQH.NUM_BUF(which keeps track of how many buffers of any segment are currently cached) are used for determining whether to scan using direct path reads or not. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.
| | hoopercharles.wordpress.com
True or False - Undo | Charles Hooper's Oracle Notes
2.9 parsecs away

Travel
| | May 9, 2010 (Back to the Previous Post in the Series)(Forward to theNext Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers,if the answers to those questions depend on the source of the informationfound through Internet searches. Today's quiz is on the topic...
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
4.3 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....
| | dht.is
[Solved]: Use Piwik Pro Progressive Web App analytics in a vanilla html and javascript project ยท Dylan Hatfield Thomas
59.3 parsecs away

Travel
| Background I was packaging up a website as a PWA (progressive web application) so that it could be used offline at a conference, and I wanted to have some analytics collected while offline. After a lot of searching, I came across Piwik Pro, a capable analytics package that specifically included capabilities for offline analytics tracking. Perfect! However, their code assumes that you are building your project using a framework with a packaging-based workflow. My project was simple, vanilla html and javascript.