DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL TUNING!!

  1. #1
    Join Date
    Feb 2000
    Posts
    142
    Hi,
    Does anybody know of any SQL Tuning tools? Also, has anybody heard of SQL Lab?

    Please help.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268

    Reply

    Hi,
    You can use Oracle based tools for tuning.
    Start with Hints. move on to timing and explain plans.
    those should do the job just fine.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Nov 2000
    Posts
    1
    Hi ,

    (1) You can use SQL Navigator provided by Quest Software Lab. There is a feature called SQL Tuning Wizard.

    (2) You can also use TOAD ( Tool for Oracle Application Developer).


    But the best is with EXPLAIN PLAN available in oracle.

    You can refer SQL Tuning tip/tricks books or ref. material for this.


  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Platinum's product SQL-Station has an add-on called Plan Analyzer For Oracle (PAFO) that works quite nicely. I disagree that EXPLAIN PLAN is sufficient for optimizing SQL. Besides the fact that it is cumbersome to use and ugly, it, like most Oracle functionality, is useful only if you already know how to use it. With PAFO, all of your choices are laid out in front of you. You can easily paste in a statement and see the 3 main optimizer plans with little legends and help to explain what's going on. You can also add hints if you so choose, with explanations of what each hint does. You can then actually run the statements (safely, as DML is automatically rolled-back). It times them and gathers all the necessary statistics for you. You can then compare and contrast various plans from various viewpoints. Mind you, I am certainly not saying this is the end-all, be-all of tools, as it has its share of issues, not the least of which is that it leaks like the Titanic. But it beats the pants off of 'EXPLAIN PLAN by itself'.

    - Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width