Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Command to know which process is doing huge paging

479582Feb 5 2007 — edited Feb 5 2007

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2007

Added on Feb 5 2007

#general-database-discussions

3 comments

367 views