Oracle on AIX 5300-07

Thread Tools Search this Thread
Operating Systems AIX Oracle on AIX 5300-07
# 1  
Old 10-12-2009
Oracle on AIX 5300-07

Seek help from all of the experts here.
Database Oracle run on AIX 5300-07.
The system is running so slow that sometime 1 click of changing screen will take more than 5 minutes.
The hardware in this LPAR is 6CPUs, 21GB-RAM, 42GB-Paging and run on p570 server POWER 5+.

And the vmo setting is as below where
minperm = 3%, maxperm=90%, maxclient=90%, lru_file_repage=0 and lru_poll_interval = 10.

With the Oracle init.ora is as below:
*.log_archive_dest_3='service=hlarep reopen=60 optional arch'
*.optimizer_index_caching =70

May I know what is wrong with all these setting? Is there anything on O/S or Database setting that is wrong which affect the slowness?
As I know from my DBA, the Database only using 8GB of memory and I do not understand why it can't use all 21GB of them.
# 2  
Old 10-12-2009
Your DBA is referring to *.sga_max_size=8176279568 ~ 8 GB memory used, but *.pga_aggregate_target=2007986918 ~ 1,8 GB is also memory on your server consumed by your database.

Did you investigate if there is something very busy during such slownesses? Did topas or sar show CPUs near 100% or very busy disks?
# 3  
Old 10-13-2009
please show output of
vmstat -I 5 5


commands and
lsattr -El aio0

and let us know if this is a oltp or rather a data warehouse database. In addition the output of
iostat -D

could be helpful.
In addition you have

set - do you use large pages - in any other case that is real bad habit and on AIX rather couterproductive in most cases.
Kind regards
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

AIX and Oracle

Hello All, I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO. They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache. To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies

2. AIX

AIX 5300-05-06-0000 to 5300-09-00-0846 FAILED

I'm having this trouble when smit update_all. ========================================================== MISSING REQUISITES: The following filesets are required by one or more of the selected filesets listed above. They are not currently installed and could not be found on the... (5 Replies)
Discussion started by: liberatti
5 Replies

3. AIX

aix 61 and oracle 11

Hi, we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11. Our base interest is on vmo and disk setup On aix 5.3 we change lru_file_repage to 0. We split disk layout ( emc cx4 ) to tree volume groups: - one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
Discussion started by: prebila
5 Replies

4. AIX

How to install AIX Fix Pack 5300-06-06-0811

Hi All, I have this fix for AIX (5300-06-06-0811) and i need to install it. How can i do this? What are the prerequisites for this fix? Thanks (1 Reply)
Discussion started by: lucaxvu
1 Replies

5. AIX

HACMP 5.4 with AIX 5300-10 not working

I have two IBM_9110-51A boxes OS - fresh installs 5764-G03 TL 5300-10-00 disks dated 5/2009 HACMP - fresh installs HACMP for AIX 5L Base V5.4 5765-F62 dated 7/2006 Bottom line for smit output attempting 2 node cluster config ... (2 Replies)
Discussion started by: DrKillPatient
2 Replies

6. AIX

Issue "Error 404" when upgrade AIX 5300-05-CSP-0000 to AIX (5300-09-02-0849)

Please read my issue! My old server using: - AIX system operating (5300-05-CSP-0000) - WebSphere (Fix Pack 21) After I've upgraded version AIX - AIX system operating (5300-09-02-0849) - WebSphere (Fix Pack 21) I have 1 issue when I access home page: "Error... (0 Replies)
Discussion started by: gamonhon
0 Replies

7. AIX

AIX 6.1 and Oracle 9.2.0

Hi All, I need to update some AIX servers from 5.2 to 5.3 OR 6.1 . The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 . I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies

8. AIX

oracle 9i on AIX 5.2

Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run" and i can't start the installation of ORACLE 9i... see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies

9. UNIX for Advanced & Expert Users

Oracle and AIX

Hi @all Who's able to help me? I've a running Oracle DB on AIX 4.3.3. You've also an Oracle Client running for this. So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things, but it doesn't work. Thanks a lot! Regards Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies

10. UNIX for Advanced & Expert Users


what is the reason oracle is giving ora-600 space leak error? how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies
Login or Register to Ask a Question