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