Explain extent?

Answer Posted / rajeev ranjan

As Per oracle, data is stored in the database in the form of Data blocks, extent and Segments.
Physical space of memory is allocated to store data.
The first level is called BLOCKS, next is the extent and last is SEGMENT.
Each block can store multiple data records and Conversely, large no of data records can be stored in data Blocks.
Data is stored in DATA BLOCKS which is the smallest unit in oracle where data is stored in bytes

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the pros and cons of auto extend of table spaces?

1730


How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?

1841


How to assign a mass Tables in Auth Group by using T-code:se54

1770


Can you change the profile parameter in the os level? Which one is advisable why?

779


Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com

1887






What are the categories to execute sap background jobs?

641


Explain what is sap ides?

667


What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?

645


Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

1951


What is the difference between developer trace, system log and system trace?

710


Mention what is the purpose of table usr02?

669


How you connect ECC to EP?

1611


What is the difference between central instance & application server?

617


What are common background jobs that will run in your system?

2131


describe how SAP handles Memory Management?

669