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: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
>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: Scott Stefick
  INET: sstefick_at_harpercollege.edu

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