Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

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

From: Koivu, Lisa <Lisa.Koivu_at_efairfield.com>
Date: Thu, 06 Feb 2003 13:48:40 -0800
Message-ID: <F001.005466C8.20030206134840@fatcity.com>


OMG are you KIDDING  

Do you know when?? I just found out (as you may remember from my "Just Shoot Me" post) that IBM's version of desupport is "don't even ask us".  

Thank you so much Ruth for pointing this out.  

Have a great day.
Lisa

-----Original Message-----

Sent: Thursday, February 06, 2003 2:23 PM To: Multiple recipients of list ORACLE-L

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-----

Sent: Thursday, February 06, 2003 11:05 AM

To: Multiple recipients of list ORACLE-L

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).

-----Original Message-----

<mailto:Lisa.Koivu_at_efairfield.com> ]

Sent: Thursday, February 06, 2003 8:24 AM

To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Koivu, Lisa
  INET: Lisa.Koivu_at_efairfield.com

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 - 15:48:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US