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

Thread: db perf tuning

  1. #1
    Join Date
    Jul 2002
    Posts
    3
    Can someone list the steps to undertake a perf tuning process of a
    database thats running slow. If you have any code snippets or tools to
    diagnose that would hel me tremendously too.

    Thanks,
    Beth
    Beth

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Oracle's tuning methodology is a ten-step process:

    1. Tuning the business rules
    2. Tuning the data design
    3. Tuning the application design
    4. Tuning the logical structure of the database
    5. Tuning database operations
    6. Tuning the access paths
    7. Tuning memory allocation
    8. Tuning I/O and physical structure
    9. Tuning resource contention
    10. Tuning the underlying platform(s)

    Any one of these areas can affect other areas. Where exactly would you like me to start?

  3. #3
    Join Date
    Jul 2002
    Posts
    3
    Looks like our problem is with the sql. What steps do i need to take for sql tuning? This is a web application. Thanks...
    Beth

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    All the resources that you are interested in

    Reddy,Sam

  5. #5
    Join Date
    May 2002
    Posts
    37
    There are a lot of different aspects that could result in database slow down.
    For SQL tuning, some of the steps that could be taken are:
    1. Check contention for db_blocks.
    2. Buffer Cache Hit Ratio
    3. SGA memory usage, may be you need to increase shared_pool_size
    4. Make sure you have optimizer_mode = CHOOSE
    5. Tables and indexes should be analyzed.
    6. Generate explain plans for SQL statements and try to tune them, to reduce cost, force SQL to use indexes and avoid full table scans.

    You will find a usefull scripts at this URL http://www.think-forward.com/sqltips.htm[/url]

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