Category: Video

Video : Vagrant : Oracle Database Build (19c on OL8)

Today’s video is an example of using Vagrant to perform an Oracle database build.

In this example I was using Oracle 19c on Oracle Linux 8. It also installs APEX 19.1, ORDS 19.2, SQLcl 19.2, with ORDS running on Tomcat 9 and OpenJDK 12.

If you’re new to Vagrant, there is an introduction video here. There’s also an article if you prefer to read that.

If you want to play around with some of my other Vagrant builds, you can find them here.

If you want to read about some of the individual pieces that make up this build, you can find them here.

The star of today’s video is Noel Portugal. It’s been far too long since I’ve seen you dude!

Cheers

Tim…

Video : AVG, MEDIAN, MIN and MAX : Problem Solving using Analytic Functions

In today’s video we take a quick look at the AVG, MEDIAN, MIN and MAX aggregate and analytic functions.

You can get more information on these and more analytic functions here.

The star of today’s video is Sten Vesterli, in one of the rare moments at OpenWorld when he’s not in a wetsuit. 🙂

Cheers

Tim…

Video : FIRST_VALUE and LAST_VALUE : Problem Solving using Analytic Functions

Today’s video is a quick run through the FIRST_VALUE and LAST_VALUE analytic functions.

You can find more information about these and other analytic functions in the following articles.

The star of today’s video is Lonneke Dikmans. She probably won’t believe me, but I probably quote/paraphrase her advice more often than any other person in the Oracle space.

Cheers

Tim…

Video : LAG and LEAD : Problem Solving using Analytic Functions

Today’s video gives a quick demo of the LAG and LEAD analytic functions.

There is more information about these and other analytic functions in the following articles.

The star of today’s video is Gwen (Chen) Shapira of Kafka fame!

Cheers

Tim…

Video : Ranking using RANK, DENSE_RANK and ROW_NUMBER : Problem Solving using Analytic Functions

Today’s video is a run through ranking data using the RANK, DENSE_RANK and ROW_NUMBER analytic functions.

There is more information about these and other analytic functions in the following articles.

The star of today’s video is Chris Saxon, who is one of the folks keeping the masses up to speed at AskTom.

Cheers

Tim…

Video : Multitenant : PDB Snapshot Carousel in Oracle Database 18c Onward

In today’s video we take a look at the PDB Snapshot Carousel feature, introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of today’s video is Nassyam Basha. 🙂

Cheers

Tim…

Video : Multitenant : Proxy PDB in Oracle Database 12.2 Onward

In today’s video we demonstrate the Proxy PDB feature, introduced in Oracle database 12.2.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of this video is Anton Els of Dbvisit fame. I recorded this video last week and picked Anton for the “.com”, then they go and release Dbvisit Standby 9. Coincidence or conspiracy? 🙂

Cheers

Tim…

PS. Mike, I’ve downloaded version 9 and I’m going to give it a run through… 🙂

Video : Multitenant : Refreshable PDB Switchover in Oracle Database 18c Onward

Today’s video is a run through the Refreshable PDB Switchover feature introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

If you prefer reading over watching a video, you can find all the information and more here.

The star of today’s video is Kamran Agayev A. When he’s not working with Oracle technology and helping people to pass their OCM exam, he’s choking people out at Brazilian Jiu Jitsu. 🙂

Cheers

Tim…

Video : Multitenant : PDB Refresh in Oracle Database 12.2 Onward

Today’s video demonstrates the PDB refresh functionality introduced in Oracle database 12.2.

If you prefer to read rather than watch, you can get all the information from this video from here.

The star of today’s video is Markus Michalewicz. He’s so serious in this clip it makes me laugh. 🙂

Cheers

Tim…

Video : Multitenant : PDB Archive Files in Oracle Database 12.2 Onward

Today’s video is a run through the PDB Archive File functionality introduced in Oracle 12.2.

If you prefer your content in text form, this video is based on the articles here.

The star of today’s video is Maris Elsins. 🙂

Cheers

Tim…