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 to use subqueries in the from clause in oracle?

579


What is varray?

587


What happens to the indexes if a table is recovered?

577


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1436


What are the different oracle database objects?

586






What do you understand by a database object?

587


Give the various exception types.

543


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1564


Explain the use of record length option in exp command.

557


How to use "while" statements in oracle?

735


How oracle handles dead locks?

600


What is the difference between alert log file and tarce file ?

1634


what is Single Byte Overhead...?

2060


How to turn on or off recycle bin for the instance?

609


How to create a stored procedure in oracle?

574