------------------provides a general purpose record I/O capability and maintains basic data about files
Answers
Answered by
133
Question:
_________provides a general purpose record I/O capability and maintains basic data about files.
Answer: Logical I/O
Logical I/O provides a general purpose record I/O capability and maintains basic data about files.
Additional Info:-
Logical I/O:
- It is the data block accessed from Buffer Cache
- Its statistics in captured in db block get, consistents gets, bufer is pinned count, session logical read
- LIO may have incurred a PIO in order to get into the cache in the first place.
- Db block gets is the state of the block as it exists consistents gets is the blocks read from the buffer cache in a consistent state.
- This stats is clearly visible as db block gets and consistent gets in Autotrace executed.
- We can find this for statement from cr+cu in raw trace data
Hope it helps ya!!
Mark as Brainliest
Similar questions