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
What is degree of Relationship type?
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?
What is single tier architecture?
Explain about the return statement?
What are the the Advantages of DBMS?
Name the sub-systems of a RDBMS?
What is a Relation Schema and a Relation?
Name the buffer in which all the commands that are typed in are stored
What is Relationship set?
What is hypermedia database?
Where the procedures are stored in database?
What is 4NF?
what is the difference between LENGTH AND SIZE?
What is DML Compiler?
What is master database? : sql server architect