what are the components of database architecture?
Answer Posted / muthukumar
the major two components of oracle database architecture is
oracle instsnce and database.
-- instance allocate in RAM memory
-- database allocate in harddisk memory
-- instance classifieds into memory components and background process
-- memory component classifieds into SGA,PGA,UGA
-- BACKGROUND PROCESS classifieds into system monitor(SMON),process monitor(PMON), DBwriter, LOGwriter, checkpoint, etc....
-- the logical unit of database is tablespace
-- tablespace physically consist of datafile,control file, log file
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Illustrate physical database architecture in brief? : sql server architect
What is "transparent DBMS"?
What is DDL Interpreter?
What is the Disadvantage in File Processing System?
What are the levels of architecture?
What is System R? What are its two major subsystems?
Name the sub-systems of a RDBMS?
What is 2NF?
Explain logical database components? : sql server architect
What is Relationship set?
What is a Relation Schema and a Relation?
What is E-R model?
Explain about the return statement?
What is Multivalued dependency?
What is a query?