| 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
Lisa,
We have several databases on AIX 4.3.3/8.1.7.x. All of them have TIMED_STATISTICS set to TRUE.
Not problems have been encountered.
And about that tuning question: May be those are all dedicated connections, if so check what's set for SORT_AREA_SIZE at the instance level, may be there are other non-Oracle processes (application daemons etc.) that are memory bound. And if no one is complaining, and all tasks are completed in an acceptable time frame, you can just collect 'baseline' data for future reference, when the 'database' is at fault ;)
HTH,
-----Original Message-----
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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 - 10:04:45 CST
 |
 |