Tuesday, July 22, 2008

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

Related Documents
Physical Database Limits in oracle
Datatype Limits in Oracle

No comments:

Post a Comment