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

Thread: How to increase application performance?

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    Post

    Good morning all,

    I am looking for lists of guidelines or tips for writing efficient sql queries to help to increase application performance and query tunning, and the reasons of using them. These tips including using NOT EXISTS instead of NOT IN and never use NOT on an indexed column etc. If you have the lists, can you share with me? You can send them to wujee@yahoo.com. Or can you send me a link where I can find them?

    Thanks

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    select executions, disk_reads, buffer_gets, sql_text from v$sql where disk_reads >100 order by disk_reads ;


    take the sql statement which has the most disk reads..

    try to get the execution path by using the explain plan ...

    see whether the table
    has indexes
    how many rows
    if there is index will it improve the performance ...

    try doing it within days you will catch up ...
    Radhakrishnan.M

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    If you have Metalink acess , pl search for SQL Tuning , you see very good documents ..

    http://metalink.oracle.com/metalink/...1&blackframe=0

    May be the above link will help you

    Thanks,
    Madhu

  4. #4
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    Read the performance and tuning manual.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  5. #5
    Join Date
    Nov 2000
    Posts
    164
    Thank you, thank you, thank you all!

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