What is Database Buffers ?
Answer / 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 |
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Select the Nth lowest value from a table?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How to view all columns in an existing table?
How can we find the size of a database?
Can we call a trigger inside a function and function inside a trigger? Give example.
What is memory advisor in Oracle?
How to define an oracle sub procedure?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is pragma autonomous transaction in oracle?
what is foreign key?
How do I limit the number of rows returned by an oracle query after ordering?