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 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…
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 demonstration of Simple Oracle Document Access (SODA) for SQLcl. SODA is a feature of Oracle REST Data Services (ORDS),
but this allows to access the document store directly from SQLcl.
This video is based on the following article.
You might find these useful.
The star of today’s video is Kris Rice, who’s essentially singing “dot com” underwater. 🙂
Cheers
Tim…
In today’s video we give a demonstration of Simple Oracle Document Access (SODA) for PL/SQL. SODA is a feature of Oracle REST Data Services (ORDS),
but this PL/SQL interface for SODA was introduced in Oracle Database 18c.
The video is based on this article.
You might find these useful.
The star of today’s video is the son of Dan Iverson. Dan, not his son, is an Oracle ACE focusing on PeopleSoft and Oracle Cloud Architect. He’s also in Army National Guard, which means he’s already prepared for the zombie apocalypse! 🙂
Cheers
Tim…
In today’s video we’ll give a demonstration of Simple Oracle Document Access (SODA) for REST. This is a feature of Oracle REST Data Services (ORDS).
This video is based on the following article.
There are some other resources that might come in handy.
The star of today’s video is the son of Rodrigo Mufalani. Rodrigo is a fellow Oracle ACE and you can check out Rodrigo’s blog here.
Cheers
Tim…
In today’s video we’ll give a demonstration of Real-Time Statistics in Oracle Database 19c.
This video is based on the following article.
This is essentially a follow-on from the previous video and article.
The star of today’s video is Ludovico Caldara, who is rocking a rather “different” look. I’ll leave it to you to decide if it’s an improvement or not! 🙂
Cheers
Tim…
Today’s video gives a demonstration of Online Statistics Gathering for Bulk Loads.
This is based on this article.
The star of today’s video is my sister-in-law Maria Colgan, otherwise know as SQLMaria. You may know her by her former names of “the in-memory lady” and “the optimizer lady”. Maria sent me three different clips, with one looking like she’s running for president. I’m sure these will appear in future videos… 🙂
Cheers
Tim…
In today’s video we give a quick demonstration of using catcon.pl to run scripts against multiple pluggable databases (PDBs) in a container database (CDB).
The video is based on one section of this article.
You can find loads of information about living with CDBs and PDBs in the following articles and the YouTube playlist linked below.
The star of today’s video is my long suffering wife Debra Lilley. Clearly suffering because of her social isolation, which of course means not seeing me. 🙂
Cheers
Tim…
In today’s video we’ll give a quick demonstration of using the APEX command-line export utility.
The video is based on this article, which includes more examples, and Windows-based examples also.
The star of today’s video is my daughter Heli “Hell-Squirel” Helskyaho. Make sure you check out the cloud forming a Pikachu tail above her head! 🙂
Cheers
Tim…