Back to Basics - Choosing a Tablespace Layout

The Spoken Nerd

Login to a customer's Oracle Database and there are all sorts of permutations of how tablespaces are being used. Sometimes there is one giant tablespace for everything. Other times there are multiple tablespaces for different schemas, or different object types. The thinking on how tablespaces should be used has evolved over many years, and in this episode we'll take a look at the history of tablespaces and why this had such an impact on how tablespace layout in databases. We'll also answer a critical question - how should you be using tablespaces today?

Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.

Download the original paper from Juan Loaiza here