10.12 V$SERVICE_STATS
V$SERVICE_STATS
displays a minimal set of performance statistics. These call rate statistics are used for making run-time routing decisions, for tracking service levels, and for per-instance diagnostics per call rate. The elapsed timing for each call provides a relative value across instances for how well a node is processing SQL calls issued under a service name.
When aggregation is enabled for the Service Name, then this view provides the timing and work done for calls issued for the whole service.
Column | Datatype | Description |
---|---|---|
|
|
Service name hash from |
|
|
Service name from |
|
|
Statistic identifier |
|
|
Derived statistic name from |
|
|
For statistics that measure time (such as the DB CPU, background elapsed time, or parse time elapsed statistics), this column displays a cumulative value in microseconds. For other statistics that do not measure time (such as the db block changes, execute count, or logons cumulative statistics), this column displays the appropriate numeric value for the statistic. |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
Oracle Database Performance Tuning Guide for more information about using database statistics to manage the performance of Oracle Database