TAILIEUCHUNG - 5 Managing Database Storage Structures

After completing this lesson, you should be able to d the following: • Describe how table row data is stored in blocks • Define the purpose of tablespaces and data files • Create and manage tablespaces • Obtain tablespace information • Describe the main concepts and functionality of Automatic Storage Management (ASM) | Managing Database Storage Structures Oracle Database 10g: Administration Workshop I 5- Objectives After completing this lesson, you should be able to do the following: Describe how table row data is stored in blocks Define the purpose of tablespaces and data files Create and manage tablespaces Obtain tablespace information Describe the main concepts and functionality of Automatic Storage Management (ASM) Oracle Database 10g: Administration Workshop I 5- Storage Structures Database Tablespace Segment Extent Oracle data block Logical Physical OS block OS file Storage Structures A database is divided into logical storage units called tablespaces. Each tablespace has many logical Oracle data blocks. The DB_BLOCK_SIZE parameter specifies how large a logical block is. A logical block can range from 2 KB to 32 KB in size. The default size is 8 KB. A specific number of contiguous logical blocks form an extent. A set of extents that are allocated for a certain logical structure form .

• Cơ sở dữ liệu
• workshopI
• oca 10g
• oracle
• database
• dba
• cơ sở dữ liệu
• công nghệ thông tin