/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

 danischnider.wordpress.com
Star Schema Optimization in Autonomous Data Warehouse Cloud | Data Warehousing with Oracle
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
3.3 parsecs away

Travel
| |
| | chandlerdba.com
SQL Patch, and a Parallel mistake - Neil Chandler's DB Blog
3.4 parsecs away

Travel
| | Photo by Brian Patrick Tagalog on Unsplash July 2024. Oracle 19c, 23ai There are 3 main types of SQL Plan Management: SQL Profile SQL Plan Baseline SQL Patch So first some quick background info about the 3 options and then I'll tell you about my mistake. SQL Profile A SQL Profile is a collections of...
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
3.0 parsecs away

Travel
| | When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...
| | oracletoday.blogspot.com
Oracle Today: Performance of Autotrace
15.6 parsecs away

Travel
| I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...