The Spoken Nerd

The Spoken Nerd

Musings on technology from long time database professional. Some times we can't dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind... Show More

Episodes

February 15, 2021 24 min

The ROWID underpins many forms of data access within the Oracle Database. If you're a newcomer to Oracle, querying the rowid from a table returns a cryptic string such as "AAAhDyABAAABd0SAAA". But head back into the earlier versions of the database, and querying the rowid would return a completely different format like "0005DD12.0000.0040". In this episode, I'll cover what the rowid is, why the format of the...

Share
Mark as Played

A tablespace is just a logical grouping of files in your Oracle database. But behind that simple definition sits a remarkable evolution of how tablespaces are defined and managed internally. This episode covers the early days of tablespaces and the pitfalls with managing their space utilisation from within the data dictionary. Then we'll move into the changes and improvements that with Oracle 8i and 8i. Finally we cover some of...

Share
Mark as Played

The beauty of databases is they we just throw SQL at it, and it handles all the heavy lifting of working out where your data is, and how best to find it. But even for the novice, it is useful to know the fundamental mechanisms in which data is stored. In this episode, I cover datafiles, segments, extents and how your queries translate to the data physically stored on disk. Finally I'll go through how all of that applies when it...

Share
Mark as Played

On StackOverflow, I chanced upon a beginner being trolled as they struggled to get going with Oracle. "Duh! Just start the database" someone said dismissively. I called out the rudeness by replying: "You don't start a database, you start an instance". So lets go back to basics, and describe Oracle in its most fundamental terms: What is a database? What is an instance? And why its important to understand the diff...

Share
Mark as Played

The Spoken Nerd is all about database tech from Connor McDonald - a database tech who has spent 20+ years working with database tech! Ever being frustrated as a child with the limits of 1 KB of RAM in his Sinclair ZX80 computer, Connor has loved the challenges that come with storing data. When the infamous Y2K did not end the world as people thought, he started presenting at conferences and now in our virtual-dominated world, a...

Share
Mark as Played

Chat About The Spoken Nerd

Advertise With Us

Popular Podcasts

True Crime Podcast Trailers
The Breakfast Club
The Breakfast Club
The World's Most Dangerous Morning Show, The Breakfast Club, With DJ Envy, Angela Yee And Charlamagne Tha God!
Fake Doctors, Real Friends with Zach and Donald
Fake Doctors, Real Friends with Zach and Donald
You know what's long, tedious and boring? Surgery. You know what isn't? This new podcast! Join Scrubs co-stars and real-life best friends Zach Braff and Donald Faison for a weekly comedy podcast where they relive the hit TV show, one episode at a time. Each week, these BFFs will discuss an episode of Scrubs, sharing behind-the-scenes stories and reminiscing on some of their favorite memories from filming. They’ll also connect with Scrubs super fans and feature beloved show cast members for exclusive interviews.

For You

    Music, radio and podcasts, all free. Listen online or download the iHeartRadio App.

    Connect

    © 2021 iHeartMedia, Inc.