xtender's blog

Deterministic function vs scalar subquery caching. Part 1


I recently did a comparison caching mechanisms of scalar subquery caching(SSC) and deterministic functions in 11.2. Unfortunately, I do not have enough time to do a full analysis, so I will post it in parts.

Just another version of Tom Kyte’s runstats (runstats_pkg)


I want to share my modifications of Tom Kyte's runstats package, which include:

  • Any number of runs sets for analyzing

  • Standalone: No need to create other objects

  • Ability to specify session SID for statistics gathering

  • Ability to specify what to gather: latches, stats or both

  • Separate mask filters for output by statname and latchname

  • Ability to specify difference percentage for output separately for latches and statistics

Subscribe to RSS - xtender's blog