DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Command to know which process is doing huge paging


    I am using Oracle 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

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.