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 dynamic sql in oracle?

562


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

833


What are the differences between lov and list item?

534


Is there any function in oracle similar like group_concat of mysql?

506


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4908






How to invoke the data pump export utility?

533


Where do you use decode and case statements?

525


How to open a cursor variable?

584


What is a cursor and what are the steps need to be taken?

574


What is an external table?

564


What privilege is needed for a user to create views in oracle?

566


Compare and contrast between sql and sql server and explain its various functions?

501


What is meant by an index?

585


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2480


What happens if you use a wrong connect identifier?

479