| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
By the way, Lisa. AIX 4.3.3 is being desupported. We are testing 9i on AIX5.2 as I write this. I could not get the powers that be to move away from 8.0.x and now we are jumping right to 9i. I did install 8.1.7 and use OEM2.2, but that won't support a 9i database. I will install the new OEM tomorrow or Monday.
Ruth
Lisa,
Try oslevel -r at the command promt. It should tell you.
-Scott
At 09:49 AM 2/6/03 -0800, you wrote:
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:Ethan.Post_at_ps.net]
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:Lisa.Koivu_at_efairfield.com]
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
******************************************
Scott Stefick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 06 2003 - 13:23:25 CST
 |
 |