Command to know which process is doing huge paging
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Command to know which process is doing huge paging

  1. #1
    Join Date
    Dec 2005
    Posts
    19

    Command to know which process is doing huge paging

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    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