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

2003-02-07 Thread Deshpande, Kirti
Here is a link to IBM site showing a matrix for AIX 4.x support. Fix the link if it wraps around. We had a meeting yesterday to begin upgrading Servers to AIX 5.1 first, for a short duration, and then to 5.2. http://www2.ibmlink.ibm.com/cgi-bin/master?xh=YUKoCSGfrgPYSK2USenGnN9332&request=sale

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

2003-02-06 Thread John Kanagaraj
Lisa, Be aware that AIX uses the memory for File system caching, and as much as it can. So don't be surprised by low values in 'fremem' in vmstat. What you do need to watch out is the 'pi' (page in) column which can indicate paging in.. Large values in 'po', when you are seeing lots of physical f

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

2003-02-06 Thread Koivu, Lisa
riginal Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 2:23 PMTo: Multiple recipients of list ORACLE-LSubject: Re: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question By the way, Lisa.  AIX 4.3.3 is being desupported.  We are te

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

2003-02-06 Thread Ball, Terry
I am not currently working in an AIX environment; but when I did (and it was 4.3 with 8.1.6/7) we always set timed_statistics=true with no adverse effects. -Original Message- Sent: Thursday, February 06, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Good morning everyone - Qui

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

2003-02-06 Thread Ruth Gramolini
e new OEM tomorrow or Monday.   Ruth - Original Message - From: Scott Stefick To: Multiple recipients of list ORACLE-L 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

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

2003-02-06 Thread Paulo Gomes
: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 wi

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

2003-02-06 Thread Scott Stefick
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

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

2003-02-06 Thread Koivu, Lisa
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Henry,   OS isn't paging when I've looked.  But with the memory this low it seems to me paging could happen pretty darn quick.   There are a couple of logins that can run reports.  These aren't big dat

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

2003-02-06 Thread Koivu, Lisa
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question 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, Febr

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

2003-02-06 Thread Post, Ethan
Title: 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 usin

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

2003-02-06 Thread 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

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

2003-02-06 Thread Deshpande, Kirti
Title: 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

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

2003-02-06 Thread Scott Behrens
Lisa,    I have had TIMED_STATISTICS set to true on 5 different 8.1.7 databases (4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers for some time with no perceived problems.   These servers are either at AIX maintenance level 9 or 10.    I have struggled with swap space

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

2003-02-06 Thread Henry Poras
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa,   When I first got to URI (8.1.7 4.3.3) timed_statistics were also set to false. I changed them to true and have had no problems with it.   I have also found that a lot of PeopleSoft setups aren't installed b

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

2003-02-06 Thread BanarasiBabu Tippa
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Lisa   There is no harm in using TIMED_STATISTICS=TRUE. I was using that on same environment   thanks Banarasi -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2

AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

2003-02-06 Thread Koivu, Lisa
Title: 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