Tag: REST
-
Oracle Optimizer Investigated with Flame Graphs
Oracle Optimizer Investigated with Flame Graphs Topic: This post is about investigating the Oracle Optimizer using stack sampling and flame graphs. We will see how the complexity of the Optimizer has increased over the years and in particular with the introduction of cost-based optimization and more recently with 12c adaptive optimization. Context and goal: Stack
-
Flame Graphs for Oracle
Flame Graphs for Oracle Topic: This post is a hands-on introduction to using on-CPU Flame Graphs for investigating Oracle workloads. This technique is about collecting and visualizing sampled stack trace data to analyze and troubleshoot Oracle processes at the OS level (in particular applied to Linux). Motivations: The techniques and tools described here can be
-
A Closer Look at CALIBRATE_IO
A Closer Look at CALIBRATE_IO Topic: This blog entry is about investigating Oracle’s DBMS_RESOURCE_MANAGER.CALIBRATE_IO Spoiler: For quantitative analysis of storage performance and in particular for measuring random read I/O in Oracle, I’d rather advise the use tools that allow generating test workloads in a controlled manner, in a way that can be understood and measured