Sponsored Content
Operating Systems AIX ORACLE Database running slow on AIX ( nmon / topas ) Post 302448251 by zxmaus on Wednesday 25th of August 2010 02:21:34 PM
Old 08-25-2010
bakunin,

thank you - glad to be back Smilie

zaxxon

hd_pbuf_cnt=1024 = AIX 5.2 ,
pv_min_pbuf=1024 = AIX 5.3 and later

regarding the buffer tunables, this box seem to have enough jfs2 buffers but not enough buffers for its jfs filesystems, that is why I would suggest to only tune these ? Smilie

I am with you setting the other values would not harm the box - I just cannot see at the moment that it is needed. It might be later after initial tuning.

Just for completeness, if this would be my box I would most likely go with

Code:
ioo -p -o j2_maxPageReadAhead=128
ioo -p -o maxpgahead=16
ioo -p -o j2_maxRandomWrite=32
ioo -p -o maxrandwrt=32

on top of the memory tunables from the previous thread - but these are settings you should be rather careful with as they can potentially do more harm than good.

Kind regards
zxmaus
This User Gave Thanks to zxmaus For This Post:
 

8 More Discussions You Might Find Interesting

1. AIX

Memory usage statistic? (topas, nmon)

hi, how can i diplay: - the ammount RAM used /free - ammount of ram used from a pid or prozess we have the problem, that malloc is returing a NULL pointer errno = 12 ( not enough space). but i think there is still ram free. nmon : shows all memory used ? Memory Use Physical Virtual... (7 Replies)
Discussion started by: Lazzar
7 Replies

2. Filesystems, Disks and Memory

skgpspawn failed running oracle db 9.2.0.5.0 on aix 5.3

Hi, I am running an oracle db 9.2.0.5.0 on ibm p5 550 aix 5.3 with 10g ram, 10G swap space 3 database instances each SGA about 500Meg. I am getting the following error in my alert log file from time to time: skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 ... (0 Replies)
Discussion started by: hawkerpacific
0 Replies

3. AIX

nmon vs topas

good morning what is the better solution to examen a P570 ? because i use topas and nmon, and the results are totally different !!! with nmon, i have 80% free cpu, and with nmon, i have 90% of used cpu !!!!!! i take a shot with an intervall of 10s during 10 mn. thank you (0 Replies)
Discussion started by: pascalbout
0 Replies

4. AIX

Top command in AIX 4.2 (no topas, no nmon, no top)?

Is there a 'top' command equivalent in AIX 4.2 ? I already checked and I do not see the following ones anywhere: top nmon topas (1 Reply)
Discussion started by: Browser_ice
1 Replies

5. Solaris

what is the command to see which database ie..oracle in running on solaris 10

what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies

6. Shell Programming and Scripting

Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys, Need you help in one point! I am working on one shell script which takes following steps : 1. Taking one query result from oracle database 2. Exporting that result to Xls file 3. Mailing that file to my own mail ID Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies

7. AIX

Need to check long running processes on the database server and the os is AIX

Hello, Please help me with a script with which I can check long running processes on the database server and the os is AIX. Best regards, Vishal (5 Replies)
Discussion started by: Vishal_dba
5 Replies

8. AIX

AIX server running very slow

Hello, All the commands on AIX are running very slow. Below is few stats but I didn't find any issue in cpu or memory reosurces vmstat System configuration: lcpu=4 mem=6144MB ent=1.00 kthr memory page faults cpu ----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
dbc_max_pct(5)							     OBSOLETED							    dbc_max_pct(5)

NAME
dbc_max_pct, dbc_min_pct, bufcache_max_pct, bufpages, nbuf - OBSOLETED kernel tunable parameter DESCRIPTION
These tunables have been obsoleted and removed. Do not make any changes to these tunables, as they have no effect on the kernel. Use the file cache tunables and (see filecache_max(5)). In previous releases, the tunables and were used to set limits to the dynamic buffer cache, and the tunables and were used for tuning the buffer cache when a static cache was desired. This release of HP-UX offers improved file caching technology and improved physical memory control associated to caching file I/O data. The number of tunable parameters used to control file caching memory usage is reduced from five to two, and previous usability issues are addressed. Restrictions on Changing These tunables should not be modified. Attempting to tune any of the obsolete buffer cache tunables, or results in an error. Use the tunables and to set limits on the file cache. Note that, on a any given system, the optimum values of these two new tunables are not necessarily equivalent to the optimum values of the obsolete buffer cache tunable values in the older systems. You should first deter- mine if the new default values yield acceptable performance on your system, before attempting to change the values of the new file cache tunables. AUTHOR
and were developed by HP. SEE ALSO
filecache_max(5). Kernel Tunable Parameter dbc_max_pct(5)
All times are GMT -4. The time now is 01:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy