/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

 savvinov.com
Global Hints - Oracle Diagnostician
| | iggyfernandez.wordpress.com
The golden rule of NOT tuning SQL | So Many Oracle Manuals, So Little Time
3.9 parsecs away

Travel
| | Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Do SQL Plan Baselines Use Hints?
2.9 parsecs away

Travel
| | [AI summary] A technical investigation into whether Oracle SQL Plan Baselines store actual execution plans or rely on hidden hints, analyzing database trace files and data dictionary views.
| | jonathanlewis.wordpress.com
Push Group by | Oracle Scratchpad
5.0 parsecs away

Travel
| | Jump to summary. A new optimizer feature that appears in 23c (probably not 21c) was the ability to push group by clauses into union all set operations. This will happen unhinted, but can be hinted with the highly memorable [no_]push_gby_into_union_all() hint that appeared in 23.1.0.0 according to v$sql_hint. and the feature can be disabled by...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way?
18.8 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.