taking this thread further...... if we check the sysstat # 203,204 OS Page faults OS Swaps how accurate OS paging statistics these parameters would provide ? regards > ---------- > From: JAGAN RAO[SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 28, 2001 1:26 PM > To: 'Rahul' > Subject: RE: exsessive paging, which ora process ? > > <<File: topuser.txt>><<File: dub_kill_defunct.txt>> > Ps -ef | sort -nr -k8,8 is a quick command to get cpu hoggers in sorted > order. > > Go through the attached script and customize for your needs. > > <<topuser.txt>> > <<dub_kill_defunct.txt>> > > -----Original Message----- > From: Rahul [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 28, 2001 7:51 AM > To: 'JAGAN RAO' > Subject: RE: exsessive paging, which ora process ? > > jagan, yes i did exactly the same... added another paging space > and the things were ok..... now i want to investigate from oracle > and identify the hog process.... > > thanks > > PS: we have 1GB RAM.. and the paging space was 1GB also... now we > have > increased > to 2GB... ... > > > ---------- > > From: JAGAN RAO[SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, February 28, 2001 10:50 AM > > To: 'Rahul' > > Subject: RE: exsessive paging, which ora process ? > > > > > > Can you log in as root from console? > > > > If yes, did you try to increase the paging space as a temporary > measure. > > Once things are under control, you can disable the extra paging > space and > > get back the space during the next reboot. > > > > Warm regards, > > Jagan Rao. > > > > -----Original Message----- > > From: Rahul [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, February 27, 2001 1:41 PM > > To: 'Oracle List I'; 'Oracle List II' > > Subject: exsessive paging, which ora process ? > > > > 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 > > > > > > -------- > > Think you know someone who can answer the above question? > Forward it > > to them! > > to unsubscribe, send a blank email to > > [EMAIL PROTECTED] > > to subscribe send a blank email to > [EMAIL PROTECTED] > > Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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).
