1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

SQL Tuning ?

Discussion in 'SQL PL/SQL' started by kiran.marla, Jul 28, 2010.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Please help me in SQL Tuning in step by step method.
    what is EXPLAIN PLAN, tkprof, Trace ?

    Kiran Marla
     
    mgraceparth@gmail.com likes this.
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi Kiran,

    There are several aspects to what is popularly referred as SQL tuning. Explain plan is basically how oracle finds or writes data. tkprof is a tool to analyze the trtace files. These are basics which one needs to just read up and practice. :) Nothing to worry it's all quite simple.
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Thanks to Zargon and Sadik