Basic knowledge of Oracle: Cui Xiuhua Published: 2001/01/16
Thesis:
Oracle basic knowledge.
text:
Oracle Basic Knowledge A Table Space You can only belong to a database. Each database is at least one control file (recommended 3, which is placed on different disks) Each database has a table space (System table space) to establish system table space. The aim is to try to put the same table as the destination to improve the use efficiency. Each database has the least two online log files. A data file can only belong to a table space. One data file is added to a table space, it is no longer From this table space, it is no longer added to other tablespaces to create new tablespaces. You need to create new data file data files by Oracle to Oracle block. The size of the Oracle block is when the database is created. Setting, and in the future, a single transaction cannot be changed. You cannot span multiple returning segments. No ROWID value has a rollback segment with different sizes. There is no benefit Oracle to create a default database when installing, instance is named orcl The maximum length of the block is 16KB (2K, 4K, 8K, 16K) Each database maximum file number (by block size) 2K block 2000 file 4K block 40000 file 8K block or above 65536 file Oracle Server can start more A set of ORACLE database systems can be installed on a set of operating systems A version of the Oracle database system can have multiple Oracle databases Each Oracle database has a database instance (Instance), so there are many operating systems. Oracle database instance launched.