08-27-2009
Thanks for the reply it will help me a lot.
I am actually using AIX 6.1 with Oracle 11g. Running a Banking Application (I-Flex).
I am sill in installation phase I can do as much R&D as i can, before going for production.
As far as i know if i use DIO it will not use filesystem caching and oracle has its own caching.
If both oracle caching and FS caching are used the performance will degrate..
So i am thinking of using DIO & AIO . what do u think.
you are absolutely correct there is no particular way for tuning IOs we have to test it and do according to the result.
I just want some suggestion coz planning of one mind can be incorrect also.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
can someone tell me a good site to go to in order to learn this. please do not recommen nay books because i dont have interest in that. if you know of any good sites with good straight forward explanation on how to split loads on machines that has excessive loading, please let me know
Also,... (1 Reply)
Discussion started by: TRUEST
1 Replies
2. Shell Programming and Scripting
Sorry,
This is out of scope of this group.But I require the clarification pretty urgently.
My Oracle database is parallely enabled.
Still,in a particular table queries do not work "parallely" always.
How is this? (9 Replies)
Discussion started by: kthri
9 Replies
3. Solaris
hw to increse nfs perfomence tuning? (4 Replies)
Discussion started by: naresh.sun
4 Replies
4. Shell Programming and Scripting
Hi All,
In last one week, i have posted many questions in this portal. At last i am succeeded to make my 1st unix script.
following are 2 points where my script is taking tooooo long.
1. Print the total number of records excluding header & footer. I have found that awk 'END{print NR -... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
5. Web Development
We have been tuning MySQL lately and I ran accoss two useful tools that you might be interested in:
mysqltuner.pl
tuning-primer.sh
Both of these scripts are quite useful for MySQL tuning. Here is some sample output of mysqltuner.pl
>> MySQLTuner 0.9.8 - Major Hayden... (3 Replies)
Discussion started by: Neo
3 Replies
6. Shell Programming and Scripting
This is my function in UNIX file. In this function I am
-> first replacing spaces in character 19-27 with 0
-> then if it's all zeros ( 9 zeros) replace it with space
The reason I have to make it to 0 first is that my requirement is that if this field is having value of 0 , replace it... (4 Replies)
Discussion started by: varunrbs
4 Replies
7. Solaris
Hi all, I would like to tune the nxge card as suggested by this link, but got some confusion. Can anyone advise me ?
We have
SunOS hsbc02 5.10 Generic_137137-09 sun4v sparc SUNW,Netra-CP3260
Do I have to install any patches ?
The tunning link
Networks - Siwiki
In our nxge.conf, I... (0 Replies)
Discussion started by: dehetoxic
0 Replies
8. AIX
Dears i want to have a clear view about this tuning parameters and what they related to FS or Oracle , and how to figure the percentage of them .
maxperm%
maxclient%
v_pinshm = 1
lgpg_regions = 0
lpgp_size = 0 (3 Replies)
Discussion started by: thecobra151
3 Replies
LEARN ABOUT HPUX
bufpages
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)