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
----- Original Message -----
Sent: Thursday, February 06, 2003 1:51
PM
Subject: RE: AIX 4.3.3 / 8.1.7 &
Timed Statistics & Tuning Question
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:[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
******************************************
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130 ******************************************
|