Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

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 4: Understanding Oracle Database

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

 

Oracle database has a logical architecture as well as physical architecture. When we talk about database objects e.g. tables we are actually talking about logical architecture and when are talking about physical files like control file, data files etc., we are actually talking about physical architecture of Oracle database.



Physical Architecture

Physical architecture of Oracle Database is comprised of five different types of files.


Chapter 4: Understanding Oracle Database

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

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: