Oracle related rants (and lots of off-topic stuff)…
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…
In today’s video we give a quick demonstration of using the SQL Quarantine features of Oracle Database 19c.
It’s a follow-on to last week’s video.
Today’s video is a cut down of this article.
These might come in handy too.
The star of today’s video is Martin Widlake. I put out a message to “The Family” as I had run out of “.com” clips, and Martin was the first one back. He sent three, but this one had me laughing, and suited the quarantine theme. 🙂
Cheers
Tim…
PS. If you want to send me a clip with you saying “.com”, you know where I am.
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…