| Find out Process doing maximum I/O [message #457957] |
Wed, 26 May 2010 09:42  |
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
|
Senior Member |
|
|
Hi,
how can i found the a process which is doing lot of I/O in HP-UX?
since we have multiple Oracle instances on same unix server sometimes it is difficult to find out the process with most I/O by retriving session doing max disk reads
Also there is possibilty that such process may not be related to Oracle
two days back while I was restoring database it suddenly got slow, I checked using 'sar -b' and observed that 'bwrit/s lwrit/s' fall during certain period but could not find out the process cauing this
could anybody help me on this?
Thanks and Regards,
Chetana
|
|
|
|
|
|
| Re: Find out Process doing maximum I/O [message #457974 is a reply to message #457958] |
Wed, 26 May 2010 10:19  |
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
|
Senior Member |
|
|
Hi Mahesh
Many Thanks for the quick help. The article mentions exactly what I was looking for
1 query here (HP-UIX specific)
The article instructs following for pio
a) download pio.c and copy at /usr/local/bin
b) cc -D_PSTAT64 -o pio pio.c
Will I follow the same instructions for topio i.e. save as '.c' and call 'cc -D_PSTAT64 -o topio topio.c'?
I assume I will be able to do this as Oracle user
Thanks and Regards,
Chetana
|
|
|
|
| Re: Find out Process doing maximum I/O [message #457980 is a reply to message #457974] |
Wed, 26 May 2010 10:28 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Not sure. Depends on your environment (the HP-UX C compiler). You should be able to compile and atleast have it in your oracle path (instead of /usr/local/bin). I always have root account, so never bothered to check  .
Talk to your sysadmin. If this is a production box, ask sysadmin to do this.
[Updated on: Wed, 26 May 2010 10:32] Report message to a moderator |
|
|
|
|
|
| Re: Find out Process doing maximum I/O [message #458037 is a reply to message #457957] |
Wed, 26 May 2010 22:45 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>how can i found the a process which is doing lot of I/O in HP-UX?
SQL> desc v$sess_io
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
BLOCK_GETS NUMBER
CONSISTENT_GETS NUMBER
PHYSICAL_READS NUMBER
BLOCK_CHANGES NUMBER
CONSISTENT_CHANGES NUMBER
OPTIMIZED_PHYSICAL_READS NUMBER
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
