Hi,
Quick reference from documentation on Oracle Database limits
Reference:-
http://docs.oracle.com/cd/E11882_01/server.112/e24448/limits.htm
Datatype Limits: Talks about the limits for each data type eg: raw size, char size etc.
Physical Database Limits: Talks about limits of datafile, blocksizes, maxlimits etc
Logical Database Limits: Talks about limits of max subqueries, constraints, partitions,users and roles etc.
Process and Runtime Limits: Talks about limits of max services,locks,servers, etc.
-Thanks
Geek DBA
Follow Me!!!