What is Database Buffers ?

Answer Posted / sawant

Database buffers are cache in the SGA used to hold the data
blocks that are read from the data segments in the
database such as tables, indexes and clusters
DB_BLOCK_BUFFERS parameter in INIT.ORA decides the size.

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 divide query output into groups in oracle?

640


What are the differences between date and timestamp in oracle?

653


How to install oracle database 10g xe?

645


What are group functions in oracle?

655


How many types of tables supported by oracle?

673






Why cursor variables are easier to use than cursors?

656


what is reindexing?

1234


What is memory advisor in Oracle?

714


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1963


Can a formula column be obtained through a select statement ?

1948


Can multiple columns be used in group by in oracle?

626


What is difference between sid and service name in oracle?

594


How is it different from a normal table?

653


How to pass parameters to procedures in oracle?

669


Oracle

1941