Right, there is no AIO requests at the time this is taken. Is your AIO enabled? Is the DB actually up and running, having traffic?
Code:
lsdev -C| grep aio
aio0 Available Asynchronous I/O (Legacy)
posix_aio0 Available Posix Asynchronous I/O
AIX offers two AIO subsystems, Legacy AIO (aio0) and Posix AIO (posix_aio0). Oracle uses Legacy AIO which is represented by the device aio0. But I found a note here: Administering Oracle Database on AIX
Quote:
Note:
Starting with AIX 5L version 5.2, there are two AIO subsystems available. Oracle Database 10g uses Legacy AIO (aio0), even though the Oracle pre-installation script enables Legacy AIO (aio0) and POSIX AIO (posix_aio0). Both AIO subsystems have the same performance characteristics.
As you said you are using Oracle 9.1 so maybe it will try to use posix_aio0. The tuning tips so far were considering aio0 so you might have to tune posix_aio0 as well. Anyway it seems currently is no AIO traffic there anyway.
make sure that you are allowing oracle to really use async io by checking that disk_async_io = true and filesystemio_options = async or setall
BTW - oracle recommends that you either systemwide (/etc/environment) or at least in the oracle profile set AIXTHREAD_SCOPE=S - what will reduce the memory utilization of oracle processes a lot.
Just to add some info to zxmaus' - those 2 commands show the number off current running AIO-servers (legacy I think). It does not necessary mean that they are being used at the moment. Once started from a peak of workload for example, they stay running until a reboot.
To see how many are currently running, you can use nmon. When starting it interactively, you can press a+shift and get something like:
Code:
Asynchronous-I/O-Processes ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────│
│ Total AIO processes=1100 Actually in use= 35 CPU used= 15.7% [Use zero │
│ All time peak=1100 Recent peak= 44 Peak= 15.7% to reset]
For the number of current AIO-requests, iostat -A will show as written (don't know another way tbh^^).
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)
