Login or Register to Ask a Question and Join Our Community


AIX

AIX 5.3, TL6 problem??

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX AIX 5.3, TL6 problem??
# 1  
Old 08-04-2008
AIX 5.3, TL6 problem??
Hi people,

I have a IBM server (with HACMP) running AIX 5.3 with Oracle9.2.
In last weekend i installed TL6...

Code:
root@srv_node1:/> oslevel -s
5300-06-03-0732

but now the Shared pool of oracle is very low... making all process very slow

I already try to find some answer in google... but nothing that explain the problem!

Someone had same problem?
Or can give me a direction to find my problem?

Thanks a lot
# 2  
Old 08-05-2008
I am no Oracle admin and it might sound dumb but can't you just set that parameter for the shared pool back to what it was?
We have same ML running on our AIX 5.3 boxes with lots of Oracle DBs on them, mainly Oracle 10.2 though and I didn't get notice of any complains.

A ML update doesn't change kernel parameters and I doubt it is the reason, but maybe lets check your VMM settings?

Code:
vmo -x| grep -iE "file_rep|minperm|maxperm|maxclient"

And add a
Code:
vmstat 1 20

from the time when it is running very slow, ty.
Last edited by zaxxon; 08-05-2008 at 03:29 AM.. Reason: Asking for vmstat snippet
# 3  
Old 08-05-2008
Thanks!
Also, Im not a oracle admin... neither AIX... Before i was only a network administrator, but now the previous sys admin dont work anymore in this company so i have to do his job! well... good to increase my knowledge! Smilie

I will do that... and answer here.

Thanks
# 4  
Old 08-05-2008
Hi again!

Code:
root@srv_node1:/export> vmo -x| grep -iE "file_rep|minperm|maxperm|maxclient"
lru_file_repage,1,1,1,0,1,boolean,D,
maxclient%,20,80,20,1,100,% memory,D,maxperm% minperm%
maxperm,2001277,,2001277,,,,S,
maxperm%,20,80,20,1,100,% memory,D,minperm% maxclient%
minperm,500318,,500318,,,,S,
minperm%,5,20,5,1,100,% memory,D,maxperm% maxclient%
strict_maxclient,1,1,1,0,1,boolean,D,strict_maxperm
strict_maxperm,0,0,0,0,1,boolean,D,strict_maxclient

and
Code:
root@srv_node1:/export> vmstat 1 20
 
System configuration: lcpu=12 mem=40959MB ent=4.00
 
kthr    memory              page              faults              cpu
----- ----------- ------------------------ ------------ -----------------------
 r  b   avm   fre  re  pi  po  fr   sr  cy  in   sy  cs us sy id wa    pc    ec
 1  0 4542286 3937366   0   0   0   0    0   0 1452 15842 1351 31  3 65  1  1.56  39.0
 1  0 4542974 3936667   0   0   0   0    0   0 1467 7129 1134 27  1 71  0  1.33  33.2
 9  0 4542304 3937337   0   0   0   0    0   0 1522 15256 1239 44  2 54  0  2.01  50.1
 5  0 4542336 3937303   0   0   0   0    0   0 1478 18160 1361 51  3 46  0  2.32  58.1
 5  0 4537671 3941967   0   0   0   0    0   0 1501 21139 1427 35  5 60  0  1.84  46.0
 2  0 4538563 3941074   0   0   0   0    0   0 1448 13117 1173 33  3 64  0  1.62  40.6
 2  0 4547324 3932314   0   0   0   0    0   0 1373 15868 1767 41  3 56  0  1.98  49.4
 2  0 4541708 3937929   0   0   0   0    0   0 1535 7791 1186 32  2 66  0  1.54  38.5
 6  0 4541799 3937838   0   0   0   0    0   0 1506 14251 1443 39  3 58  0  1.86  46.6
 2  0 4541799 3937838   0   0   0   0    0   0 1523 20458 1251 39  3 58  0  1.89  47.1
 4  0 4541799 3937838   0   0   0   0    0   0 1542 16185 1545 41  3 54  2  1.94  48.6
 2  0 4547379 3932257   0   0   0   0    0   0 1507 13570 1274 45  2 53  0  2.07  51.7
 3  0 4541744 3937892   0   0   0   0    0   0 1529 8264 1241 44  2 52  2  2.06  51.6
 5  0 4541782 3937853   0   0   0   0    0   0 1535 16189 1148 33  4 62  0  1.72  43.1
 5  0 4543755 3935880   0   0   0   0    0   0 1527 17059 1285 35  5 59  0  1.89  47.2
 4  0 4542814 3936820   0   0   0   0    0   0 1474 11940 1107 31  3 65  0  1.60  40.1
 3  0 4543812 3935822   0   0   0   0    0   0 1587 16339 1514 44  3 51  1  2.13  53.2
 3  0 4545096 3934536   0   0   0   0    0   0 1432 6213 1047 26  2 71  0  1.29  32.2
 4  0 4537334 3942298   0   0   0   0    0   0 1484 20928 1213 37  4 59  1  1.83  45.8
 6  0 4536917 3942714   0   0   0   0    0   0 1572 17462 1590 49  3 47  2  2.27  56.8

