The logical DB contains shared pool(library cache,data dictionary cache),da

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

Question Posted / rameshkumar.k

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

Please Help Members By Posting Answers For Below Questions

What is oracle update statement with inner join ?

1117

How data locks are respected in oracle?

1113

How to rename an index in oracle?

1172

What happens if the imported table already exists?

1078

What is sequence?

1137

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

1078

Explain how are indexes update?

1124

How to define a data field as not null?

1163

What is the maximum limit on the number of columns in a table?

1152

What is the usage of analyze command in oracle?

1142

Where do we use decode and case statements?

1063

Can sub procedure/function be called recursively?

1051

Is there a combination of "like" and "in" in sql?

1116

How to execute a stored program unit?

1128

Differentiate between function and procedure in oracle.

1155