It is the current maximum of asynchronous I/O requests that can be either waiting to be processed or are currently processed.
There is an explicit ORA error message (I forgot the error code) that can be searched on Metalink or in Oracle documentation, that points that this threshold has been hit and should be raised.
Usually on older versions of AIX this is per default 4096, I think from AIX 6 on it is 16384.
It is definetly a parameter that could and should be set to a higher values. That is why they have set the default value in AIX 6 to a 4 times higher value.
You can monitor this with
From the man page of iostat:
I agree with zaxxon - this is the very well known ora600 error When we were running into it, IBM recommended to set the value on all our 5.3 servers to 65536 - we did it and never faced that error again
I agree with zaxxon - this is the very well known ora600 error When we were running into it, IBM recommended to set the value on all our 5.3 servers to 65536 - we did it and never faced that error again
Regards
zxmaus
Quit informative reply from you gentlemen.
well, how to bump up the "maxreqs" value to 65536. By which command?
Do I need to restart the Aix and Oracle dbase after changing the value?
I have incresed the maxreqs value to 16384 which is 4 times than 4096;
I am getting the out of
Does it mean currently there is no AIO request processing as "avgc" is 0 ? May be i am interpreting wrongly. I would like to observe current aio request processed by maxreqs
your kind help please.
Last edited by Scott; 10-18-2010 at 06:17 AM..
Reason: Please use code tags
Hello All,
Could you please do help me here as I would like to perform parameter expansion in shell over a parameter expansion.
Let's say I have following variable.
path="/var/talend/nat/cdc"
Now to get only nat I could do following.
path1="${path%/*}"
path1="${path1##*/}"
Here... (8 Replies)
Hi.
How do I achieve this
sh /EDWH-DMT02/script/MISC/exec_sql.sh "@/EDWH-DMT02/script/others/CSM_CKC/Complete_List.sql ${file_name}" Complete_List.txt
The /EDWH-DMT02/script/MISC/exec_sql.sh has two parameters and it's working fine with this
sh /EDWH-DMT02/script/MISC/exec_sql.sh... (7 Replies)
Hi,
I have the following files.
->cat scr.sh
export TMP_DIR=/home/user/folder1
export TMP_DIR_2=/home/user/folder2
while read line
do
cat "$line"
done<file_list.dat
------------------------
-> cat file_list.dat
$TMP_DIR/file1.txt
$TMP_DIR_2/file2.txt
---------------------------
-> cat... (6 Replies)
hi all,
i have a parameter file of following format, i want a method which can get the value of specific parameter.
parameter file format:
<Parameter Name="FileLocationWindows">
<Description>
The directory location of the logger file.
... (1 Reply)
Hi we are using AIX 5.3 64bit
I have near about 79000 log file having naming convention like "IFTMBCSun Aug 14 07:45:00 PAKST 2011".
This naming convention was created by a script error, now we need to rename these log file by removing extar spaces and (:) colon for that we wrote below script
... (4 Replies)
i am passing input parameter 'one_two' to the script , the script output should display the result as below
one_1two
one_2two
one_3two
if
then
echo " Usage : <$0> <DATABASE> "
exit 0
else
for DB in 1 2 3
do
DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}`
done
fi (5 Replies)
Hi
I am looking for a unix command or a small shell script which can takes one parameter and then searches for the passed in the parameter in any or all files under say /home/dev/
Can anyone please help me on this? (3 Replies)
Hi,
I am getting the below error message When i am trying to delete the files from the directory.Could you please guide me?
rm *.aud
ksh: /usr/bin/rm: 0403-027 The parameter list is too long.
and
find /oracle/admin/testP/adump/*.aud -mtime +5 -exec rm {} \;
ksh: /usr/bin/find:... (3 Replies)
I have some requirement to tune the kernal parameter but want to know which is equal to tcp_conn_req_max_q in solaris??
thanksin advance.
amir (1 Reply)
Say I write something like the following:
var1=1
var2=2
for int in 1 2
do
echo "\$var$int"
done
I want the output to be:
1
2
Instead I get something like:
$var1
$var2 (2 Replies)