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 |
What is the difference between Delete, Truncate and Drop in Oracle?
What is a public synonym?
How to get the Installed Oracle Version Information ?
How to delete all rows a table in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to get last row id?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
How to retrieve first and last records from a table?
How to invoke the original export import utilities?
How to execute the package in oracle?
What is PL/SQL ?
What is a procedure in oracle?