exsessive paging - from v$sysstat

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:jaganr_at_dubal.co.ae]
> 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:rahul_at_ratelindo.co.id]
> 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:jaganr_at_dubal.co.ae]
> > 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:rahul_at_ratelindo.co.id]
> > 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
> > oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> >
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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).