les10 man tblspc20 tell me




Tablespaces, Segments and Data Blocks









The interactions in this eCourse require Javascript to be enabled.



 

Tablespaces, Segments, and Data Blocks


previous|next






Database objects, such as tables and indexes, are stored as segments in tablespaces. Each segment contains one or more extents. An extent consists of contiguous data blocks, which means that each extent can exist in only one data file. Data blocks are the smallest unit of I/O in the database. When the database requests a set of data blocks from the operating system (OS), the OS maps this to an actual file system or disk block on the storage device. Because of this, you need not know the physical address of any of the data in your database.
 
 
 
 






Wyszukiwarka

Podobne podstrony:
les10 man tblspc10 tell me
les10 man mem20 tell me
les10 man tblspc10 show me
les10 man tblspc20 show me
les10 man mem10 tell me
les10 man usr10 tell me
les10 man usr21 tell me
les10 man usr20 tell me
les10 man set20 tell me
les10 man set10 tell me
les10 man usr10 show me
les10 man mem10 show me
les10 man set10 show me
les10 man usr20 show me
les10 mon?20 tell me
les10 mon?10 tell me
les05 ins tab20 tell me
Geri Halliwell Don t?ll me?by

więcej podobnych podstron