/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

 jarneil.wordpress.com
Some thoughts on the April CPU | jarneil
| | jagjeet.wordpress.com
Library cache: mutex X | Jagjeet's Oracle Blog!
8.6 parsecs away

Travel
| | Recently, I was engaged in Exadata POV for benchmarking for Ebiz R12 on Exa* boxes. We had quarter rack running 11.2.0 db with 2 node RAC Cluster (24 CPU) and all other components/Middle Teir including Form, Web, CM were configured on Exalogic Server. Objective was to achieve best possible scalability numbers on Exa* boxes for
| | alexzeng.wordpress.com
Outline, SQL profile and SQL Plan Management(SPM) | Alex Zeng's Blog
7.2 parsecs away

Travel
| | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...
| | savvinov.com
Performance issues around GTT in 19c - Oracle Diagnostician
14.0 parsecs away

Travel
| | It has been (unforgivably) long since my last blog post so let me try and rehabilitate myself by posting a couple of recent interesting investigations. I'll start with one that combines two of my favourites: stack profiling and "twittershooting" (collective troubleshooting using Twitter as a collaboration tool). The database in question is a 3-node RAC...
| | jonathanlewis.wordpress.com
Transitive Closure | Oracle Scratchpad
19.8 parsecs away

Travel
| I have mentioned transitive closure in the past, and the commentson this blog item go into some depth about some of the effects of transitive closure. However, arecent incoming link has prompted me to point out a couple of further details about the appearance (or non-appearance) of transitive closure. We start with three (virtually) identical...