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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).