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 select some columns from a table in oracle?
What is sequence?
How to drop a tablespace?
What is flashback in Oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
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 ?
Explain the use of record option in exp command.
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
waht is referencial integrity?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
How to get last row id?
What is the order of defining local variables and sub procedures/functions?