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
What is the dynamic sql in oracle?
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.
What are the differences between lov and list item?
Is there any function in oracle similar like group_concat of mysql?
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.
How to invoke the data pump export utility?
Where do you use decode and case statements?
How to open a cursor variable?
What is a cursor and what are the steps need to be taken?
What is an external table?
What privilege is needed for a user to create views in oracle?
Compare and contrast between sql and sql server and explain its various functions?
What is meant by an index?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What happens if you use a wrong connect identifier?