What is data block in Oracle?
- 1 Answers
- 1194 Views
- MCN Solutions, I also Faced
- E-Mail Answers
Answer / Akash Kumar Misra
A Data Block is a fixed-size unit of storage in Oracle Database. Each data block typically contains multiple rows from one or more tables, depending on the table's structure and block size settings. Data blocks are essential for efficient data management because they reduce I/O operations by caching frequently accessed data within the SGA (System Global Area). When a user queries data, the database first checks if the required data block is in the buffer cache; if not, it reads the data block from disk into the buffer cache.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what are the different type of segments?
What is tns entry?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
How to delete all rows a table in oracle?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
What is the purpose of save points in oracle database?
How to export your own schema?
Hi Can any one tell me what are the API's used in requisition import.
What is a Data Segment ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
how to unbreak sequence numbers during intereptions
what is data abstraction
Oracle General 
