Back to the basics: TABLESPACES… low level style

There are a lot of myths and legends about storing segments in tablespaces – should we keep indexes separated from the tables? Can we stop worrying about segment fragmentation? What is real difference between MOVE and SHRINK?

At this session I will present you my free C++ tool to visualize the contents of the datafile. We will disassemble a database block and try to understand how Oracle is really managing space inside tablespaces.

Dienstag, 21.11.2017
13:00 - 13:45
Seoul
Anfänger
English
Datenbank
Demo
Stawiarski

Kamil Stawiarski

Database Whisperers sp. z o. o. sp. k.
Oracle ACE-DirectorOracle OAK-Table
Oracle Database Whisperer, performance maker and story teller. Oracle Certified Master and Oracle ACE. Owner of the ORA-600 [Database Whisperers sp. z o. o. sp. k.] company and blogger (blog.ora-600.pl). Trainer in Oracle Partner Academy and founder of Pint with Oracle User Group (poug.org) Personally a big fan of Terry Pratchett: "Wisdom comes from experience. Experience is often a result of lack of wisdom."

Weitere Vorträge, die Sie interessieren könnten