Command to know which process is doing huge paging

[tayalarun]

Hi,

I am using Oracle 10.2.0.2.0 on sun solaris 10.

When I use OEM (Internet explorer version) it shows me that there is a huge paging going on.
Also I have seen the vmstat output which is showing huge paging.

For the time, I have stoped my oracle and restarted. Now from last two days, I am not seeing any problem of paging anymore.

How can I know which process is responsible for that ?

Can anyone help me to get a command to know which process is responsible for huge paging (for future) ?


Thanks & Regards

Arun Tayal

[gandolf989]

Do you use top or prstat? prstat tells you how much memory each process is using, which might help you find out who or what is causing the disk paging. But if the culprit is Oracle than you need to look for long running queries by looking at V$SESSION_LONGOPS.