Database Tuning (MOSC)

MOSC Banner

How I Monitor WAITS to help tune long running queries

User502553-Oracle
User502553-Oracle Posts: 21 Blue Ribbon

Comments

  • user12027285
    user12027285 Posts: 9 Green Ribbon
    Hi,

    This document is very useful for tunning waits.

    Can you please clarify the following.

    WAIT_RATIO
    -------- ----------------------------------- ------------------------------
    13 db file sequential read INVENTORY_PK 85 ===> what does this wait ratio indicate.
    13 db file scattered read STORES 10     10
    13 db file sequential read ITEMS_PK      2 

    1] Is it 85% .. ,out of 100% spent for executing the query.

    2] how can we measure the value 85 in terms of minutes/secons etc in lay man language.

    Appreciate you kind response on the above query.

    thanks,

    bipsy.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center