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 query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
Why do you use stored procedures and state some of its disadvantages?
What are group functions in oracle?
What are the differences between interval year to month and interval day to second?
Which Oracle App Is Most Popular One ?
Describe the different type of Integrity Constraints supported by ORACLE ?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
Where is the export dump file located?
Explain a synonym?
Can multiple cursors being opened at the same time?
What is oracle datasource?
Explain coalesce function?