Skip to content

SQLMDX

Eventually it's all about data

  • About
  • Contact

Blogroll

  • Database Whisperers
  • Frits Hoogland
  • Jonathan Lewis
  • Miladin Modrakovic
  • Sayan Malakshinov
  • Tanel Poder

Categories

  • Oracle
  • Perl
  • PowerShell
  • Python
  • R
  • Scala

Archives

  • May 2020
  • April 2020
  • March 2020
  • July 2016
  • May 2016
  • March 2016
  • December 2015
  • October 2014
  • September 2014
  • May 2014
  • December 2013
  • November 2013
  • March 2011

Tags

12c 10053 built-in packages CBO differentiation domain indexes Extensible Indexing Extensible Optimizer external procedures internals materialized views OLAP parallel execution partitioning performance tuning regular expressions sqlplus sql trace transformations

sql trace

Recursive calls and statistics

There are many cases when executing some statement (either SQL or PL/SQL) may invoke execution of another SQL or PL/SQL statement.
However it’s not at all obvious how execution statistics for cursors are aggregated.
Continue reading →

Comment
May 11, 2014October 22, 2016 sqlmdx
performance tuningsql trace
Create a website or blog at WordPress.com