|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Oracle 10.1 Service Statistics
The V$SERVICE_STATS dynamic performance view was introduced in Oracle 10.1.
The following table shows the 28 statistics reported by V$SERVICE_STATS in Oracle 10.1:
|
| Name |
| application wait time |
| cluster wait time |
| concurrency wait time |
| db block changes |
| DB CPU |
| DB time |
| execute count |
| gc cr block receive time |
| gc cr blocks received |
| gc current block receive time |
| gc current blocks received |
| logons cumulative |
| opened cursors cumulative |
| parse count (total) |
| parse time elapsed |
| physical reads |
| physical writes |
| redo size |
| session cursor cache hits |
| session logical reads |
| sql execute elapsed time |
| user calls |
| user commits |
| user I/O wait time |
| user rollbacks |
| workarea executions - multipass |
| workarea executions - onepass |
| workarea executions - optimal |
|
|
