What is Database Buffers ?
- 1 Answers
- 4338 Views
- I also Faced
- E-Mail Answers
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 blob data type in oracle?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to display row numbers with the records?
What is the difference between substr and instr?
What is Index Cluster ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
master table and child table performances and comparisons in Oracle ?
How to open and close an explicit cursor in oracle?
What is the difference between truncate & delete command?
How to create additional tablespaces for an new database?
What is difference between SQL and SQL*PLUS?
How to invoke the data pump export utility?
Oracle General 
