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

Thread: Tuning

  1. #1
    Join Date
    Jan 2004
    Location
    Douala-Cameroun
    Posts
    21

    Tuning

    Hi,
    I am looking for tools/hints to tune an AIX system running Oracle
    for performance purpose (fix parameters related to oracle).
    Thanks
    Regards
    Consty
    Consty

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well what problems are you having

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    As far as I know it always helped to set the parameter FAST = TRUE

  5. #5
    Join Date
    Jan 2004
    Location
    Douala-Cameroun
    Posts
    21
    Sorry, I was absent for a while.
    Thanks for yours answers.
    Dave,
    I have two problems, 1) memory : looks like the pages are not freed.
    2) cpu : 0% idle, essentialy with certains jobs (requests).
    Regards
    Consty

  6. #6
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    1) Are there any errors on the DB side?

    2) Are all business applications perform according to the specification and within specified response time?

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    statspack / AWR
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Mar 2002
    Posts
    534
    I recommend you to get someone having some Oracle knowledge because from the input you give in this thread I assume that you don't have a lot of experience in the area of Oracle.

  9. #9
    Join Date
    Mar 2006
    Posts
    11

    Thumbs up Basic questions

    Quote Originally Posted by Consty
    Sorry, I was absent for a while.
    Thanks for yours answers.
    Dave,
    I have two problems, 1) memory : looks like the pages are not freed.
    2) cpu : 0% idle, essentialy with certains jobs (requests).
    Regards
    Dear Consty,

    may I suggest a few things?
    First of all are you a database administrator? If yes, first check if you have a valid licence. If you have - I assume you work for a company (AIX- you don't use it at home ;-) - you can register on :
    metalink.oracle.com

    This is my basic everyday use site where 99% of problems I solve reading - not posting problems.

    Based on your questions no one may be able to help you much. I myself set up many, many databases and my suggestion would be:
    - look at your memory consumption, Oracle does not like to be swapped. This often happens when you allocate more than 1/2+ of memory to the SGA. On AIX run:
    lsps -a
    If the percentage of swap usage is high, this could be a performance problem.
    - on metalink you will find a link to admin SQL scripts, there you will also find scripts to monitor some things in a database.
    You will need to check SQL's runing in the database, look for bottlenecks.
    - you can also use trial versions of software:
    www.quest.com
    1) try Spotlite on Oracle, this is a wonderful tool also for beginners.
    2) Toad for Oracle is good as well.

    I hope this helps. I thinks it's going to be a pain for you to use SQL scripts or any standard Oracle tools, I myself have developed some, but this took a lot of time.

    Regards,
    Richard.
    "Whenever you want to learn the basics about Oracle - start from the Oracle Concepts Guide."

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