RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

[Koivu, Lisa]

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

Hi Ethan,

 

Thanks so much for your reply.  I'll have to check which patch level we are on.

 

Have a great day!

Lisa

-----Original Message-----
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit.

 

Lisa,

 

Be aware that there are some issues with ML9 as I am finding out with swap.  We are planning on going to ML10 which should fix the problem as well as using vmtune command to change the system to use less OS Cache for files, I forgot the exact syntax.  Happily the problem on these boxes is rare and no one complains so I am not rushing to make the changes but if you are running app servers on the same host you could see this a lot possibly.  Search the AIX group on google for "vmtune oracle" and also check out the new Database Tuning book at IBM Redbooks, it was released in the past couple of weeks so it should be easy to find.  It talks about all the vmtune settings.  Also we are seeing issues with some of the psoft processes (Solaris app server) using up all the memory on the box when one of the jobs is run (not sure which one), appears to be a memory leak of some sort, we are working on it (just a note, the peoplesoft environment is not the AIX environment I spoke about).

 

- Ethan

-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Subject: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

Good morning everyone -

Quick poll for those of you on 8.1.7 and AIX 4.3.3: 

Do you have TIMED_STATISTICS = true?  Have you encountered any problems with it?

The databases I inherited have this set false all over the place, hence my tuning efforts are really limited.  However I don't want to change it without checking around first.

And a tuning question:

This environment (peoplesoft) is very very low on memory.  When the app servers and databases are up there's less than 50MB of memory free.  Adding hardware is not a choice here.

The databases have 100MB set for the SGA.  It really looks like not much thought went into some of the parm settings. 

What I've read about tuning says that you must have a goal in mind.  Well, afaik nothing is "broken", nothing is suffering - then again, no one really paid much attention to Oracle.  It was up, fine, move on.  Am I on the wrong path if my goal for tuning is to figure out if I can reduce the size of the SGA and redo logs without adversely affecting performance?

Any comments are appreciated.  Thanks everyone

Lisa Koivu
Oracle Dingbat Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117 
Fax:    954-935-3639
Cell:    954-683-4459