I am looking for tools/hints to tune an AIX system running Oracle
for performance purpose (fix parameters related to oracle).
well what problems are you having
"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"
As far as I know it always helped to set the parameter FAST = TRUE
Sorry, I was absent for a while.
Thanks for yours answers.
I have two problems, 1) memory : looks like the pages are not freed.
2) cpu : 0% idle, essentialy with certains jobs (requests).
1) Are there any errors on the DB side?
2) Are all business applications perform according to the specification and within specified response time?
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.
Originally Posted by 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 :
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:
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:
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.
"Whenever you want to learn the basics about Oracle - start from the Oracle Concepts Guide."
Click Here to Expand Forum to Full Width