Avoid exceeding 2GB per file:

-- Increased risk due to various O/S and Oracle bugs over the years
(even in Oracle 8.1.7)

-- Increased unit of recovery (time to restore and roll-forward)

-- Parallelism of backup / recovery operations may be impacted

-- Certain performance restrictions past 2GB (e.g. asynchronous I/O)

-- No real need to exceed this value when overall database size is
usually under 100GB

-- File system read/write locks (without Quick I/O or raw devices)


Taken from a 2002, NF Consulting presentation

Oracle LazyDBA home page