Explore >> Select a destination

You are here

 dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way?
2.3 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | blog.tanelpoder.com
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) | Tanel Poder Blog
0.6 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.
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Baselines and SQL_ID
2.3 parsecs away

Travel
| |
| | www.bobbydurrettdba.com
Using coe_xfr_sql_profile.sql to force a good plan | Bobby Durrett's DBA Blog
15.0 parsecs away

Travel
| Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe...