Topics for Troubleshooting and TuningSystemwide StatisticsInstance / DatabaseV $ DATABASE TV $ INSTANCE TV $ OPTION TV $ PARAMETER T / PV $ BACKUP TV $ PX_PROCESS_SYSSTAT T / PV $ PROCESS TV $ WAITSTAT T / PV $ SYSTEM_EVENT T / PDiskV $ DATAFILE T / PV $ FILESTAT T / PV $ LOG TV $ LOG_HISTORY TV $ DBFILE T / PV $ TEMPFILE PV $ TEMPSTAT PMemoryV $ BUFFER_POOL_STATISTICST / PV $ DB_OBJECT_CACHE TV $ LIBRARYCACHE PV $ rOWCACHE PV $ SYSSTAT T / PV $ SGASTAT PContentionV $ LOCK T / PV $ ROLLNAME T / PV $ ROLLSTAT T / PV $ WAITSTAT T / PV $ LATCH T / PSession-Related StatisticsUser / SessionV $ LOCK PV $ OPEN_CURSOR TV $ PROCESS TV $ SORT_USAGE T / PV $ SESSION T / PV $ SESSTAT T / PV $ TRANSACTION TV $ SESSION_EVENT T / PV $ session_wait t / pv $ px_sesstat PV $ PX_SESSION PV $ session_Object_cache Pt: TroubleshootingT / P: Troubleshooting / PerformanceP: Performance
