Question
Bigfile versus smallfile tablespaces: what differs operationally?
Answer
A bigfile tablespace has one datafile or tempfile; a smallfile tablespace can have multiple. Use bigfile for simpler file administration; use smallfile where multiple files suit placement or growth practices.