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

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1834


Explain the use of grant option in imp command.

774


How would you change old and new values in an insert, delete and update triggers?

797


What is set operator oracle?

739


Please explain joins in oracle?

825


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

884


What are the different types of record groups in oracle? Explain each of them

801


Why is oracle so popular?

766


What is the difference between a hot backup and a cold backup in oracle?

790


How to define a sub function?

896


What is the difference between a user and a schema in oracle?

831


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2068


List the various oracle database objects?

830


Explain what are the type of synonyms?

865


What is the difference between online and offline backups?

769