Well, as i said im very new on this technology... but looks like its all ok with server.

Could problem come from the storage or hacmp?

Thanks.
# 5  
Old 08-05-2008
Looking at the vmo parameters, it has been tuned the "old" way, setting maxperm and maxclient low instead of lru_file_repage=0, which is absolutely fine though.

Your vmstat looks very good - running kernel threads queue is not higher than you have CPUs in the system, no swapping into/from paging space, and no I/O waits - It even has time to idle.

From the AIX side, the system looks fine to me and not very burdened.
So I think you need some Oracle admin to have a look at your Oracle parameters/performance.

Though the last thing you can check for AIX is, with "iostat 2" for example, if there are disks, that are very busy (% tm_act column) or have a lot of transactions to do (tps column) or a lot of throughput in terms of Kbs. But I guess there is not much of a problem.
Also a
Code:
ps aux| grep -c aioserver
# and a
lsattr -El aio0

will be interessting.

But I guess that will not be the reason you have problems since updating to the new ML... You might have a look at http://metalink.oracle.com and post your problem there or contact your Oracle support or some Oracle forum additionally.

Btw. how do you know the Shared Pool is very low? Is the parameter set for SGA etc. changed or can you measure/monitor the usage of the Shared Pool? With 40GB and maybe not much running else on this box consuming memory, you have a good amount of RAM to use/distribute.
# 6  
Old 08-05-2008
If the performance is unexplainably bad it might be a monitoring software problem: i remember from the last project i worked at that there was a problem with the CA-Unicenter Oracle agent. There were combinations of Oracle patch levels and revisions of this agent which worked and most others caused severe performance problems as the agent hogged as many system resources as it could get over a few days. (Taking up several GB of memory for basically nothing was not unusual.)

Still this would be showing in vmstat and this is not the case. In fact yor machine looks pretty good there: the "fre" column is quite high (this is the memory which is outright available, in 4K-pages), the blocked-queue (b) is constantly zero and the "ec" column shows low values (this is the "entitled capacity consumed", the percentage of available processing resources which are really used - if it goes near 100 this indicates that the processor(s) are too small/few for the load).

Here is some literature i found when i was working on a performance optimization project involving Oracle on AIX 5.3:

http://publib16.boulder.ibm.com/pser...d/prftungd.pdf

http://www.redbooks.ibm.com/redbooks/pdfs/sg246478.pdf

http://www.redbooks.ibm.com/redbooks/pdfs/sg244810.pdf

System Performance Tuning, O'Reilly, 1990, ISBN 0-937175-60-9

Tuning for Oracle9i on AIX

AIX 5L Initial Tuning

I hope this helps.

bakunin
# 7  
Old 08-07-2008
Hi people... couldnt come here before...

but thanks a lot for your answers!

Zaxxon, the Shared Pool is now with 1,5GB... but now i dont have sure that the problem come from the Oracle!! Because now we notice the system is also
slow in compile (Cobol and C/C++)...

