Oracle related rants (and lots of off-topic stuff)…
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 instance caging to manage CPU usage. This can be useful when we are trying to consolidate multiple instances on a single server.
This video is based on the following article.
The star of today’s video is the beard belonging to Victor Torres. I feel totally inadequate with my patchy stubble… 🙂
Cheers
Tim…
In today’s video we give a quick demonstration of using Resource Manager to cancel a long running SQL statement.
This video is based on a series of articles from Oracle 8i to the present day. There is an example here.
Although there are aspects of it throughout most of the Resource Manager articles on the website.
The horror show was brought to you by Jeff Smith. Notice his proximity to assorted torture devices he probably describes as “tools” when questioned by the authorities.
Cheers
Tim…
In today’s video we’ll take a look at installing Podman on Oracle Linux 8 (OL8).
This is based on the article here.
You can see more information about containers here.
The star of today’s video is John King. John’s been on the channel a couple of times before. Once to do a message to one of his super-fans, a work colleague of mine who was impressed that I know John, and once for a regular “.com” appearance. I blame the wife for the terrible audio. 🙂
Cheers
Tim…
In today’s video we work through some examples of using the NTILE analytic function to solve some specific problems.
The video is based on the following article.
You might find these useful also.
The star of today’s video is Alex Nuijten‘s daughter, but I thought I better include him also or he would get jealous. 🙂
Cheers
Tim…
Today’s video demonstrates how to expand SQL references to views using the DBMS_UTILITY.EXPAND_SQL_TEXT procedure. This functionality was introduced in Oracle 12.1.
The video was based on this article.
The stars of today’s video are Sanjay Kumar, Baljeet Bhasin and Jagjeet Singh, who I met and chatted to at a previous OpenWorld. 🙂
Cheers
Tim…
In today’s video we demonstrate the invisible columns feature introduced in Oracle 12.1.
The video is run through of the examples in this article.
The star of today’s video is John O’Keeffe from More4apps. I first bumped into John many years ago at a conference in Australia, and since then I’ve seen him at a number of events around the world. 🙂
Cheers
Tim…
In today’s video we’ll give a demonstration of how to shrink tables that contain a lot of free space. As I say in the video, this is not something you should do regularly. It’s only necessary if you’ve done some drastic one-off maintenance, like a large data purge maybe.
There are a few articles this relates to.
The star of today’s video is Kellyn Pot’Vin-Gorman, who is returning to her Oracle roots, but on Azure. 🙂
Cheers
Tim…
Today’s video is a demonstration of returning REF CURSORs from PL/SQL using functions, procedures and implicit statement results.
I was motivated to do this after a conversation with my boss. He’s from a .NET and SQL Server background, and was a bit miffed about not being able to use a SELECT to pass out variable values from a procedure, like you can in T-SQL. So I piped up and said you can using Implicit Statement Results and another myth was busted. I guess most PL/SQL developers don’t use this, and I don’t either, but you should know it exists so you can be a smart arse when situations like this come up. 🙂
The video is based on these articles.
The star of today’s video is Bryn Llewellyn of PL/SQL fame, and more recently Yugabyte.
Cheers
Tim…
Today’s video demonstrates how to use a Secure External Password Store to hold database credentials in a client wallet.
The video is based on this old article.
The star of today’s video is John King. This is actually his second staring role on the channel. The other one was called Making Dreams Come True: Video for a Superfan. 🙂
Cheers
Tim…