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…

Dbvisit Standby 9 Installation on Linux (and Vagrant)

The folks at Dbvisit recently released version 9 of their Dbvisit standby product.

It’s been a while since I last played with the product, so I downloaded the free trial and gave it a whirl.

I have to admit I forgot just how easy it is to work with. It feels pretty much like “unzip and go”. The result of my playtime was this article.

I also knocked up a Vagrant build, so I can easily recreate it. You can find that here.

I stuck to a basic configuration of a single instance primary (node1) and standby (node2), with the console on a separate VM (console). If you want to try something more exotic, or you are using Windows, you can get more information from the Installing Dbvisit Standby documentation.

Cheers

Tim…

PS. This isn’t a sponsored post. I’ve known the folks at Dbvisit for years so I keep an eye on what they are doing.

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…

Oracle ACE Program : How you “align” matters!

Every so often I feel moved to write something about community programs. In the past it has resulted in these posts.

After some Tweets over the weekend I felt the need to write something more.

I’ve said in previous posts that you shouldn’t aim to become an Oracle ACE. If you enjoy what you do, and what you do is already aligned with the current criteria of a community program, like the Oracle ACE Program, then everything will be smooth sailing. You will eventually be nominated, join the program and everything will work out fine. The “judging criteria” will be almost irrelevant as you will have no trouble meeting them. If you aren’t aligned to those specific criteria, your experience will be more problematic. You will struggle to meet the criteria and eventually give up.

The current criteria for the ACE program are almost tailor made for someone like me. The only way I can learn new stuff and improve my understanding of existing stuff is to write. I did this before the Oracle ACE Program existed. I did it before my website existed. It’s just what I do. I almost never type something into a console or command line. I write it in a scratchpad and paste it into the command line. I’ve got literally thousands of lines of instructions, commands and ideas that may or may not end up as articles. The point is, it’s really easy for me because the way I am and the way I work make it easy for me.

For others like me it can be really hard to appreciate how other people react to the judging criteria, because their perspective and way of working can seem so foreign to us. The problem with these discussions is “everybody is correct” from their own perspective. In a Tweet I wrote the following.

” I think we all have different experiences and different motivations for what we do. If this aligns with the goals of the ACE program, then the experience will seem great. If it doesn’t align, it will seem forced and unfair. All opinions are valid.”

I was originally quite defensive, and I wanted to post about all the points made and give my counter arguments, but what’s the point? My opinion is no more or less valid than anyone else’s. ๐Ÿ™‚ If you are interested in what I think, read the posts linked above, because I think I’ve said it all before, but that’s just *my* opinion!

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…

VirtualBox 6.0.8

VirtualBox 6.0.8 was released last night.

The downloads and changelog are in the usual places.

I’ve done this install on my Windows 10 laptop at work. No dramas on either. Iโ€™ll probably do the installations at home on Windows 10, macOS Mojave and Oracle Linux 7 hosts tonight. Iโ€™ll add an update here when I’ve done that.

Some Vagrant builds are running now… ๐Ÿ™‚

Cheers

Timโ€ฆ

Update: Installations on Windows 10, macOS Mojave and Oracle Linux 7 hosts at home went fine. Running through some Vagrant builds now.

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…

Video : Multitenant : Relocate a Pluggable Database (PDB) in Oracle Database 12.2 Onward

Today’s video is a brief run through the PDB relocate functionality, introduced in Oracle 12.2.

As always, this is based on articles with a lot more information, which you can find here.

The star of this video is none other than Martin Bach. ๐Ÿ™‚

Cheers

Tim…