Player FM - Internet Radio Done Right
Checked 9M ago
Dodano three lat temu
Contenuto fornito da Connor McDonald. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da Connor McDonald o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
Player FM - App Podcast
Vai offline con l'app Player FM !
Vai offline con l'app Player FM !
Podcast che vale la pena ascoltare
SPONSORIZZATO
W
We Have The Receipts


1 Love Is Blind S8: Pods & Sober High Thoughts w/ Courtney Revolution & Meg 1:06:00
1:06:00
Riproduci in seguito
Riproduci in seguito
Liste
Like
Like aggiunto1:06:00
Happy Valentine’s Day! You know what that means: We have a brand new season of Love Is Blind to devour. Courtney Revolution (The Circle) joins host Chris Burns to delight in all of the pod romances and love triangles. Plus, Meg joins the podcast to debrief the Madison-Mason-Meg love triangle. Leave us a voice message at www.speakpipe.com/WeHaveTheReceipts Text us at (929) 487-3621 DM Chris @FatCarrieBradshaw on Instagram Follow We Have The Receipts wherever you listen, so you never miss an episode. Listen to more from Netflix Podcasts.…
The Spoken Nerd
Segna tutti come (non) riprodotti ...
Manage series 3376484
Contenuto fornito da Connor McDonald. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da Connor McDonald o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
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
…
continue reading
41 episodi
Segna tutti come (non) riprodotti ...
Manage series 3376484
Contenuto fornito da Connor McDonald. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da Connor McDonald o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
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
…
continue reading
41 episodi
Все серии
×You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In the final part of this 3 part series, Martin and I talk about working for Oracle, the latest release Oracle Database 23ai, and the role of Artificial Intelligence in general. Also, do we have any frustrations with the Oracle technology that we would like to improve? If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In this episode, Martin and I talk about the role of social media (blogs, video etc) in technical education, and cover the database books he has authored or co-authored over the years. And along similar lines to co-authorship, how Martin came to be working with Enkitec, a company renowned for having some of the best minds in the Oracle Database community. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In this episode, Martin and I talk about the beginnings of his Oracle career and how we had a lot in common with our experiences in the United Kingdom, even working for the same company at some point. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
A common theme in my 30 years of using Oracle technology is that people love to label any and all things Oracle as "cool tech but way too expensive" . But this argument is a reflection of a very dated view of Oracle, because times have changed. Nowadays there is a plethora of tools, platforms and initiatives provided by Oracle that are 100% free to take advantage of. In the same way that I don't run ads on this podcast :-) here is part 2 of my exploration of all of the cool Oracle stuff you can exploit without paying a cent. Links from the show Pre-Built VMs https://www.oracle.com/downloads/developer-vm/community-downloads.html Vagrant on Oracle Github https://github.com/oracle/vagrant-projects Running WordPress on Oracle Cloud https://www.youtube.com/watch?v=D_S5VI7zZSs Running MineCraft on Oracle Cloud https://recursive.codes/p/how-to-setup-and-run-a-free-minecraft-server-in-the-cloud Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…
A common theme in my 30 years of using Oracle technology is that people love to label any and all things Oracle as "cool tech but way too expensive" . But this argument is a reflection of a very dated view of Oracle, because times have changed. Nowadays there is a plethora of tools, platforms and initiatives provided by Oracle that are 100% free to take advantage of. In the same way that I don't run ads on this podcast :-), here's an episode that tells you all of the cool Oracle stuff you can exploit without paying a cent. Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…
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…
There's a reason we don't just lump all of our data into Excel, Word and other such tools. Databases exist to give rigour to our data. They are the "statement of record" - the proof that our applications are meeting any business and/or regulatory requirements. The data stored in the database is typically the evidence that we provide to auditors and legal representatives that we are not breaking any rules. But are you sure that your data will pass an audit? In this episode, I examine a real customer example - a customer that thought they were meeting all of their legal requirements, only to hit a firestorm when an audit of the database suggested otherwise. Achieving a correct ordering of transactions whilst still allowing high concurrency is an often overlooked issue. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
If you are the only person using a PC, then the concept of having to lock information is totally foreign, because all of the data is yours and yours alone. But databases were built for the multi-user world, where concurrent access to the data is the norm. To handle this, we sometimes need to lock the data to ensure it is controlled and updated in a way that guarantees integrity and correctness. In this episode, we discuss the "Optimistic" and "Pessimistic" locking strategies, how they are used to handle the "Lost Update" problem, and what role the internet played in changing our view of database locking. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions. Blog post referred to in the episode: https://stewashton.wordpress.com/2017/06/17/avoiding-lost-updates-with-ora_rowscn/…
Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so. Maria has nearly 3 decades of experience with the Oracle Database, covering SQL, performance, and the optimizer and even OS/2. In this episode, Maria and I talk about the rise of DevOps, the recent popularity of AI engines, her presentation style both in-person and on YouTube, plus some of personal passions such as going on safari and the Oscar movie cycle. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so. Maria has nearly 3 decades of experience with the Oracle Database, covering SQL, performance, and the optimizer and even OS/2. In this episode, Maria and I talk about what a face to face meeting with Larry Ellison is like; the cool features coming in 23c; JSON as the new data exchange standard and of course, her beloved Tesla :-) If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so. Maria has nearly 3 decades of experience with Oracle, covering performance, the optimizer and even OS/2. In this episode, Maria and I talk about how she landed the role of Optimizer Product Manager, whether hints should be documented, and the obsolescence of the rule optimizer. We also chat about the role of social media for the modern IT practitioner. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so. Maria has nearly 3 decades of experience with Oracle, covering performance, the optimizer and even OS/2. In this episode, Maria and I talk about the beginnings of her Oracle career and how it led to Product Management, plus reminisce on our shared Irish heritage. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, and a unique perspective on how Oracle has evolved over the years. Dominic Giles has 30+ years of experience with Oracle, and that makes him the perfect guest to talk about the Oracle Database. In this episode, Dom and I talk about CloudWorld, the role of the DBA in modern IT, and whether microservices is a good thing or just a giant mistake we'll never recover from. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, and a unique perspective on how Oracle has evolved over the years. Dominic Giles has 30+ years of experience with Oracle, and that makes him the perfect guest to talk about the Oracle Database. In this episode, Dom and I talk about our favorite releases, how features get chosen for new releases, and how to best tackle patching your systems to keep them secure and up to date. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, and a unique perspective on how Oracle has evolved over the years. Dominic Giles has 30+ years of experience with Oracle, and that makes him the perfect guest to talk about the Oracle Database. In this episode, I catch up with Dom to talk about the his origin story with Oracle, and what he's seen change over the years of his time there. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Databases are incredibly sophisticated pieces of software, and hence as they mature, the algorithms and logic behind what at first glance would seem to be trivial functionality are often amazing in their cleverness and cunning. In this episode we'll explore the complexity and sophistication around what would seem to be the simplest of questions: When I want to insert a row into a table, where should the database store that row? For a database to answer that question, it needs to know which table blocks are empty, which ones are full and how to manage multiple sessions all asking for which blocks to use all at the same time. Time for some insight into the High Water Mark for a database table, and its impact on your applications. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we can become similarly jaded, reduced to the cliche of "grumpy old IT folk". Thus in this series, in my attempt to recapture the enthusiasm of youth :-), I catch up with a young woman at the very start of her IT career. Layla Massey is studying software engineering at college, and has just completed a summer internship at Oracle. To finish off this 3-part series, we discuss the challenges facing women in IT even at the college level, the role of exercise for work/life balance, how to exploit a social media presence to get ahead in the IT industry, and how to build a personal brand. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we can become similarly jaded, reduced to the cliche of "grumpy old IT folk". Thus in this series, in my attempt to recapture the enthusiasm of youth :-), I catch up with a young woman at the very start of her IT career. Layla Massey is studying software engineering at college, and has just completed a summer internship at Oracle. In this episode, we explore whether the content in college database courses matches the demands of the real world IT profession, what part IT professional have to play when it comes to ethical computing, and somehow ended up on a discussion about The Wiggles and Tame Impala! If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we can become similarly jaded, reduced to the cliche of "grumpy old IT folk". Thus in this series, in my attempt to recapture the enthusiasm of youth :-), I catch up with a young woman at the very start of her IT career. Layla Massey is studying software engineering at college, and has just completed a summer internship at Oracle. In this first episode, we chat about how she scored the internship (and the cool merch that came with it!), how her interest in IT commenced, the Oracle volunteer program, and her first experiments with social media. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
I first met Jackie McIlroy a few years back where she was an attendee at a pre-covid conference. Since then she has gone from strength to strength in the Oracle community, being a much-sought after speaker, an Oracle Ace, ODTUG committee member and chair for the Kscope APEX program. I caught up with her at the Kscope22 conference in Dallas Texas to chat about the impact of APEX and Community on her career. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Databases are incredibly complex pieces of software, which can come as a surprise given that anyone can throw together a few lines of C code to read and write data from a file. What differentiates a database from simple file read/write is how databases handle concurrent access to the data. For many years, the feature that has set Oracle Database apart from all others is its "read consistency" implementation or Multi Version Concurrent Control (MVCC). We've all heard the mantra: readers don't block writers; writers don't block readers. In this episode we'll explore why the feature is so cool, but also see what such flexibility could also lead a developer down the wrong path to corrupted data. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Parsing is the act of preparing to execute a SQL statement on your database. It would seem to be a necessary activity - after all, that is what databases are designed to do - execute SQL. But the topic of parsing requires a more nuanced look, because a high transaction frequency database typically succeeds or fails based the amount of SQL parsing it does. In this episode, I'll take you on a trip down memory lane on how slow servers used to be "Get Out Of Jail Free" card for IT practitioners, but how hardware advancements have shifted the responsibility for successful applications squarely back on the shoulders of developers. The way you handle parsing on the Oracle database could open the door to the incredible firepower of modern servers...or leave you scratching your head wondering why your CPUs are running hot but no work is getting done. And believe it or not...if you have used a public restroom, you are well on the way to understanding how parsing relates to building scalable applications :-) If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
No topic quite gets emotions rolling as much as the Oracle Query Optimizer. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optimizers. In this episode, I ambush Nigel with some questions that came in from Twitter from the Oracle community. In particular, how to optimize queries that contain TABLE functions, and what is best way for developers to quickly and efficiently tackle SQL tuning. Keep updated with the optimizer at https://blogs.oracle.com/optimizer. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
No topic quite gets emotions rolling as much as the Oracle Query Optimizer. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optimizers. In this episode, Nigel and I tackle the area that perhaps causes the most anxiety for database professionals when it comes to the optimizer, that is, what is going to change when upgrade. Keep updated on the optimizer at https://blogs.oracle.com/optimizer If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
No topic quite gets emotions rolling as much as the Oracle Query Optimizer. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optimizers. In this episode, I get Nigel's thoughts on SQL Plan Management, the types the statistics that the optimizer needs now and what it might need in future, and whether setting statistics is a good idea. Keep updated with Nigel's thoughts on the optimizer at https://twitter.com/vldbb If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
No topic quite gets emotions rolling as much as the Oracle Query Optimizer. The fact that a piece of software can determine the best way to run the myriad of potential SQL statements, no matter how poorly they sometimes might be written, never ceases to amaze me. But conversely, the moment the optimizer does not meet our expectations, we're quick to throw our toys out of the pram and rain down on it with our invective. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optimizers. In this series, I catch up with Nigel to talk about the optimizer, its various features, how it has evolved over the years and what might be coming in future. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
The very name of the product - Application Express (APEX) - suggests that this is a tool solely for building applications, and thus it should belong solely in the realm of developers. But that is underselling the ability of APEX to be a perfect use case for a different IT demographic - the Database Administrator. In this episode I present my reasons for APEX is a vital part of the DBA toolkit, and how a DBA using APEX can free up their time to more efficiently manage the databases in their organisation. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions. Check out APEX at https://apex.oracle.com/…
Chances are, if you have Googled for help on an Oracle problem, you have ended up on a concise yet precise solution to your problem at oracle-base.com. The site has been running for over 20 years and gets millions of hits from the Oracle community. In this episode I wrap up the three-part chat with Tim by focussing on the latest release of the database 21c and its free companion, 21c Express Edition. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Chances are, if you have Googled for help on an Oracle problem, you have ended up on a concise yet precise solution to your problem at oracle-base.com. The site has been running for over 20 years and gets millions of hits from the Oracle community. In part 2 of this three-part series, I dive into how Tim got the oracle-base.com site started and how both of us have been trying our hand at YouTube for tech content. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
Chances are, if you have Googled for help on an Oracle problem, you have ended up on a concise yet precise solution to your problem at oracle-base.com. The site has been running for over 20 years and gets millions of hits from the Oracle community. In this three-part series, I catch up with the owner of the site, and good mate, Tim Hall to talk tech, blogging, video and everything else that grabbed our attention. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
If you're an Oracle developer, what is the most important skill you need? Is it database modelling? Is it SQL coding? Its none of these. I believe the core of being a successful modern developer is something far far simpler. Most of us get into the IT field because we like solving problems, so the most difficult challenge for many of us when we hit a problem that we cannot solve is being able to reach out for help . You might be surprised to find that being able to ask questions is actually a skill , a skill that takes practice and nuance to master. In this episode, I'll give you my thoughts on how to ask questions that will maximize your chances of getting the answers you need to succeed in your chosen role. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…
With the modern trend of automated testing, it is often easy to fall into the trap of relying solely on automation, especially when emotionally as developers we hard-wired to a bias of success. If you write working code, you are valued by your team. Your remuneration and career progression are often linked to working code. Thus as motivated as we want to be about finding bugs in our code with thorough testing, it is easy to fall prey to writing "blue sky" applications; applications that only work well when the conditions are right. But part of the developers job is to discover how their code works when the storm clouds hover. How does your code hold up under more extreme conditions? In this episode, I'll talk about why testing to destruction is an important part of building successful database applications. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments and questions.…
SQL Tuning - It is probably the biggest topic in database technology, and it is little surprise why. There is nothing sexier than diving into the heart of the application code, making a few changes and then basking in the admiration of your colleagues as you have once again saved the day! But that very allure of getting our ego stroked can mean that you have lost sight of where you are supposed to be tuning things. In this episode, I'll explore things from a different angle, namely, that SQL tuning is perhaps not where you should be focussing your efforts when it comes to performance issues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…
Pick up a reference book and there will most likely be an index at the back to help you locate particularly topics. Are database indexes the same? The goal of indexes in the database is allow rapid lookup of a known value in a table. But how do they achieve this? The secret lies on the structure used by indexes to ensure that finding a value even in billions of rows can be virtually instantaneous. In this episode, we'll extend the book metaphor to explain how database indexes work. Enjoy! Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…
Every database has indexes...but should they? In this episode, lets consider a different proposition. What if the indexes you have on your database are a mistake...A bug... An implementation error. Give me 30 minutes to convince you of a whole new mindset when it comes to indexes on your database. Enjoy! Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…
Can it be done? Can you delve into the hex dumps, the byte headers, the acronyms all wrapped up in the magic that is an Oracle Database block with no slides, no code, no demos and no visuals? Who knows, but I'll give it my best shot! Don't panic, this is not an episode about digging into internals just for the sake of digging. I'll take a look at the main components of a database block, why they exist, and how these components come together to achieve the concurrency and performance of the Oracle Database that we all love. Enjoy! Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions. Addenda: OK, I did cop out a little bit here :-), because if you do want a visual to accompany this episode, then you can get a screenshot of a typical data block dump by clicking here , but its not mandatory for the session.…
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 rowid has evolved over the years, and reveal the extremely clever way this evolution occurred - an evolution that allowed the rowid to store more information in the same number of bytes, and as a result, gave rise to multi-petabyte databases. You can also get a video version of the details in this episode on my YouTube channel here…
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 the more niche tablespace types that you may possibly have never used or even heard of. This episodes also sets you up for the big topic to cover in the next episode ... the ROWID. Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…

1 How does SELECT * FROM TABLE find its data? Back to basics with datafiles, segments and extents 32:50
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 comes running a basic SELECT statement to scan a table - how does the database locate your data? Catch me on twitter https://twitter.com/connor_mc_d if you have questions.…
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 difference. Catch me on Twitter at https://twitter.com/connor_mc_d…
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 podcast seemed the perfect fit.…
Benvenuto su Player FM!
Player FM ricerca sul web podcast di alta qualità che tu possa goderti adesso. È la migliore app di podcast e funziona su Android, iPhone e web. Registrati per sincronizzare le iscrizioni su tutti i tuoi dispositivi.