Tag: block

  • Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization

    Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization

    Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization Topic: This post is about the latest updates to PerfSheet4 v3.7 (February 2015). PerfSheet4 is a tool aimed at DBAs and Oracle performance analysts. It provides a simplified interface to extract and visualize AWR time series data using Excel pivot charts. Why

    Explore →

  • 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 →