tailieunhanh - G Miscellaneous Topics

Appendix Overview This appendix assists you to: • Use bigfile tablespaces for very large databases (VLDB) • Describe the row IDs for bigfile tablespaces • Use temporary tablespace groups (TTG) for VLDB BFT ROWI TTG | Miscellaneous Topics Appendix Overview This appendix assists you to: Use bigfile tablespaces for very large databases (VLDB) Describe the row IDs for bigfile tablespaces Use temporary tablespace groups (TTG) for VLDB BFT ROWID TTG Bigfile Tablespaces: Overview A bigfile tablespace contains a single file. The maximum file size ranges from 8 TB through 128 TB. Tablespaces are logically equivalent to data files. Database Tablespace SMALLFILE Data file BIGFILE Data file Bigfile Tablespaces: Overview A bigfile tablespace (BFT) is a tablespace containing a single file that has a very large size. The addressing scheme allows up to four billon blocks in a single data file, and the maximum file size can be 8 TB–128 TB depending on the Oracle block size. To distinguish a BFT from the traditional tablespace that can contain multiple, relatively small files, the traditional tablespace is referred to as a “smallfile” tablespace. An Oracle database can contain both bigfile and smallfile . | Miscellaneous Topics Appendix Overview This appendix assists you to: Use bigfile tablespaces for very large databases (VLDB) Describe the row IDs for bigfile tablespaces Use temporary tablespace groups (TTG) for VLDB BFT ROWID TTG Bigfile Tablespaces: Overview A bigfile tablespace contains a single file. The maximum file size ranges from 8 TB through 128 TB. Tablespaces are logically equivalent to data files. Database Tablespace SMALLFILE Data file BIGFILE Data file Bigfile Tablespaces: Overview A bigfile tablespace (BFT) is a tablespace containing a single file that has a very large size. The addressing scheme allows up to four billon blocks in a single data file, and the maximum file size can be 8 TB–128 TB depending on the Oracle block size. To distinguish a BFT from the traditional tablespace that can contain multiple, relatively small files, the traditional tablespace is referred to as a “smallfile” tablespace. An Oracle database can contain both bigfile and smallfile tablespaces. The BFT concept eliminates the need for adding new data files to a tablespace. This simplifies manual or automatic management of the disk space (using Oracle Managed Files (OMF) or Automated Storage Management (ASM)) and provides data file transparency. The graphic in the slide shows the entity-relationship diagram of the Oracle database space management architecture. The one-to-many relationship between tablespaces and data files complicates the architecture and can create difficulties in managing disk space utilization whenever one tablespace is associated with hundreds of data files. The BFT concept makes the notion of tablespaces logically equivalent to data files. All operations traditionally performed on data files can be performed on tablespaces. Benefits of Bigfile Tablespaces Significantly increase the storage capacity Simplify data file management for large databases by making tablespaces the main units of disk space administration BFT 1 8 EB 4 billion blocks One-to-one

• Cơ sở dữ liệu
• workshop II
• ocp 10g
• oracle
• database
• Database systems
• Lecture Database systems
• Database system concepts
• Database architecture
• Database approach
• Database languages
• Lecture Database system concepts
• Database design
• Database system architectures
• Relational database design
• Oracle Database 2 Day
• Oracle Database Administrators
• Oracle Database Backup
• Oracle Database Concepts
• Oracle Database Licensing
• Oracle Database Net
• Database concepts
• Lecture Database concepts
• Database fundamentals
• Database management
• Database administration
• Database processing environment
• Cài đặt database NorthWind
• Cách cài đặt database NorthWind
• Quy trình cài đặt database NorthWind
• Bước cài đặt database NorthWind
• Hình ảnh cài đặt database NorthWind
• Link tải database NorthWind
• Database development
• Relational databases
• Database environments
• Database characteristics
• Database specialists
• Fundamentals of database systems
• The relational data model
• Database programming techniques
• Relational database constraints
• Database System
• Relational database design algorithms
• Introduction to Database Systems
• Entity Relationship model
• Database security
• Database systems concepts
• Database systems architecture
• Data management systems framework
• Lecture Database System
• Practical database design and tuning
• Physical database design
• Database tuning in relational systems
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Object database management systems
• Object database
• Data models
• Hierarchical model
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Relational model
• Structured Query Language
• Data modeling
• Representing weak entities