aioserver query

Login or Register for Dates, Times and to Reply

Thread Tools Search this Thread
Operating Systems AIX aioserver query
# 1  
aioserver query

Hi Gurus,

What is the recommended value for aioserver in aix 5.3

current value is

And used is
 ps -k|wc -l  4768

We usauslly get issues like slow server performance and query waiting time more etc.

# 2  
pstat -a

i'm not sure if what you were referring to was the max number of requests or not. i know if you run 'pstat -a | grep aios' you can get a number of the running aio servers and verify against the min/max per cpu (smit aio) - you can determine if that is your bottle neck. you can adjust accordingly from there.
# 3  
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #356
Difficulty: Medium
ibfawk is a very small, function-only, reentrant, embeddable interpreter written in PHP.
True or False?

10 More Discussions You Might Find Interesting

1. AIX

The immortal aioserver

When shutdown an oracle server i see this error message at exit umount /oracle/ umount: error unmounting /dev/oracle: Device busy lsof and fuser report nothing but ps aux|grep oracle report this oracle 5964026 0,0 0,0 448 448 - A apr 21 0:00 aioserver oracle ... (16 Replies)
Discussion started by: Linusolaradm1
16 Replies

2. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

3. AIX

AIOServer process question

Hi I've been trying to learn a bit more about AIOServer processes and how my company administers them, one question i have is, while checking, most of my servers show a memory overhead of about 448 k per aioserver process (nmon -A) however i have found a few with figures of 67 or 56k. Most... (0 Replies)
Discussion started by: philib
0 Replies

4. UNIX for Dummies Questions & Answers


Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk... (0 Replies)
Discussion started by: abhi_n123
0 Replies

5. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

6. Shell Programming and Scripting


hi i am producing txt outputs of archives created by our tsm software. problem is some of these files are too large to open in excel so i can despatch. here is a example of the output TAG_460 /prod_bak 7 FILE /ARCHIVE/Whistles- ... (4 Replies)
Discussion started by: treds
4 Replies

7. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

8. UNIX for Dummies Questions & Answers

Need Help on query

I just started to learn unix - need help to write a script to query a logfile and produce the results that contains a specific word "alarm" for a period from X day to Y day. I really have no idea how to begin - :( please help... ____________________________________________________ #... (1 Reply)
Discussion started by: snipfer
1 Replies

9. UNIX for Dummies Questions & Answers


hi, how can i do the following..... i have file containing followig a k 10000 b c 200000 d e 50 a j 40 how can i list all rows containg last value more than 1000? and how can i find number of blank rows in the file? THANKS! regards vivek (2 Replies)
Discussion started by: vivekshankar
2 Replies

10. UNIX for Advanced & Expert Users


hello, i am working as aix system administrator, what is the major difference between aix and sun solaris ..os. what r the area difficult in solaris for aix administrator .............................. (1 Reply)
Discussion started by: varadakumar
1 Replies

Featured Tech Videos