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
Give the various exception types.
Explain the use of ignore option in imp command.
How to create a new user account in oracle?
How to write text literals in oracle?
What is the difference between formal parameters and actual parameters?
What is a view and how is it different from a table?
What happens to indexes if you drop a table?
What privilege is needed for a user to query tables in another schema?
How to write a query with a left outer join in oracle?
Explain the importance of .pll extension in oracle?
What are the attributes that are found in a cursor?
How to convert characters to numbers in oracle?
What is oracle sid?
What are the different editions of oracle?
Who developed oracle & when?