DiscoverThe Spoken NerdBack to Basics - Choosing a Tablespace Layout
Back to Basics - Choosing a Tablespace Layout

Back to Basics - Choosing a Tablespace Layout

Update: 2024-01-15
Share

Description

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


 


 

Comments 
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

Back to Basics - Choosing a Tablespace Layout

Back to Basics - Choosing a Tablespace Layout

connormcdonald