Video : Adaptive Cursor Sharing

In today’s video we’ll discuss the Adaptive Cursor Sharing feature, introduced in Oracle 11g Release 1.

This video is based on the following article.

Here are some other things you might want to check out.

The star of todays video is Franck Pachot, who is clearly looking for an exit. πŸ™‚

Cheers

Tim…

Video : CURSOR_SHARING : Automatically Convert Literals to Bind Variables in SQL Statements

In today’s video we’ll discuss the CURSOR_SHARING parameter, which determines how the database handles statements containing literal values.

The video is based on this article.

You may also find these useful.

The star of today’s video is Toon Koppelaars from the Real World Performance Group at Oracle, and of #SmartDB fame. πŸ™‚

Cheers

Tim…

PS. I’ve already noticed I say “after login”, when I mean “after logon”. πŸ™‚

Video : Bind Variables : For Performance and Protection Against SQL Injection

In today’s video we’ll discuss how using bind variables in your database applications can improve performance, and protect against SQL injection attacks.

This videos is based on a demo I do in one of my presentations, which was itself based on these articles.

The star of today’s video is Bjoern Rost, of asymmetric man thong fame. In his past life, Bjoern was one of the many people who got me through a speaking tour in one piece. πŸ™‚

Cheers

Tim…

Video : Oracle REST Data Services (ORDS) : HTTP Headers and ORDS-Specific Bind Variables

In today’s video we do a quick run through how to use HTTP headers and ORDS-specific bind variables in Oracle REST Data Services.

The video is based on this article.

As always you can see all my ORDS articles here.

There is also a YouTube playlist just for ORDS here.

The star of today’s video is Mark Rittman, who is one of the OGs of the community, and clearly ecstatic at being on video. πŸ™‚

Cheers

Tim…