Oracle architecture components - Oracle Architecture

Q.  Which of the following components comprise of an oracle architecture?
- Published on 12 Aug 15

a. Database related background processes
b. Tablespaces
c. Datafiles
d. All of the above

ANSWER: All of the above
 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    -The following are the components which comprise of an 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.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)