Title: 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
How about you collect the following value from each instance on the
host, wait a few hours, then collect the numbers again? You can then
subtract the earlier values from the later values, and you'll have a
good idea which instances are using more CPU relative to the others.
SQL select value from
I'm trying to figure out how much of the srever's resources
(CPU-wise) a database and the application
You can try the following. Substitute the name of the database for ABCD
in the awk command. On a multi-cpu box, the sum can be more than %100.
ps -eo %cpu -o args | awk '$2 ~ /ABCD/
Wouldn't this only give me the statistics for
MY current session? I'm looking for the data on
all the running sessions.
Gene
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
How about you collect the following value from each
instance on the
host, wait a few hours, then collect the numbers
Even though the name of the statistic is CPU used by this session,
the v$sysstat view contains aggregated data of the statistics of all
sessions that have ever logged into your instance since it started.
For consistency, they use the same statistic names as are used by the
session-level statistics
Try Statspack ...
- Kirti
-Original Message-
Sent: Monday, November 25, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L
Even though the name of the statistic is CPU used by this session,
the v$sysstat view contains aggregated data of the statistics of all
sessions that have ever
