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

[Ed Lewis]

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

Lisa,     We've been using timed_statistics=true at our site for over a year, without any problems.           ed ----- Original Message ----- From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, February 06, 2003 9:23 AM 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