Database Tuning (MOSC)

MOSC Banner

a good method to estimate tu number of CPU used by a database 10gR2

edited Mar 15, 2010 4:51AM in Database Tuning (MOSC) 4 commentsAnswered
 hi,

I try to calculate the number of CPU used by my database 10gR2/AIX 5.3.

To do that, i use the V$SYS_TIME_MODEL.DB CPU view. Every 60s, I catch the value. I get this :

TPSVAL2
03/15/2010 14:16:354 135 544 925
03/15/2010 14:15:294 130 584 792
03/15/2010 14:14:294 127 171 066
03/15/2010 14:13:294 124 511 808
03/15/2010 14:12:294 122 359 695
03/15/2010 14:11:294 110 312 219
03/15/2010 14:10:284 100 555 420
03/15/2010 14:09:284 096 417 214
03/15/2010 14:08:284 092 871 892
03/15/2010 14:07:284 090 567 017
03/15/2010 14:06:284 088 155 539
03/15/2010 14:05:284 084 864 310

by example to calculer le number of CPU between 14:05:28 and 14:06:28 :

(4 088 155 539 - 4 084 864 310)/1000000< 1CPU (rule : 1 CPU = 60s)

Is it a good method or not ?

is a good method ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center