/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

 orastory.wordpress.com
SQL_IDs and baselines | OraStory
| | blog.yannickjaquier.com
SQL Plan Management
1.6 parsecs away

Travel
| | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile
| | oracleprof.blogspot.com
Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
0.9 parsecs away

Travel
| | SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
1.7 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.
| | jonathanlewis.wordpress.com
Push Group by | Oracle Scratchpad
12.2 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...