/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

 oracle-randolf.blogspot.com
Oracle related stuff: Oracle 19c RU Release Update 19.19 nice little enhancement: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
3.7 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...
| | jonathanlewis.wordpress.com
dbms_xplan - again | Oracle Scratchpad
3.5 parsecs away

Travel
| | 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...
| | joze-senegacnik.blogspot.com
Understanding Oracle: Maintaining Tempfile in TEMP Tablespace of PDB$SEED in Oracle 12c (12.1.0.2)
3.1 parsecs away

Travel
| | During testing recovery procedures for one of the ongoing projects I wanted to test the "complete disaster" recovery scenario. In this scen...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
17.2 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.