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

What is the parameter mode that can be passed to a procedure?

811


How to define an anonymous block?

836


How to change system global area (sga) in oracle?

799


How are extents allocated to a segment?

801


Explain the use of grant option in exp command.

777


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1898


How to add a new column to an existing table in oracle?

858


How to select all columns of all rows from a table in oracle?

798


Explain about your project and its relation to the current job position you are applying to?

778


How to drop an existing view in oracle?

758


What is a system tablespace?

825


What is the usage of analyze command in oracle?

855


How to sort output in descending order in oracle?

837


State any two functions of oracle?

813


Explain table?

861