Oracle DBA

Storage, Tablespaces, ASM & Partitioning

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.

This is 4 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples