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, SUM, AVG) 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