RE: how do I calculate the Oracle's usage

Hi Gene,

Wouldn't top at least be a place to start? You could take snapshots of what's happening on top several times throughout the day and at least make a quick guesstimate from there. You could also look at sar - I forget which switch displayes cpu usage.

This is a very simplistic approach and I'm sure there's probably tools and other more specific and detailed metrics available since you are so lucky to have a UNIX machine.

Lisa Koivu
Oracle Database Monkey.
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063

> -----Original Message-----
> From: Gurelei [SMTP:gurelei_at_yahoo.com]
> Sent: Monday, November 25, 2002 9:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: how do I calculate the Oracle's usage
>
> Hi.
>
> I'm trying to figure out how much of the srever's
> resources (CPU-wise) a database and the application
> running against it is taking. There are several
> databases on that server and I'm only interested in
> one so vmstat won't really help that much. Besides
> just running ps -ef | grep INSTANCE is there any other
> way for me to get a feeling of the load that puts on
> the CPU my database?
>
> thanks
>
> Gene
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gurelei
> INET: gurelei_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: Lisa.Koivu_at_efairfield.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).