Discussion Board

Oracle Architecture Background processes : To maximize performance and accommodate many users, a multiprocess Oracle Database system uses background processes. Background processes consolidate functions that would otherwise be handled by multiple database programs running for each user process. Background processes asynchronously perform I/O and monitor other Oracle Database processes to provide increased parallelism for better performance and reliability. Tablespaces : A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments. Datafiles : They are physical structures that conform to the operating system in which Oracle is running. A database's data is collectively stored in the datafiles that constitute each tablespace of the database. Prajakta Pandit 02-16-2017 05:59 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*