AIX and Oracle


 
Thread Tools Search this Thread
Operating Systems AIX AIX and Oracle
# 1  
Old 11-19-2013
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 lgpg_regions and lgpg_size under VMO (though they are not restricted parameters, is it recommended to change them?)

I never changed that parameter for oracle and not sure how the impact will be.
I know wrong values or setting will degrade the performance.
I looked online and there is a pdf called 'AIX_tuning_for_Oracle_DB.pdf" it says create large pages for oracle.

Has anyone really changed those parameters and if they did, under what circumstances and did it really improved the performance of the database.

I increased the size of paging space as alternative (for now) as the system was very high on file cache.

AIX 7.1 TL01 SP06
Oracle 11gr2
Power7+ (770)
I was told disks are raid 10.

Database system
System has 4 entitled and virtual CPUs
Real mem: 85 gigs and Swap is 42 gigs (I increased it for time being)

See the difference after I increased the swap space. Now the consumption of swap is 1%.
AIX and Oracle-graphpng
# 2  
Old 11-19-2013
I am not sure increasing the swap space helps and, as you know, whenever you are hitting the paging space, it's not optimum for performance. I think the the key performance is having a good history of what you're system is doing and also qualifying the performance problems. I would ask them to quantify what they mean by slow. Is their some transaction they can conduct to demonstrate reponse time/performance. What numbers are they using the qualify their statements.

I am advocate for changing parameters if you can know the history of system performance, qualify the response issue, and can measure the change after.
# 3  
Old 11-19-2013
I was told the application team was complaining about the slow response time.

As for now I don't have any bench marks to quantify.
# 4  
Old 11-20-2013
Hi,

We followed the "Oracle Architecture and Tuning on AIX (v 2.30).pdf" guide, using CIO and Large Pages and gain a performance increase. Not a Big Bang but our Oracle team was satisfied.

AIX 7.1 TL1 SP7
Oracle 11.2.0.3
Power7 (770)
9 ded. CPUs
120GB Mem - 4GB Swap

We have had negative experience (response time) with our real time application, when using shared CPUs.
This User Gave Thanks to -=XrAy=- For This Post:
# 5  
Old 11-20-2013
Thanks XrAy!
Looking at the graph, can we conclude something?

While referring the doc I came to know that redo logs should be created in 512B blocks and rest can be default (4K). That means I have to recreate redologs file system.

Even though we I have shared CPU, its one to one (as entitled and Virtual is equal).
# 6  
Old 11-20-2013
Does anyone has anything to say about this graph.

It's another DB server with same OS version and hardware.

Memory is 24G and swap is 16G. CPu is 3.
AIX and Oracle-graph-1-.png
# 7  
Old 11-25-2013
Ok,
It all depends on the type of system, large pages are intended for high performance computing applications which are memory intensive (such as oracle). Enabling large pages help and this is due to ....

"The large page performance improvements are attributable to reduced translation lookaside buffer (TLB) misses due to the TLB being able to map a larger virtual memory range. Large pages also improve memory prefetching by eliminating the need to restart prefetch operations on 4KB boundaries"

Now you need to know, whether your system is that memory intensive. Remember changing vmo parameter has it's affect if changed for no real reason and on guessing.

As asked by the admin in the forum, you need to know what is going slow and where.

CIO, you can do it, basically it will omit the layer of file system caching, thus saving you some memory and cpu time. But again it depends on the environment.

I looked at the graph no 2, you said real memory is 24 but the graph says otherwise (16 gigs).

Look at the error report is it complaining on memory?

The graph should reduce the green area (cache) once you enable CIO. And you know what to do with redo logs file system.

I hope this helps!
This User Gave Thanks to ibmtech For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. UNIX for Advanced & Expert Users

Oracle RAC on AIX

I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
Discussion started by: johnf
1 Replies

3. AIX

Oracle 9.2.0.1.0 on AIX 5300-07

Seek help from all of the experts here. Database Oracle 9.2.0.1.0 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... (2 Replies)
Discussion started by: kwliew999
2 Replies

4. AIX

AIX to Windows Oracle DB

Dear All, I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Discussion started by: prav_06
2 Replies

5. AIX

oracle 10g on AIX 5

hi can anyone help me by telling step by stem oracle10g installation in AIX 5 . Munir mondolsoft Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies

6. AIX

Aix, Oracle and Java

Hello Im trying to install oracle on my AIX 5.3 server. Im doing all things right as Oracle says... When im trying to run the instalation it gives me an error about JRE. But i already have JRE installed as you can see... Someone can help me or guide me? Im new in with this.. ... (1 Reply)
Discussion started by: gfca
1 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

aix-oracle

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