Explain extent?

Answer Posted / rajeev.meetme@gmail.com

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, nexxt 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

How you will do that?

1623


What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?

2745


Can you tell me installation procedure of SAP on UNIX

1956


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3169


Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate

1584






How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

768


you want to take sap backup using brtools. How would you do that?

682


What is the use of profile paramater ztta/roll_area?

671


How can you view locked transactions?

620


dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?

4035


How do I know what threshold values to set

1575


How you will rate yourself in SAP, Oracle from a scale 1 - 10?

1822


Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

2708


1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix

1556


What is the information derived from OSS notes?

6180