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 |
How to write a query with an inner join in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is Partitions in Table ?
List out the difference between commit, rollback, and savepoint?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
How to apply filtering criteria at group level in oracle?
query optmization techniques and quwry analyser+projects+ppts
What are the commands youd issue to show the explain plan for select
Explain the use of show option in imp command.
What is define in oracle?
Explain oracle instance.
25. Display the client number and the value of the highest value order placed by that client.