Topics for Troubleshooting and Tuning

Systemwide Statistics

Instance/Database
V$DATABASE T
V$INSTANCE T
V$OPTION T
V$PARAMETER T/P
V$BACKUP T
V$PX_PROCESS_SYSSTAT T/P
V$PROCESS T
V$WAITSTAT T/P
V$SYSTEM_EVENT T/P

Disk
V$DATAFILE T/P
V$FILESTAT T/P
V$LOG T
V$LOG_HISTORY T
V$DBFILE T/P
V$TEMPFILE P
V$TEMPSTAT P


Memory
V$BUFFER_POOL_STATISTICS
T/P
V$DB_OBJECT_CACHE T
V$LIBRARYCACHE P
V$ROWCACHE P
V$SYSSTAT T/P
V$SGASTAT P

Contention
V$LOCK T/P
V$ROLLNAME T/P
V$ROLLSTAT T/P
V$WAITSTAT T/P
V$LATCH T/P

Session-Related Statistics

User/Session
V$LOCK P
V$OPEN_CURSOR T
V$PROCESS T
V$SORT_USAGE T/P
V$SESSION T/P
V$SESSTAT T/P
V$TRANSACTION T
V$SESSION_EVENT T/P
V$SESSION_WAIT T/P
V$PX_SESSTAT P
V$PX_SESSION P
V$SESSION_OBJECT_CACHE P


T: Troubleshooting
T/P: Troubleshooting/Performance
P: Performance