How to calculate the approximate size of the SGA based on the size of the block

How to calculate the approximate size of the SGA based on
the size of the block,shared_pool,redo_buffer_cache and
db_buffer_cache?

Question Posted / lzhao878

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle Architecture Interview Questions

What is the function of checkpoint(CKPT)?

What are the two types of Server Configurations?

What is the maximum size of a oracle9i database?

List the Optional Flexible Architecture (OFA) of Oracle database ?

What is an Integrity Constrains in Oracle?

How the log writer writes the data into database

Which parameter in Storage clause will reduce no. of rows per block?

What is Cursor?

How will you monitor the space allocation ?

What is an Oracle Data Segment?

What are the functions of SMON?

What is the OPTIMAL parameter ?

For more Oracle Architecture Interview Questions Click Here