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
V$SESSION
Contains the current connection information of each session or in other
words each connected user.
Whereas Data Dictionary Views are static in nature and the values inside
these tables change only when you change the structure of the database.
Some of the very important Data Dictionary Views along with the brief
description of the stuff they contain are provided below.
DBA_TABLES
Contains information about the tables within the database, their row and
block information.
DBA_DATA_FILES
Contains the information about all the data files within the database,
their names, size etc.
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
Share with others: