Sponsored Content
Full Discussion: AIX and Oracle
Operating Systems AIX AIX and Oracle Post 302876618 by ibmtech on Monday 25th of November 2013 05:14:13 PM
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:
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
filecache_max(5)						File Formats Manual						  filecache_max(5)

NAME
filecache_max, filecache_min - maximum or minimum amount of physical memory used for caching file I/O data VALUES
Failsafe Default The defaults are computed and adjusted automatically, based on the amount physical memory on the system. The current default value, when displayed by will be expressed as the current value used internally by the system (representing bytes). The displayed value will vary as the internal value is automatically adjusted. Allowed values not less than the equivalent of 1 megabyte not less than the equivalent of 1 megabyte not greater than the equivalent of 70% of physical memory not greater than the equivalent of 90% of physical memory See below. Values can be specified as: 1) Default 2) A percentage of total physical memory: A positive whole number followed by a percent symbol (for example, 70%). 3) A constant value: A positive whole number that represents number of bytes of physical memory, optionally followed by a multiplier suffix, where and Recommended values It is recommended that these tunables are left in the automatic (default) state, to allow the system to better balance the memory usage among filesystem I/O-intensive processes and other types of processes. DESCRIPTION
These tunables control the amount of physical memory that can be used for caching file data during file system I/O operations. The amount of physical memory that is specified by the tunable is reserved and guaranteed to be available for file caching. The amount of physical memory used for file caching can grow beyond up to depending on I/O load and competing requests for physical memory. When these tunables are set to default, or set to a percent value, they automatically adjust with Online Addition or Deletion (OL*) of physical memory, as appropriate. Who Is Expected to Change These Tunables? The automatic (default) state should be appropriate for most environments. You must set these tunables to a constant value (not default or percent) if you want to specify file cache limits with finer granularity than percent of physical memory (for example, a minimum size or fixed size of <1% of physical memory). You must set these tunables to a constant value (not default or percent) if you do not want the limits of the file cache to adjust with OL* of physical memory. To discriminate in favor of deterministic I/O on systems with large file I/O activity, or on the contrary, to discriminate in favor of bet- ter performance of non-I/O-intensive processes, you can consider changing the values of these tunables, keeping in mind the side effects as described below. To determine a reasonable value for the cache size you should consider the file I/O-intensive applications on your system, and the size of their working set. Depending on the type of applications, the working set size can be based on the size of a transaction, or data size in given unit of time. For example, for a conservative value of in megabytes, you can use the following formula: number-of-records-in-working-set Only those processes that actively use disk I/O for file data should be included in the calculation. All others can be excluded. Here are some examples of what processes should be included in or excluded from the calculation. Include: NFS daemons, text formatters, database management applications, text editors, compilers, and so on, that access or use source and/or output files stored in one or more file systems mounted on the system. Exclude: X-display applications, login shells, system daemons, or connections, and so on. These processes use very little, if any, disk I/O for file data. Restrictions on Changing These tunables are dynamic and automatic. The system rounds the specified tunable value(s) down to the closest physical page boundary. The amount of physical memory represented by must be equal to or less than the memory represented by tunable Setting these tunables to a constant value will de-couple them from OL* events. Tuning up of the parameter may fail if there is not enough free physical memory to satisfy the request. These tunables, and must both be set to a relative state (either default of percent state), or must both be set to a constant value. For example, the following are acceptable settings: The following will result in an error: If is currently set to default, the following is acceptable: But the following will result in an error: See other restrictions in the section above. When Should the Value of These Tunables Be Raised? Low system performance at initialization time and/or on a system with filesystem I/O-intensive processes may be an indication that the val- ues of these tunables are too low. If there is a large number of processes actively and constantly using file data I/O, you should raise the value of for more deterministic I/O. In most cases, especially when the file data I/O is expected to peak only occasionally, it is recommended that the value of the maximum limit, is raised instead. What Are the Side Effects of Raising the Values? The amount of memory reserved for the minimum file cache size, dictated by cannot be used on the system for other purposes. Be careful not to raise this value so high that it can eventually cause memory pressure and overall system performance degradation. When Should the Values of These Tunables Be Lowered? The value of the minimum limit, can be lowered to allow a larger percentage of memory to be used for purposes other than filesystem I/O caching, depending on competing requests. By lowering the value of a larger amount of memory is available for other purposes, without com- peting with file I/O requests. What Are the Side Effects of Lowering the Values? If there are many competing requests for physical memory, and the file cache tunables are set to too low a value, very high demand on file I/O operations can eventually cause filesystem I/O performance degradation. EXAMPLES
Set the file cache minimum to 10% of physical memory: Set a fixed size file cache of 1 gigabyte: Set the file cache minimum to 15% of physical memory, and the maximum to 65% of the physical memory: WARNINGS
All HP-UX kernel tunable parameters are release specific. These parameters may be removed or have their meaning changed in future releases of HP-UX. Other tunable parameters related to sizing the buffer cache that existed in previous HP-UX releases are now obsolete. The tunables and should be used to set limits to the file cache. Note that, on any given system, the optimum values of these two new tunables are not nec- essarily equivalent to the optimum values of the obsolete tunable values in the older systems. You should first determine if the new default values yield acceptable performance on your system, before attempting to change the values of the new file cache tunables. Installation of optional kernel software, from HP or other vendors, may cause changes to tunable parameter values. After installation, some tunable parameters may no longer be at the default or recommended values. For information about the effects of installation on tun- able values, consult the documentation for the kernel software being installed. For information about optional kernel software that was factory installed on your system, see at AUTHOR
and were developed by HP. SEE ALSO
kctune(1M), sam(1M), gettune(2), settune(2). Tunable Kernel Parameters filecache_max(5)
All times are GMT -4. The time now is 09:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy