what are the components of database architecture?
Answers were Sorted based on User's Feedback
Answer / hannan oca
according to oracle database
1.Oracle instance
SGA(system global area)
shared pool
buffer memory for transactions
Redo log buffer
large pool
java pool
PGA(program global area)
2 Memory slots(for datatables)
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / trupti b.raul.
Oracle Primary Component-
1.oracle Database
2.oracle server
3.Oracle instance
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / john
instance-bg process(ckpt,dbwr,lgwr,dnnn,pmon,smon),memory(sga,pga)
storage-tablespace(segment,extent,block),physical files(parameter file,data file, etc)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nagireddy karri
The main components of oracle database architecture are
Oracle instance(System Global Area and BackGround Processes)
oracle database(datafiles,control files,online
redologgroups)
Is This Answer Correct ? | 0 Yes | 1 No |
What is a two tier wage system?
Explain about recursive stored procedures?
What is external database?
can we use transformer in datastage without any input link?
What is parallel database architecture?
What is Multivalued dependency?
What is E-R model?
What is Data Storage - Definition Language?
What is a Relation Schema and a Relation?
Why fastload support to empty table?
What is durability in DBMS?
What is database architecture? : sql server architect