What are the components of Logical database structure of
ORACLE database?

Answer Posted / rameshkumar.k

The logical DB contains shared pool(library cache,data dictionary cache),data buffer cache,redolog buffer,java buffer and large pool.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different type of segments?

578


What privilege is needed for a user to create tables in oracle?

548


What are the different types of trigger and explain its various uses and functions?

551


What is the use of aggregate functions in oracle?

581


What is the data pump import utility?

583






What exactly do quotation marks around the table name do?

544


What are the varoius components of physical database structure of oracle database?

567


what are the default admin accounts in Oracle 10g ?

508


Write a trigger example in oracle?

573


How to connect the oracle server as sysdba?

633


How to use regular expression in pattern match conditions in oracle?

575


What is oracle database client?

555


Design database draw er diagram for a certain scenario ?

4105


How to define an anonymous block?

618


What is bulk collect in oracle?

553