| |
 |
|
Oracle
Metric
User Calls/Sec
Oracle Tips by Burleson Consulting
|
The
Oracle
Documentation notes:
The
User Calls/Sec
Oracle metric data item represents the number of logins,
parses, or execute calls per second during the sample period,
This test checks the number of logins, parses, or
execute calls. If the value is greater than or equal to the threshold
values specified by the threshold arguments, and the number of
occurrences exceeds the value specified in the "Number of Occurrences"
parameter, then a warning or critical alert is generated.
The value of this statistic will be zero if there have
not been any write or update transactions committed or rolled back
during the last sample period. If the bulk of the activity to the
database is read only, the corresponding "per second" data item of the
same name will be a better indicator of current performance.
Load Profile
~~~~~~~~~~~~ Per
Second Per Transaction
-------------- -----------
Redo size:
1,766.20 18,526.31
Logical reads:
39.21 411.30
Block changes:
11.11 116.54
Physical reads:
0.38 3.95
Physical writes:
0.38 3.96
User calls:
0.06 0.64
Parses:
2.04 21.37
Hard parses: 0.14
1.45
Sorts:
1.02 10.72
Logons:
0.02 0.21
Executes:
4.19 43.91
|
