Oracle related rants (and lots of off-topic stuff)…
In today’s video we’ll discuss the Adaptive Cursor Sharing feature, introduced in Oracle 11g Release 1.
This video is based on the following article.
Here are some other things you might want to check out.
The star of todays video is Franck Pachot, who is clearly looking for an exit. 🙂
Cheers
Tim…
In today’s video we’ll discuss the CURSOR_SHARING parameter, which determines how the database handles statements containing literal values.
The video is based on this article.
You may also find these useful.
The star of today’s video is Toon Koppelaars from the Real World Performance Group at Oracle, and of #SmartDB fame. 🙂
Cheers
Tim…
PS. I’ve already noticed I say “after login”, when I mean “after logon”. 🙂
In today’s video we’ll discuss how using bind variables in your database applications can improve performance, and protect against SQL injection attacks.
This videos is based on a demo I do in one of my presentations, which was itself based on these articles.
The star of today’s video is Bjoern Rost, of asymmetric man thong fame. In his past life, Bjoern was one of the many people who got me through a speaking tour in one piece. 🙂
Cheers
Tim…
In today’s video we discuss a change to the old DBMS_JOB scheduler from 19c onward.
This video is based on the following article.
You may find these useful as well.
The star of today’s video is Liron Amitzi, who took a break from shopping to film this. You might notice some familiar faces in the background and on the video screen to the side… 🙂
Cheers
Tim…
In today’s video we’ll discuss Scalable Sequences, which were documented for the first time in Oracle 18c.
The video is based on this article.
The star of today’s video is David Peak, who is now working on the Oracle Pandemic Response Systems. This video is a throwback to a hotel we stayed in at São Paulo a few years back.
Cheers
Tim…
In today’s video we’ll discuss how to build a 2-node RAC setup using Vagrant.
This video is based on the OL8 19c RAC build, but it’s similar to that of the OL7 19c RAC build also. If you don’t have access to the patches from MOS, stick with the OL7 build, as it will work with the 19.3 base release. The GitHub repos are listed here.
If you need some more words to read, you can find descriptions of the builds here, as well as a beginners guide to Vagrant.
The video is a talk through of using the build, not an explanation of each individual step in the build, as that would be a really long video. If you just want a RAC to play with, run the build and you’ll have one. If you want to learn about the steps involved in doing a RAC build, read the scripts that make up the build. Please don’t ask for a GUI step through of a build or I’ll be forced to ask you to read Why no GUI installations anymore? 🙂
The star of today’s video is Neil Chandler, who seems to be doing a bit of plumbing! 🙂
Cheers
Tim…
In today’s video we discuss how Temporal Validity can make querying of effective date ranges simpler in Oracle 12c and beyond.
The video is based on this article.
The syntax looks similar to Flashback Query and Flashback Version Query.
The star of today’s video is a knitted creation by the wife, Debra Lilley. I’m not entirely sure what it is. Maybe a sea squirt? I’m sure I’m going to get into trouble for not knowing, as I’m sure it’s a perfect representation… 🙂
Cheers
Tim…
Update. Debra just told me it’s a Coronavirus… 🙂
In today’s video we’ll discuss how Resource Manager allows us to manage the disk I/O (IOPS, MBPS) usage in PDBs. This can be useful to stop a small number of PDBs using all disk IOPS and/or bandwidth on the server.
The video is based on the following article.
You might also find these useful.
The star of the today’s video is my dad Graham Wood, who is now living a life of leisure. Unfortunately the travel restrictions mean I won’t be able to visit him this year. 🙁
Cheers
Tim…
In today’s video we’ll discuss how Resource Manager allows us to manage the memory usage in PDBs. This can be useful to stop a small number of PDBs using all memory assigned to the instance.
This video was based on this article.
You might also find these useful.
The star of today’s video is Emanuel Oliveira. He wanted his clip to go on a video about machine learning, but I suggested I may not be the guy to do that… 🙂
Cheers
Tim…
In today’s video we’ll discuss how Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling. This can be useful to stop a small number of PDBs using all CPU resources assigned to the instance.
This video is based on the following article.
Most of this information was in my instance caging article, but I’ve moved it into this separate article now.
You might also find these useful.
The star of today’s video is Bailey. He has a human called Connor McDonald. I suspect Bailey got is human to voice the video…
Cheers
Tim…