Oracle 11g provides 3 levels of performance statistics :
- System statistics
- Session statistics
- Service statistics
For each level, Oracle provide cumulative statistics and Wait event statistics.
Dynamic Statistics Views
| System level | Session level | Service level |
| Cumulative view | V$SYSSTAT | V$SESSSTAT | V$SERVICE_STAT |
| Wait event view | V$SYSTEM_EVENT | V$SESSION_EVENT | V$SERVICE_EVENT |
For memory, you can also take a look at :
| Memory views |
| V$SGAINFO |
| V$SGASTAT |
| V$PGASTAT |
| V$BUFFER_POOL_CACHE |
| V$LIBRARYCACHE |
|
For contention, you can look at :
| Contention views |
| V$LOCK |
| V$UNDOSTAT |
| V$WAITSTAT |
| V$LATCH |
|
