A database - one tablespace & one datafile
Posted by Sidhu on June 10th, 2008
Today I was checking OTN forums and came across a thread. OP’s concern was:
One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file.
the system is linux 4 , 32 bit.
oracle version is 10.2.0.4
Is there a limit of space for a tablespace when you consider insert/delete/query performance?
Single datafile of 3.3 TB 
Awesome !
Kudos to the designer 