Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 10: Oracle Performance Tuning
Dynamic Performance Views (V$) & Data Dictionary Views
Dynamic Performance Views or in other words all the views that start
with V$ and Data Dictionary View are views created on Oracle base
tables. These tables are Oracle Internal tables and are utilized by
Oracle. They reside in the SYSTEM tablespace and if you remember SYS is
the owner of these tables as these tables get created when we logged in
to Oracle as SYS and we ran two scripts which resulted in these Oracle
base tables and views.
Dynamic Performance Views as the name says are dynamic in nature i.e.
data inside these tables keeps changing and it depends on the current
state of Oracle system. Some of the very important Dynamic Performance
Views along with the brief description of the stuff they contain are
provided below.
V$SGASTAT
Contains information about the size of SGA (System Global Area) and each
of its major components.
V$SESSTAT
Contains the statistics information regarding the each connected session
or in other words connected user.
Chapter 10: Oracle Performance Tuning
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning