Bigfile tablespace introduced in which oracle version
Answers
Answered by
0
Bigfile Tablespace (BFT) is a special kind of tablespacethan can only have a single (normally very large) datafile. Normal/traditional tablespaces are referred to as smallfiletablespaces.
A BFT can only have one file, whereas a traditional tablespace (smallfile type) can contain up to 1,022 files.
BFT's simplify management. It reduces the number of databfiles to manage and storage properties can be specified on tablespace rather than datafile level.
Bigfile tablespaces should only be used with ASM or with other logical volume managers that support dynamically extensible logical volumes, striping and RAID.
A BFT can be up to 128 TB in size (with a 32k block size), while smallfile tablespaces can have a maximum size of 128 GB.
A BFT can only have one file, whereas a traditional tablespace (smallfile type) can contain up to 1,022 files.
BFT's simplify management. It reduces the number of databfiles to manage and storage properties can be specified on tablespace rather than datafile level.
Bigfile tablespaces should only be used with ASM or with other logical volume managers that support dynamically extensible logical volumes, striping and RAID.
A BFT can be up to 128 TB in size (with a 32k block size), while smallfile tablespaces can have a maximum size of 128 GB.
Similar questions