Re: exsessive paging, which ora process ?

Rahul, I cut this from a MetaLink forum response. The entire conversation can found at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=41122.999

Your question may be able to be found if you have root access and the time to search through each procees or you can take the time to put this into a shell and loop through the oracle processes to find out who is being a hog.

• Brian

-- 
As root, you can type the command svmon -Pa where pid is the pid of an
oracle process (say dbwr). You will see something like: 

Pid Command Inuse Pin 
Pgspace 
92044 oracle 14757 3766 
11448 

Pid: 92044 
Command: oracle 

Segid Type Description Inuse Pin Pgspace Address Range 
13693 pers /dev/u13lv:2820 0 0 0 0..256 
f12c pers /dev/u13lv:2819 10 0 0 0..6400 
7546 pers /dev/u13lv:2818 0 0 0 0..138 
2081 pers /dev/u13lv:2817 6 0 0 0..3840 
7e27 pers /dev/u13lv:2816 125 0 0 0..20480 
1e37f pers /dev/u13lv:2812 9 0 0 0..246 
14d74 pers /dev/u13lv:2811 9 0 0 0..246 
a709 pers /dev/u13lv:2810 9 0 0 0..246 
11e30 pers /dev/u13lv:2809 0 0 0 0..-1 
efaf pers /dev/u13lv:176129 6 0 0 0..65 
19ddb pers /dev/u13lv:45505 0 0 0 0..0 
5141 pers /dev/u13lv:51037 2 0 0 0..15 
4004 work kernel extension 323 322 1 0..24603 : 
65339..65535 
2146 work lib data 47 0 23 0..5573 
11011 work shared library text 1416 0 428 0..65535 
10e1 work sreg[3] 762 0 763 0..1356 
1e07a work private 217 1 218 0..722 : 
65296..65535 
f9af pers code,/dev/u13lv:164005 1718 0 0 0..5284 
0 work kernel 10098 3443 10015 0..24429 : 
39487..65535 

Type refers to persistent pages (i.e. files) or work pages. The SGA 
consists of work segments of description sreg[?], with sreg[3] being
the first one. 
The number of SGA pages that are paged out can be calculated by 
substracting Inuse pages from PGspace. In this example, we have 763
total SGA pages (4KB each), and 763-762=1 page that is paged out. 


Regards 
Tom Villane 
Metalink Analyst 

-- 

--- Rahul <rahul_at_ratelindo.co.id> wrote:


> List,

> our AIX suddenly stpped responding... and we had to kill some of the

> oracle (LOCAL=NO) processes to return the system back to normal...

> 

> apparently the paging space filled up..and OS was unable to create

> any more

> proceses....

> 

> is there any way to know which oracle process is responsible for

> exsessive

> paging ?

>               

> regards

> rahul

> 



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: brian_wisniewski_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).