bakunin, thanks for your experience and your advice on reading! i will take that Smilie


Someone know a good program or something to benchmark AIX?

My main problem is that i dont have sure of the source of problem... the only thing that i know is all problems started when i put TL6 and efix...
Last edited by gfca; 08-08-2008 at 06:30 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

library problem on AIX

Hi Unix Experts, I have seen with AIX, that sometimes my new libraries are not picked up by executable. This could be the problem of "loader domain" on AIX. As I found on below link AIX libraries do stick in the memory. AIX shared libraries The remedy for this is to run slibclean... (3 Replies)
Discussion started by: shriashishpatil
3 Replies

2. AIX

Failed to apply the IZ86736 patch in TL6 SP1

while i was trying to apply the patch IZ86736 in TL6_SP1 its give me the below error instfix -d . -p -f /tmp/.instfix_selections.20512908 > File installp -acgNqXd . -f File File: bos.rte.control 06.01.0006.0003 ... (3 Replies)
Discussion started by: thecobra151
3 Replies

3. AIX

Problem in going from AIX 5.3 TL6 to TL7

I have updated the TL levels in a step upgrade from TL4-TL6 (oslevel -r --> 5300-06) without any issues. However when I try to install TL7, it fails on package dependencies. It seems that TL7 may have introduced some major device enhancements, so how do I update from TL6 to TL7? I have... (6 Replies)
Discussion started by: mrmurdock
6 Replies

4. AIX

AIX OS problem? network problem?

Dear ALL. I installed AIX OS on customer sites. but Only one site is too slow when I connected telnet, ftp.. Ping is too fast. but telnet and FTP is not connected.. of course i check the configuration file on aix but it's normal. Do any Idea?? thanks in advance. - Jun - (3 Replies)
Discussion started by: Jeon Jun Seok
3 Replies

5. AIX

[AIX 5.2] Problem with rpm

I downloaded gcc-cplusplus-4.0.0-1.aix5.2.ppc.rpm from IBM AIX Toolbox Download Page - Alphabetical Listing but: -bash-3.00# rpm -ivh gcc-cplusplus-4.0.0-1.aix5.2.ppc.rpm error: gcc-cplusplus-4.0.0-1.aix5.2.ppc.rpm cannot be installed I can't understand wht kind of error is it... Can be... (1 Reply)
Discussion started by: untamed
1 Replies

6. AIX

problem with automount in Aix

Dear Frndz, I have a problem in automount. please find the config file entry for automount /etc/auto_master /- /mount.map I have specified all the mappings in /mount.map The service is operative. But when i cd into the directory it is not mounting with the server. Could you... (6 Replies)
Discussion started by: sriram.s
6 Replies

7. AIX

telnet problem in aix

Can somebody help me. Whenever I telnet to my server i received a message /dev/pts/0: 3004-004 You must "exec" login from the lowest login shell. Connection closed. pls help me (2 Replies)
Discussion started by: vjm
2 Replies

8. Programming

compile problem on aix

When compiling (a simple test program): #include <stdio.h> #include <sys/context.h> int main() { printf("Hello\n"); return 0; } on AIX 5.2 with gcc 3.2.2 from the IBM site I get the following error: /usr/include/sys/context.h:169: parse error before "sigset64_t"... (4 Replies)
Discussion started by: rein
4 Replies

9. UNIX for Advanced & Expert Users

AIX 5.2 problem

Hello, I'm working on a AIX5.2 OS. The problem i'm facing is that the system performance is good in rrot login, but when i switch to other users login it is very slow. A ls or even pwd command take almost 20 to 30 sec to disply output. The same logins are working fine on other... (2 Replies)
Discussion started by: pradeepmacha
2 Replies

10. AIX

AIX pg problem

Hi all, I have problem with regards to using pg on AIX v5.3.0.0 . Here wht i am trying to do --- i have shell script with the following statements if || then echo ^[[?3h tput clear pg -f $1$2 echo ^[[?3l ... (0 Replies)
Discussion started by: ramanujapuram
0 Replies
Login or Register to Ask a Question