Re: peeking into global temporary table from other session and some tunning

From: GG <grzegorzof@xxxxxxxxxx>
To: xt.and.r@xxxxxxxxx
Date: Fri, 24 Nov 2017 19:35:01 +0100

W dniu 2017-11-24 o 18:29, Sayan Malakshinov pisze:

Hi,

> especially the result of dynamic sampling level 2 (default) on gtt involved in joins

Have you deleted table statistics of this gtt?

There is no statistics there , only dynamic_sampling 2 takes place .

G

Follow-Ups:
- Re: peeking into global temporary table from other session and some tunning
  - From: Sayan Malakshinov

References:
- SQL Tuning Tool
  - From: dba oracle
- Re: SQL Tuning Tool
  - From: Karl Arao
- peeking into global temporary table from other session and some tunning
  - From: GG
- Re: peeking into global temporary table from other session and some tunning
  - From: Mladen Gogala
- Re: peeking into global temporary table from other session and some tunning
  - From: Sayan Malakshinov

Other related posts:

» peeking into global temporary table from other session and some tunning- GG
» Re: peeking into global temporary table from other session and some tunning- Mladen Gogala
» Re: peeking into global temporary table from other session and some tunning- Sayan Malakshinov
» Re: peeking into global temporary table from other session and some tunning - GG
» Re: peeking into global temporary table from other session and some tunning- Sayan Malakshinov
» Re: peeking into global temporary table from other session and some tunning- Andy Sayer