⟩ What is Database Buffers?
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.
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.
What are Clusters in Oracle?
What is a Data File in Oracle?
What is Row Chaining in Oracle?
What is a Temporary Segment in Oracle?
What is an Index in Oracle?
What is self-referential integrity constraint in Oracle?
Explain the different type of Integrity Constraints supported by ORACLE?
Tell me how to define Data Block size?
What are Schema Objects in Oracle?
What are the type of Synonyms in Oracle?