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


Please Help Members By Posting Answers For Below Questions

What is degree of Relationship type?

535


in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1099


What is single tier architecture?

444


Explain about the return statement?

482


What are the the Advantages of DBMS?

491






Name the sub-systems of a RDBMS?

471


What is a Relation Schema and a Relation?

496


Name the buffer in which all the commands that are typed in are stored

430


What is Relationship set?

466


What is hypermedia database?

446


Where the procedures are stored in database?

483


What is 4NF?

509


what is the difference between LENGTH AND SIZE?

2136


What is DML Compiler?

575


What is master database? : sql server architect

485