How Does Oracle's Core RDBMS work?


About the Webinar:
Despite the complexity and capability of the Oracle database, at it's heart there are a relatively small number of key activities and processes. If you understand them, you will get a lot more out of the database and advanced topics make a lot more sense. In this presentation I explain the key things the database does and how they work together. If you know what a SELECT statement is, you will understand this talk. And by the end of it, you will know some things that even many experienced developers and DBAs don't know.

In this webinar, you will learn:
  • The two ways Oracle reads data from disc and how it writes it back.
  • That REDO is actually the most important part of the database. 
  • What happens when you COMMIT.
  • Why Oracle data blocks are key to the buffer cache.
  • What a "Consistent Get" really is.
  • Why indexes are so powerful and what "balanced B-tree index" actually means.
  • What Oracle does when you give it a SQL statement to run.
  • How Oracle ensures you see the correct data, even as it is changing.

About the Presenter:


Martin Widlake is an independent Oracle consultant based in the UK. An Oracle ACE Director and member of the OakTable Network, he regularly presents internationally on Oracle performance, database design and PL/SQL. He co-wrote the book “Real World SQL and PL/SQL . Martin has provided consultancy to several large financial organisations and FTSE 500 companies as well as much smaller companies. For several years he was the database services manager for the UK side of the Human Genome Project, combining his I.T. skills with his background in Genetics.

Comments

Post a Comment

Popular posts from this blog

My Coding Experience with an AI Assistant

Image
  AI is real and it is here. Its implications for knowledge workers will be enormous, including you. There is no escaping AI in our line of work. Therefore, while building the new version of   Gitora PL/SQL Editor , I’ve fully embraced it. The last few months have been the most interesting, rewarding and productive period of my professional life. I’ve practically stopped using Google search and StackOverflow, two websites I’d consider essential to my work just a few months ago. I’ve coded the Gitora PL/SQL debugger virtually without reading a single line of documentation about how to build debuggers in Java or the specifics of how to build a Java debugger for PL/SQL. I am not even sure if there is any documentation available about building a PL/SQL debugger on the Internet. I just talked about these topics with ChatGPT and analyzed, used the code snippets it produced. All CSS and almost all of the run-of-the-mill code I needed to write for the debugger and the Gitora AI Assistant for S
Read more

A New Product for Podcast Listeners

Image
W e're excited to announce our first consumer product. Introducing Listen Later Listen Later  converts articles into podcasts, narrated by our advanced AI with a human-like quality . Email us an article and Listen Later will swiftly turn it into a podcast episode in your personal feed, accessible on any podcast app. Launch Special Sign up now and get free credits to convert multiple articles into audio and enjoy this unique service. Why You Will Love Listen Later Convenience Redefined:   Transform articles into podcasts. Listen while you drive, exercise, or relax. Exceptional Audio Quality:   Enjoy natural, human-like AI narration. It's like listening to a storyteller, but powered by cutting-edge technology. Seamless Experience:   Using Listen Later is as easy as sending an email. There is no app to install and it's available on all devices and podcast apps. Learn More at ListenLater.net
Read more

Monitoring Oracle Database with Zabbix

Attend our free webinar and learn how you can use Zabbix, the open source monitoring solution, to monitor your Oracle Database instances? The webinar is presented by Oracle ACE and Certified Master Ronald Rood. About the Webinar: Enterprise IT is moving to the Cloud. With tens, hundreds even thousands of servers in the Cloud, monitoring the uptime, performance and quality of the Cloud infrastructure becomes a challenge that traditional monitoring tools struggle to solve. Enter Zabbix. Zabbix is a low footprint, low impact, open source monitoring tool that provides various notification types and integrates easily with your ticketing system. During the webinar, we'll cover the following topics: Installation and configuration of Zabbix in the Cloud Monitoring Oracle databases using Zabbix How to use Zabbix templates to increase the quality and efficiency of your monitoring setup How to setup Zabbix for large and remote networks How to trigger events i
Read more