Question

What is the use of extent in oracle

Answer 1

$\huge\mathcal{\red {\underline {\overline {\mid {\pink {Answer}}\mid}}}}$

• ᴀɴ ᴇxᴛᴇɴᴛ ɪs ᴀ ʟᴏɢɪᴄᴀʟ ᴜɴɪᴛ ᴏғ ᴅᴀᴛᴀʙᴀsᴇ sᴛᴏʀᴀɢᴇ sᴘᴀᴄᴇ ᴀʟʟᴏᴄᴀᴛɪᴏɴ ᴍᴀᴅᴇ ᴜᴘ ᴏғ ᴀ ɴᴜᴍʙᴇʀ ᴏғ ᴄᴏɴᴛɪɢᴜᴏᴜs ᴅᴀᴛᴀ ʙʟᴏᴄᴋs.
• ᴏɴᴇ ᴏʀ ᴍᴏʀᴇ ᴇxᴛᴇɴᴛs ɪɴ ᴛᴜʀɴ ᴍᴀᴋᴇ ᴜᴘ ᴀ sᴇɢᴍᴇɴᴛ.
• ᴡʜᴇɴ ᴛʜᴇ ᴇxɪsᴛɪɴɢ sᴘᴀᴄᴇ ɪɴ ᴀ sᴇɢᴍᴇɴᴛ ɪs ᴄᴏᴍᴘʟᴇᴛᴇʟʏ ᴜsᴇᴅ, ᴏʀᴀᴄʟᴇᴀʟʟᴏᴄᴀᴛᴇs ᴀ ɴᴇᴡ ᴇxᴛᴇɴᴛ ғᴏʀ ᴛʜᴇ sᴇɢᴍᴇɴᴛ.

Answer 2

An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents in turn make up a segment. When the existing space in a segment is completely used, Oracle allocates a new extent for the segment.