martes, 20 de enero de 2015

Tip: Límites físicos de una Base de datos Oracle

Para aquellos que desean poner al límite una base de datos Oracle 11g y 12c, con motivos perversos, claro.

"El único límite para nuestra comprensión del mañana serán nuestras dudas del presente."
Franklin Delano Roosevelt 


Item
Tipo of Limite
Valor para Oracle 11g R2-12g R1
GROUP BYclause
Maximum length
The GROUP BY expression and all of the no distinct aggregate functions (for example, SUMAVG) must fit within a single database block.
Indexes
Maximum per table
Unlimited
Indexes
Total size of indexed column
75% of the database block size minus some overhead
Columns
Per table
1000 columns maximum
Columns
Per index (or clustered index)
32 columns maximum
Columns
Per bitmapped index
30 columns maximum
Constraints
Maximum per column
Unlimited
Subqueries
Maximum levels of subqueries in a SQL statement
Unlimited in the FROM clause of the top-level query
Partitions
Maximum length of linear partitioning key
255 subqueries in the WHERE clause
Partitions
Maximum number of columns in partition key
4 KB - overhead
Partitions
Maximum number of partitions allowed per table or index
16 columns
Subpartitions
Maximum number of subpartitions in a composite partitioned table
1024K - 1
Rows
Maximum number per table
Unlimited
System Change Numbers (SCNs)
Maximum
281,474,976,710,656, which is 281 trillion SCNs
Stored Packages
Maximum size
PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from 2000 to 3000 lines of code.
Trigger Cascade Limit
Maximum value
Operating system-dependent, typically 32
Users and Roles
Maximum
2147483638
Tables
Maximum per clustered table
32 tables
Tables
Maximum per database
Unlimited