Tag: tool

  • Flame Graphs for Oracle

    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

    Explore →

  • A Closer Look at CALIBRATE_IO

    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

    Explore →