TAILIEUCHUNG - Using Oracle Blocks Efficiently

After completing this lesson, you should be able to do the following: Use automatic segment space management Use manual segment space management Manage extents and Oracle blocks Ensure effective use of space Determine the high-water mark Describe the use of Oracle block parameters Recover space from sparsely populated segments Describe and detect chaining and migration of Oracle blocks Perform index reorganization | Using Oracle Blocks Efficiently Objectives After completing this lesson, you should be able to do the following: Use automatic segment space management Use manual segment space management Manage extents and Oracle blocks Ensure effective use of space Determine the high-water mark Describe the use of Oracle block parameters Recover space from sparsely populated segments Describe and detect chaining and migration of Oracle blocks Perform index reorganization Database Storage Hierarchy Tablespace Segments Blocks Extents Extents Extents Space Management The efficient management of space in the database is important to its performance. This section of the lesson examines how to manage extents and blocks in the database. Blocks In an Oracle database, the block is the smallest unit of data file I/O and the smallest unit of space that can be allocated. An Oracle block consists of one or more contiguous operating system blocks. Extents An extent is a logical unit of database storage space .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.