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)

Answer / trupti b.raul.

Oracle Primary Component-
1.oracle Database
2.oracle server
3.Oracle instance

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

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)

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)

Answer / sharmisha.9

storage processor
query processor

What is Functional Dependency?

0 Answers  

Why fastload support to empty table?

0 Answers   CTS,

What is system catalog or catalog relation? How is better known as?

0 Answers  

What is DML Compiler?

0 Answers  

What is an Entity type?

0 Answers  

What is a business logic layer?

0 Answers  

What are the unary operations in Relational Algebra?

0 Answers  

Which part of the RDBMS takes care of the data dictionary? How

0 Answers  

What is difference between two tier and three tier?

0 Answers  

what is the difference between LENGTH AND SIZE?

0 Answers   Enercon,

Does storing of data in stored procedures increase the access time? Explain?

0 Answers  

What is Lossless join property?

0 Answers