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

Thread: Tuning server

  1. #1
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    which are the parameter to be set so get better performance for more SELECT statements.

    clients are accessing thro web. There more select statements than inserts or updates. Some of the queries used to take 10-20 secs to execute. After loading a new module it is taking more time 110-120 secs to retrieve the data for a select statement.

    oracle 8.1.6
    O.S sun 2.7
    Application : WEB application

    [Edited by shashikumar on 02-20-2002 at 05:51 AM]

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    what do u mean more select statements.Please be more clear

    cheese
    anandkl
    anandkl

  3. #3
    Have you analyze your Stats?
    More info required
    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Trace long running statements and query explain plan using TKPROF.

    Use TKPROF results to determine whether full table scans/inefficient SQL/Indexes.

    Read this link.


    http://www.dbspecialists.com/present...e_explain.html
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  5. #5
    Join Date
    Aug 2001
    Posts
    64
    Gurus,
    I've followed the link that Sureshy pointed out, But I'm more confused after reading it. How do you interpret explain plan? Do you read it from inside out, top to bottom, or bottom to top? I don't see the pattern from the examples given on this document. Could some one be kind enough to explain "how do you read an explain plan"? Thanks so much.

  6. #6
    Join Date
    Nov 2000
    Posts
    178
    Hi,

    You read the explain plan from inside out then top bottom.

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