/explore
|
You are here 
|
tanelpoder.com | ||
| | | | |
jonathanlewis.wordpress.com
I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a... |
|
| | | | | ||
| | | | |
optimizermagic.blogspot.com
This blog post has moved here http://blogs.oracle.com/optimizer/entry/whats_changed_between_my_new_query_plan_and_the_old_one |
|
| | | | | ||
| | | | |
www.dbaglobe.com
A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. |
|
| | | | | ||
| | | | |
dincosman.com
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.... |
|
| | | |||
