Oracle tablespace Functions

Oracle tablespace functions compared with other databases, the primary feature of Oracle data is the introduction of tablespaces. This article describes the Oracle tablespace. Oracle Database pioneered the design concept of tablespace, which makes an indelible contribution to the high performance of Oracle Database. In this case, many Oracle optimizations are implemented based on the tablespace design concept.
The ORACLE database is divided into logical regions called tablespaces-forming the logical structure of the ORACLE database. One ORACLE database can have one or more tablespaces, while one tablespace corresponds to one or more physical database files. Table space is the minimum unit for ORACLE database recovery. It contains many database entities, such as tables, views, indexes, clustering, rollback segments, and temporary segments. Www.2cto.com each ORACLE database has a SYSTEM tablespace, which is automatically created when the database is created. The SYSTEM tablespace must always be online, because it contains the basic information required for running the database (data dictionary, online help mechanism, all rollback segments, temporary and auto-lifting segments, all user database entities, tables required by other ORACLE software products ). The ORACLE database of a small application usually only contains the SYSTEM tablespace. However, the ORACLE database of a slightly large application uses multiple tablespaces, which makes the database more convenient to use. So what functions can Oracle tablespace accomplish? For more information, see the following: 1. determines the space allocation of database entities; 2. set the Space share of database users. 3. control the availability of some data in the database; 4. data is distributed between different devices to improve performance. back up and restore data. Xu depeng