Physical Database Limits
轉自Oracle官方:
Oracle? Database Reference
10g Release 2 (10.2)
Part Number B14237-04Physical Database Limits
10g Release 2 (10.2)
Part Number B14237-04Physical Database Limits
Item | Type of Limit | Limit Value |
---|---|---|
Database Block Size | Minimum | 2048 bytes; must be a multiple of operating system physical block size |
Maximum | Operating system dependent; never more than 32 KB | |
Database Blocks | Minimum in initial extent of a segment. | 2 blocks |
Maximum per datafile | Platform dependent; typically 222 - 1 blocks | |
Controlfiles | Number of control files | 1 minimum; 2 or more (on separate devices) strongly recommended |
Size of a control file | Dependent on operating system and database creation options; maximum of20,000 x (database block size) | |
Database files | Maximum per tablespace | Operating system dependent; usually 1022 |
Maximum per database |
65533
May be less on some operating systems Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance |
|
Database extents | Maximum per dictionary managed tablespace | 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier) |
Maximum per locally managed (uniform) tablespace | 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier) | |
Database file size | Maximum | Operating system dependent. Limited by maximum operating system file size; typically 222 or 4 MB blocks |
MAXEXTENTS | Default value | Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter |
Maximum | Unlimited | |
Redo Log Files | Maximum number of logfiles |
Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement
Control file can be resized to allow more entries; ultimately an operating system limit |
Maximum number of logfiles per group | Unlimited | |
Redo Log File Size | Minimum size | 50 KB |
Maximum size | Operating system limit; typically 2 GB | |
Tablespaces | Maximum number per database |
64 K
Number of tablespaces cannot exceed the number of database files because each tablespace must include at least one file |
Bigfile Tablespaces | Number of blocks | A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks. |
Smallfile (traditional) Tablespaces | Number of blocks | A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 datafiles or tempfiles, each of which can contain up to approximately 4 million (222) blocks. |
External Tables file | Maximum size |
Dependent on the operating system.
An external table can be composed of multiple files. |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20802110/viewspace-1063230/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Physical Database LimitsOracleDatabaseMIT
- Oracle 10g Limits - Logical Database LimitsOracle 10gMITDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- Creating a Physical Standby DatabaseDatabase
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- Oracle10G Physical Standby Database setupOracleDatabase
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- oracle 10g physical standby database creationOracle 10gDatabase
- Recover physical standby database after loss of archive log(2)DatabaseHive
- 同事總結的 : 用RMAN建立Physical Standby DatabaseDatabase
- oracle 9i physical standby database 中v$database switchover_status的含義OracleDatabase
- oracle 9i physical standby database狀態查詢OracleDatabase
- oracle10g data guard(dg)__flashback_physical databaseOracleDatabase
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- Physical Standby上開啟flashback database實驗日誌Database
- Brief description of Oracle physical standby database configuration and managementOracleDatabase
- Brief description of Oracle physical standby database configuration and managemeOracleDatabase
- Recover physical standby database after loss of archive log – roll forward(轉)DatabaseHiveForward
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- ORACLE10G DG配置下Physical Standby Database的管理OracleDatabase
- oracle 9i physical standby database 上的v$archived_logOracleDatabaseHive
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- 【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby DatabaseDatabase
- limits.hMIT
- teradata limitsMIT
- Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- 配置oracle 9i physical standby database時,duplicate命令的執行記錄OracleDatabase
- 配置Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- Creating a 10gr2 Data Guard Physical Standby database with Real-Time applyDatabaseAPP
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE WithoutGUIIDEDatabase
- nginx 修改 max open files limitsNginxMIT
- How To Change UNIX Process Resource LimitsMIT
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- 11gR2中使用duplicate建立physical standby (從rman備份或從active database)Database
- Physical Storage StructuresStruct