Peeking on steroids: Adaptive Cursor Sharing

preview_player
Показать описание


Subscribe for new tech videos every week

My current favorite Oracle stuff:

- Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages.

- Favorite 18c feature: Killing a runaway SQL without killing the entire session.

- Favorite 19c feature: Handling JSON just got a lot easier!

Music: Night Owl (Broke For Free)

#oracle #binds #performance
  1. SQL and Database explained!
  2. oracle
  3. oracle database
  4. asktom
  5. office hours
  6. bind variables
Рекомендации по теме
Peeking on steroids: 0:06:23

Peeking on steroids: Adaptive Cursor Sharing

Adaptive Cursor Sharing 0:07:32

Adaptive Cursor Sharing - quirks

Problems with bind 0:05:35

Problems with bind peeking

Adaptive Cursor Sharing 0:05:42

Adaptive Cursor Sharing

A peek at 0:08:27

A peek at bind variable peeking

Cursors 0:08:33

Cursors

New feature of 1:03:05

New feature of Oracle Database 11g: Adaptive Cursor Sharing

Is CURSOR_SHARING broken? 0:08:16

Is CURSOR_SHARING broken?

CURSOR_SHARING : Automatically 0:03:12

CURSOR_SHARING : Automatically Convert Literals to Bind Variables in SQL Statements

12c SQL Performance 0:09:12

12c SQL Performance Features Adaptive Execution Plans

When MORE triggers 0:08:50

When MORE triggers means better performance!

Existing features get 0:07:38

Existing features get better in 19c

Real-World Performance - 0:03:08

Real-World Performance - 1 - Cursors and Connection Intro

Great Connors RSI 0:12:55

Great Connors RSI Short Strategy // Connors CRASH // Stock Secrets

Respiratory Clinical Reasoning 0:29:29

Respiratory Clinical Reasoning

2020-08-27 Emerging MR 1:26:53

2020-08-27 Emerging MR Webinar: Sang Ho Park, Harald Schwalbe, Andreas Schlundt, Boris Fürtig

Short & Long-Term 0:57:37

Short & Long-Term Consequences of Critical Illness | Dr. Senelick | Encompass Health

COVID-19 & Duchenne: 1:06:11

COVID-19 & Duchenne: What you need to know [March 19, 2020]

Let's Plug: iZotope's 0:25:19

Let's Plug: iZotope's VocalSynth!

AC20 - New 1:11:43

AC20 - New Targets for Therapy and Drug Development

'Biobanque québécoise de 1:19:04

'Biobanque québécoise de la COVID-19'

BK Nephropathy 2 0:32:16

BK Nephropathy 2

HCA Biological Networks 1:30:20

HCA Biological Networks Seminar Series: Pediatric Cell Atlas

Securefile Migration ? 0:02:45

Securefile Migration ? No problem!

Комментарии
Автор

Also relation between Adaptive Cursor Sharing & Histograms, Adaptive Cursor Sharing & SQL Plan Management.

jamsher
Автор

It's very useful. Thanks for sharing this knowledge. Waiting for next video in series :)

VishalSharma-xzcx
Автор

@Connor McDonald you mentioned a next video, is that somewhere or still in plans? Will you address cursor merging and I thought to remebr there was some improvement past 12.2 but I cant find it mentioned? was this the adaptive optimizer or the different statistics histograms which improved ACS past 12.1?

berndeckenfels
Автор

Hi Connor. When do you plan to release next video about ACS?

SergiiShcheteniuk
Автор

do you have all the commands in a text file or sql file that we can download, so we can test it ourselves? :) Thanks!

gingzabala
Автор

Hi Connor can you please explain in more details How optimizer is using view V$SQL_CS_SELECTIVITY & V$SQL_CS_HISTOGRAM to switch cursor from Bind Sensitive to Bind Aware.

jamsher