第二章 体系结构

第二章 体系结构

[/align]
2.2 The files[align=center]

1.The files associated with an instance are simply:
Parameter files--These files tell the Oracle instance where to find the control files.
2.The files that make up the database are:
1)Data files--For the database(these hold your tables, indexes and all other segments)
2)Redo log files--Our transaction logs
3)Control files--Which tell us where these data files are, and other relevant information about their state
4)Temp files--Used for disk-based sorts and temporary storage
5)Password files--Used to authernticate users performing administrative activities over the network.
2.2.1 Parameter files
1.There are many different parameter files associated with an Oracle database, from a TNSNAMES.ORA files on a client workstation, to a LISTENER.ORA file on the server, to the SQLNET.ORA,PROTOCOL.ORA,NAMES.ORA,CMAN.ORA,and LDAP.ORA files