Logical Database Limits in Oracle
1)CREATE
MATERIALIZED VIEW definition size Limit
Maximum size: 64K Bytes
2)GROUP BY clause size Limit
Maximum length: Must fit within a single database block.
3)Indexes Limit
Maximum per table: Unlimited
Total size of indexed column: 75% of the database block size minus some overhead
4)Columns Limit
Maximum Per table: 1000
Maximum Per index (or clustered index): 32
Maximum Per bitmapped index: 30
5)Constraints
Maximum per column: Unlimited
6)Subqueries
Maximum levels of subqueries in a SQL statement in the FORM clause of top-level query: Unlimited
Maximum levels of subqueries in a SQL statement in the WHERE clause: 255
7)Partitions
Maximum length of linear partitioning key: 4 KB - overhead
Maximum number of columns in partition key: 16 columns
Maximum number of partitions allowed per table or index: 1024K - 1
8)Rows
Maximum number per table: Unlimited
9)Stored Packages
Maximum size: Limits typically range from 2000 to 3000 lines of code.
10)Trigger Cascade Limit
Maximum value: Operating system-dependent, typically 32
11)Users and Roles
Maximum: 2,147,483,638
12)Tables
Maximum per clustered table: 32 tables
Maximum per database: Unlimited
Physical Database Limits in oracle
Maximum size: 64K Bytes
2)GROUP BY clause size Limit
Maximum length: Must fit within a single database block.
3)Indexes Limit
Maximum per table: Unlimited
Total size of indexed column: 75% of the database block size minus some overhead
4)Columns Limit
Maximum Per table: 1000
Maximum Per index (or clustered index): 32
Maximum Per bitmapped index: 30
5)Constraints
Maximum per column: Unlimited
6)Subqueries
Maximum levels of subqueries in a SQL statement in the FORM clause of top-level query: Unlimited
Maximum levels of subqueries in a SQL statement in the WHERE clause: 255
7)Partitions
Maximum length of linear partitioning key: 4 KB - overhead
Maximum number of columns in partition key: 16 columns
Maximum number of partitions allowed per table or index: 1024K - 1
8)Rows
Maximum number per table: Unlimited
9)Stored Packages
Maximum size: Limits typically range from 2000 to 3000 lines of code.
10)Trigger Cascade Limit
Maximum value: Operating system-dependent, typically 32
11)Users and Roles
Maximum: 2,147,483,638
12)Tables
Maximum per clustered table: 32 tables
Maximum per database: Unlimited
Physical Database Limits in oracle
1)Data
Block Size Limit
Minimum: 2048 bytes; must be a multiple of operating system physical block size
Maximum: Operating system dependent; Not more than 32 KB
2)Data Blocks Limit
Minimum in initial extent of a segment: 2 data blocks
Maximum per datafile: Platform dependent; typically power(2,22) - 1 blocks
3)Controlfiles Limit
Number of control files: 1 minimum; 2 or more (on separate devices) strongly recommended.
Size of a control file: Maximum of 20,000 * (database block size)
4)Datafiles Limit
Maximum per tablespace: 1022
Maximum per database: 65533
Also, limited by the DB_FILES initialization parameter for a particular instance.
5)Database extents Limit
Maximum per dictionary managed tablespace: 4 GB * physical block size.
Maximum per locally managed (uniform) tablespace: 2 GB * physical block size.
6)Database file size Limit
Limited by maximum operating system file size.
7)MAXEXTENTS Limit
Default value: Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter
Maximum: Unlimited
8)Redo Log Files Limit
Maximum number of logfiles: Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement.
Maximum number of logfiles per group: Unlimited
9)Redo Log File Size Limit
Minimum size: 50 KB
Maximum size: Operating system limit.
10)Tablespaces:
Maximum number per database: 65533
11)Bigfile Tablespaces
Number of blocks: power(2,32)
12)Smallfile Tablespaces:
Number of blocks: power(2,22)
13)External Tables file
Maximum size: OS dependent.
Minimum: 2048 bytes; must be a multiple of operating system physical block size
Maximum: Operating system dependent; Not more than 32 KB
2)Data Blocks Limit
Minimum in initial extent of a segment: 2 data blocks
Maximum per datafile: Platform dependent; typically power(2,22) - 1 blocks
3)Controlfiles Limit
Number of control files: 1 minimum; 2 or more (on separate devices) strongly recommended.
Size of a control file: Maximum of 20,000 * (database block size)
4)Datafiles Limit
Maximum per tablespace: 1022
Maximum per database: 65533
Also, limited by the DB_FILES initialization parameter for a particular instance.
5)Database extents Limit
Maximum per dictionary managed tablespace: 4 GB * physical block size.
Maximum per locally managed (uniform) tablespace: 2 GB * physical block size.
6)Database file size Limit
Limited by maximum operating system file size.
7)MAXEXTENTS Limit
Default value: Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter
Maximum: Unlimited
8)Redo Log Files Limit
Maximum number of logfiles: Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement.
Maximum number of logfiles per group: Unlimited
9)Redo Log File Size Limit
Minimum size: 50 KB
Maximum size: Operating system limit.
10)Tablespaces:
Maximum number per database: 65533
11)Bigfile Tablespaces
Number of blocks: power(2,32)
12)Smallfile Tablespaces:
Number of blocks: power(2,22)
13)External Tables file
Maximum size: OS dependent.
No comments:
Post a Comment