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 key activities that you perform as part of sap basis support?

790


What are the daily activates?

788


How many types of work processes?

864


What are patches you applied?

989


What are the different user types in sap system that an admin can use while creating a new user?

845


How many types of work processes are there in sap ?

853


What is the difference between asynchronous and synchronous transport?

791


What is the difference between kernel replacement and support package?

907


What are the scripts you can create for security by using LSMW??

2444


Explain how client refresh is different than client copy?

841


A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?

1617


What are the activities you done in EP?

1459


What are the types of transport queries?

816


Explain what is heterogenous system copy and homogenous system copy ?

799


Explain checkpoint?

768