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

Give the various exception types.

773


Explain the use of ignore option in imp command.

799


How to create a new user account in oracle?

810


How to write text literals in oracle?

875


What is the difference between formal parameters and actual parameters?

774


What is a view and how is it different from a table?

758


What happens to indexes if you drop a table?

946


What privilege is needed for a user to query tables in another schema?

772


How to write a query with a left outer join in oracle?

859


Explain the importance of .pll extension in oracle?

789


What are the attributes that are found in a cursor?

858


How to convert characters to numbers in oracle?

840


What is oracle sid?

715


What are the different editions of oracle?

860


Who developed oracle & when?

787