Tuning

[Consty]

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

[davey23uk]

well what problems are you having

[abhaysk]

guidelines to ask question

[mike9]

As far as I know it always helped to set the parameter FAST = TRUE

[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

[pss]

1) Are there any errors on the DB side?

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

[Thomasps]

statspack / AWR

[mike9]

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.

[rysiekmus]

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.