Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / Oracle [игнор отключен] [закрыт для гостей] / связать V$open_cursor и V$SQL_PLAN по child_number / 12 сообщений из 12, страница 1 из 1
03.04.2017, 12:12
    #39431930
andreymx
andreymx
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
тиражируются разборы
по 11 штук на запрос и болше
у юзверей все NLS одинаковые


Как посмотреть, какой именно разбор у конкретного юзера?
Можно ли из V$open_cursor узнать child_number или child_address?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 12:50
    #39431954
usolcew
usolcew
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymx,

V$OPEN_CURSOR.CHILD_ADDRESS -> V$SQL.CHILD_ADDRESS
не подходит
?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 12:56
    #39431961
andreymx
andreymx
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
в 11.2 в V$OPEN_CURSOR не вижу CHILD_ADDRESS
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 13:02
    #39431967
AnSi_Sr
AnSi_Sr
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
не совсем понимаю, что требуется (при чем здесь nls)
может быть, вот это: v$sql.sql_id = v$open_cursor.sql_id
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 13:20
    #39431984
AlexFF__|
AlexFF__|
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymx,

Если у тебя 11.2 и v$session уже нет инфы о текущем-предыдущем запросе, то никак.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 15:33
    #39432121
Sayan Malakshinov
Sayan Malakshinov
Модератор форума
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymx,

А причина то какая?
v$sql_shared_cursor что показывает? Можешь этим скриптом посмотреть :
https://github.com/xtender/xt_scripts/blob/master/sql_shared.sql
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 19:44
    #39432312
usolcew
usolcew
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymxв 11.2 в V$OPEN_CURSOR не вижу CHILD_ADDRESS

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
11.2.0.3.SYS@/ORCL1123 SQL> select sql.inst_id, kgllksnm as sid, sql_id, child_number
  2    from x$kgllk open_cu
  3    join gv$sql sql
  4      on kgllksqlid = sql_id
  5     and open_cu.inst_id = sql.inst_id
  6     and kglhdpar != kgllkhdl
  7     and kgllkhdl = child_address
  8  /

   INST_ID        SID SQL_ID        CHILD_NUMBER
---------- ---------- ------------- ------------
         1        190 g6gu1n3x0h1h4            0
...
114 rows selected.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 22:55
    #39432414
andreymx
andreymx
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
xtenderandreymx,

А причина то какая?
v$sql_shared_cursor что показывает? Можешь этим скриптом посмотреть :
https://github.com/xtender/xt_scripts/blob/master/sql_shared.sql
 
CHILD_NUMBERALL_REASONSREASON_NREASON#REASONPARAM#NAMEVAL0BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)1size4x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)2bind_position620BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)3original_oacflg30BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)4original_oacmxl320BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)5upgradeable_new_oacmxl1280BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)1size2x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)2SessionLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)3CursorLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y334Rolling Invalidate Window Exceeded(3)1size2x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y334Rolling Invalidate Window Exceeded(3)2invalidation_window14905362630BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y334Rolling Invalidate Window Exceeded(3)3ksugctm14905846370BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y434Rolling Invalidate Window Exceeded(2)1size0x00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y434Rolling Invalidate Window Exceeded(2)2detailsalready_processed0BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y545NLS Settings(0)1size2x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y545NLS Settings(0)2SessionLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y545NLS Settings(0)3CursorLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y640Bind mismatch(22)1size4x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y640Bind mismatch(22)2bind_position620BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y640Bind mismatch(22)3original_oacflg30BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y640Bind mismatch(22)4original_oacmxl320BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y640Bind mismatch(22)5upgradeable_new_oacmxl1280BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y745NLS Settings(0)1size2x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y745NLS Settings(0)2SessionLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y745NLS Settings(0)3CursorLengthSemantics00BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y840Bind mismatch(22)1size4x40BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y840Bind mismatch(22)2bind_position820BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y840Bind mismatch(22)3original_oacflg30BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y840Bind mismatch(22)4original_oacmxl320BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y840Bind mismatch(22)5upgradeable_new_oacmxl1281BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N134Rolling Invalidate Window Exceeded(2)1size0x01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N134Rolling Invalidate Window Exceeded(2)2detailsalready_processed1BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)1size2x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)2invalidation_window14911124531BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)3ksugctm14911126931BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position681BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg31BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl1281BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl321BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)1size2x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)2SessionLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)3CursorLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)1size2x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)2SessionLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)3CursorLengthSemantics01BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N734Rolling Invalidate Window Exceeded(3)1size2x41BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N734Rolling Invalidate Window Exceeded(3)2invalidation_window14899358881BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N734Rolling Invalidate Window Exceeded(3)3ksugctm14899897502BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)1size4x42BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)2bind_position622BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)3original_oacflg32BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)4original_oacmxl1282BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y140Bind mismatch(22)5upgradeable_new_oacmxl322BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)1size2x42BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)2SessionLengthSemantics02BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y245NLS Settings(0)3CursorLengthSemantics02BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y340Bind mismatch(22)1size4x42BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y340Bind mismatch(22)2bind_position742BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y340Bind mismatch(22)3original_oacflg32BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y340Bind mismatch(22)4original_oacmxl322BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y340Bind mismatch(22)5upgradeable_new_oacmxl1282BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y440Bind mismatch(22)1size4x42BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y440Bind mismatch(22)2bind_position822BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y440Bind mismatch(22)3original_oacflg32BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y440Bind mismatch(22)4original_oacmxl1282BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y440Bind mismatch(22)5upgradeable_new_oacmxl323BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position713BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg33BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl323BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl1283BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)1size4x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)2bind_position623BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)3original_oacflg33BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)4original_oacmxl20003BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)5upgradeable_new_oacmxl1283BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position743BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg33BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl1283BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl323BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)1size2x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)2SessionLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)3CursorLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)1size2x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)2SessionLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N645NLS Settings(0)3CursorLengthSemantics03BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N740Bind mismatch(22)1size4x43BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N740Bind mismatch(22)2bind_position623BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N740Bind mismatch(22)3original_oacflg33BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N740Bind mismatch(22)4original_oacmxl323BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N740Bind mismatch(22)5upgradeable_new_oacmxl1284BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N145NLS Settings(0)1size2x44BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N145NLS Settings(0)2SessionLengthSemantics04BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N145NLS Settings(0)3CursorLengthSemantics04BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)1size2x44BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)2invalidation_window14911198184BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N234Rolling Invalidate Window Exceeded(3)3ksugctm14911948074BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)1size4x44BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)2bind_position624BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)3original_oacflg34BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)4original_oacmxl1284BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)5upgradeable_new_oacmxl325BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x45BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position715BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg35BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl1285BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl325BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)1size4x45BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)2bind_position625BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)3original_oacflg35BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)4original_oacmxl325BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)5upgradeable_new_oacmxl1285BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x45BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics05BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics05BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x45BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position715BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg35BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl325BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl1286BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x46BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position826BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg36BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl326BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl1286BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)1size4x46BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)2bind_position626BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)3original_oacflg36BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)4original_oacmxl1286BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)5upgradeable_new_oacmxl326BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x46BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics06BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics06BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x46BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position716BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg36BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl1286BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl326BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)1size2x46BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)2SessionLengthSemantics06BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N545NLS Settings(0)3CursorLengthSemantics07BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x47BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position827BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg37BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl1287BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl327BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)1size2x47BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)2SessionLengthSemantics07BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)3CursorLengthSemantics07BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)1size4x47BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)2bind_position627BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)3original_oacflg37BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)4original_oacmxl1287BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N340Bind mismatch(22)5upgradeable_new_oacmxl20007BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)1size2x47BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)2invalidation_window14899326007BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)3ksugctm14899336117BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N534Rolling Invalidate Window Exceeded(2)1size0x07BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N534Rolling Invalidate Window Exceeded(2)2detailsalready_processed8BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x48BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position38BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg38BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl1288BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl20008BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)1size2x48BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)2SessionLengthSemantics08BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)3CursorLengthSemantics08BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x48BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics08BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics08BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)1size2x48BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)2invalidation_window14905923208BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N434Rolling Invalidate Window Exceeded(3)3ksugctm14905925649BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y145NLS Settings(0)1size2x49BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y145NLS Settings(0)2SessionLengthSemantics09BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y145NLS Settings(0)3CursorLengthSemantics09BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y240Bind mismatch(22)1size4x49BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y240Bind mismatch(22)2bind_position629BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y240Bind mismatch(22)3original_oacflg39BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y240Bind mismatch(22)4original_oacmxl1289BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y240Bind mismatch(22)5upgradeable_new_oacmxl329BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y345NLS Settings(0)1size2x49BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y345NLS Settings(0)2SessionLengthSemantics09BIND_LENGTH_UPGRADEABLE=N, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=Y345NLS Settings(0)3CursorLengthSemantics010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x410BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position310BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg310BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl200010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl12810BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N245NLS Settings(0)1size2x410BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N245NLS Settings(0)2SessionLengthSemantics010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N245NLS Settings(0)3CursorLengthSemantics010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x410BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics010BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x410BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position7410BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg310BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl3210BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=Y, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl12811BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x411BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position8211BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg311BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl12811BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl200011BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)1size4x411BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)2bind_position7411BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)3original_oacflg311BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)4original_oacmxl12811BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N240Bind mismatch(22)5upgradeable_new_oacmxl3211BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x411BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics011BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)1size4x412BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)2bind_position8212BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)3original_oacflg312BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)4original_oacmxl200012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N140Bind mismatch(22)5upgradeable_new_oacmxl12812BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)1size2x412BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)2SessionLengthSemantics012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N245NLS Settings(0)3CursorLengthSemantics012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)1size2x412BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)2SessionLengthSemantics012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N345NLS Settings(0)3CursorLengthSemantics012BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)1size4x412BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)2bind_position8212BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)3original_oacflg312BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)4original_oacmxl3212BIND_LENGTH_UPGRADEABLE=Y, LANGUAGE_MISMATCH=N, ROLL_INVALID_MISMATCH=N440Bind mismatch(22)5upgradeable_new_oacmxl128
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 23:01
    #39432418
andreymx
andreymx
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
запрос с кучей необязательных параметров
 
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
    SELECT
    SUM(SUMMA) summ, SUM(kol)
    INTO   v_summa,  v_kol
    FROM(
        SELECT /*+ index (pr ind_p) use_nl (spis, pr) */
            pr.KOL   kol,
            pr.SUMMA SUMMA,
            ROWNUM rn,
            pr.BALS_DEBET BALS,
            pr.ID_STR_D  ID_STR,
            pr.BALS_kredit
        FROM 
            (SELECT p_PLAN_FAKT PLAN_FAKT, v_datan datan, v_datak datak, ID
                FROM TABLE(Get_Spis_Integer(p_spis_id_kp)) spis 
                WHERE NVL(p_d_k, 1)=1
                 AND  spis.ID IS NOT NULL
             )spis,
             P_TBL pr
        WHERE pr.DATAN = spis.datan
        AND      pr.DATAK = spis.datak
        AND      (pr.ID_d = spis.ID)
        AND      pr.PLAN_FAKT = spis.PLAN_FAKT
        AND      pr.idvers = p_idvers
        AND      (p_BALS IS NULL         OR (v_bals             IS NOT NULL AND v_bals = pr.BALS_DEBET)--!!!BALS_DEBET
                                     OR (v_spis_bals        IS NOT NULL AND v_spis_bals LIKE '%,' || pr.BALS_DEBET || ',%'))
        AND      (p_BALS_debet  IS NULL OR (v_bals_debet        IS NOT NULL AND v_bals_debet  = pr.BALS_debet )
                                     OR (v_spis_bals_debet  IS NOT NULL AND v_spis_bals_debet  LIKE '%,' || pr.BALS_DEBET  || ',%'))
        AND      (p_BALS_kredit IS NULL OR (v_bals_kredit       IS NOT NULL AND v_bals_kredit = pr.BALS_kredit)
                                     OR (v_spis_bals_kredit IS NOT NULL AND v_spis_bals_kredit LIKE '%,' || pr.BALS_kredit || ',%'))
        AND      (p_priz      IS NULL
                                     OR (v_priz             IS NOT NULL AND v_priz = pr.priz )
                                     OR (v_spis_priz        IS NOT NULL AND v_spis_priz LIKE '%,' || pr.priz  || ',%'))
        AND      (p_not_priz  IS NULL
                                     OR pr.priz IS NULL
                                     OR (v_not_priz         IS NOT NULL AND v_not_priz <> pr.priz )
                                     OR (v_spis_not_priz    IS NOT NULL AND v_spis_not_priz NOT  LIKE '%,' || pr.priz  || ',%'))

        UNION ALL

        SELECT /*+ star ordered  index (pr ind_p_k)*/
            -pr.KOL   kol,
            -pr.SUMMA SUMMA,
            ROWNUM rn,
            pr.BALS_kredit BALS,
            pr.ID_STR_k  ID_STR,
            pr.BALS_kredit
        FROM 
            (SELECT p_PLAN_FAKT PLAN_FAKT, v_datan datan, v_datak datak, ID
                FROM TABLE(Get_Spis_Integer(p_spis_id_kp)) spis 
                WHERE NVL(p_d_k, 2)=2
                 AND  spis.ID IS NOT NULL
             )spis,
             P_TBL pr
        WHERE pr.DATAN = spis.datan
        AND      pr.DATAK = spis.datak
        AND      pr.ID_k = spis.ID
        AND      pr.PLAN_FAKT = spis.PLAN_FAKT
        AND      pr.idvers = p_idvers
        AND      (p_BALS IS NULL     OR (v_bals             IS NOT NULL AND v_bals = pr.BALS_kredit)--!!!BALS_kredit
                                     OR (v_spis_bals        IS NOT NULL AND v_spis_bals LIKE '%,' || pr.BALS_kredit || ',%'))
        AND      (p_BALS_debet  IS NULL OR (v_bals_debet    IS NOT NULL AND v_bals_debet  = pr.BALS_debet )
                                     OR (v_spis_bals_debet  IS NOT NULL AND v_spis_bals_debet  LIKE '%,' || pr.BALS_DEBET  || ',%'))
        AND      (p_BALS_kredit IS NULL OR (v_bals_kredit   IS NOT NULL AND v_bals_kredit = pr.BALS_kredit)
                                     OR (v_spis_bals_kredit IS NOT NULL AND v_spis_bals_kredit LIKE '%,' || pr.BALS_kredit || ',%'))
        AND      (p_priz      IS NULL
                                     OR (v_priz             IS NOT NULL AND v_priz = pr.priz )
                                     OR (v_spis_priz        IS NOT NULL AND v_spis_priz LIKE '%,' || pr.priz  || ',%'))
        AND      (p_not_priz  IS NULL 
                                     OR pr.priz IS NULL
                                     OR (v_not_priz         IS NOT NULL AND v_not_priz <> pr.priz )
                                     OR (v_spis_not_priz    IS NOT NULL AND v_spis_not_priz NOT  LIKE '%,' || pr.priz  || ',%'))

    ) sel,
           N04, N03, N99,
           N01
    WHERE sel.ID_STR=N04.ID_N04(+)
    AND      N04.ID_ST =N03.ID_ST(+)
    AND      (p_st     IS NULL OR N03.ST    = v_st     OR v_spis_st     LIKE '%,' || N03.ST     || ',%')
    AND      (p_str    IS NULL OR N04.STR   = v_str    OR v_spis_str    LIKE '%,' || N04.STR    || ',%')
    AND      (p_pr_st  IS NULL OR N03.pr_ST = v_pr_st  OR v_spis_pr_st  LIKE '%,' || N03.pr_ST  || ',%')
    AND      (p_pr_str IS NULL OR N04.pr_STR= v_pr_str OR v_spis_pr_str LIKE '%,' || N04.pr_STR || ',%')
    AND      N03.ID_RAZ  =N01.ID_RAZ
    AND      N01.VID_RASX=N99.VID_RASX
    AND      sel.bals    =N99.BALS_DEBET
    AND      N99.OSN_SCHET = 1 -- 20-03-2007
    AND      (p_vid_rasx IS NULL OR N01.VID_RASX=v_vid_rasx OR 
                  (v_vid_rasx IS NULL AND p_vid_rasx IS NOT NULL AND Spis_To_Full_Spis(p_vid_rasx) LIKE '%,' || N01.VID_RASX || ',%')
          )
    AND      (p_kst      IS NULL OR N03.kST   = v_kst  OR v_spis_kst     LIKE '%,' || N03.kST     || ',%')
    AND      (p_raz IS NULL OR v_raz = N01.raz OR 
                  (v_raz IS NULL AND p_raz IS NOT NULL AND Spis_To_Full_Spis(p_raz) LIKE '%,' || N01.raz || ',%')
          )
    AND   (    v_Bals_sbyt LIKE '%,'|| TRIM(',' FROM  p_BALS)       ||',%'
            OR v_Bals_sbyt LIKE '%,'|| TRIM(',' FROM  p_BALS_debet) ||',%'
            OR v_Bals_sbyt LIKE '%,'|| TRIM(',' FROM  p_BALS_kredit)||',%'
            OR NVL(sel.ID_STR, 0) <> v_nebalans
           )
    AND      N04.PR_PROV IS NOT NULL

...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
03.04.2017, 23:56
    #39432426
Sayan Malakshinov
Sayan Malakshinov
Модератор форума
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymxзапрос с кучей необязательных параметров
Обрати внимание в своем выводе на oacmxl - это размер буфера для бинда:
 
CHILD#REASON_NSIZEBIND_POSITIONORIGINAL_OACFLGORIGINAL_OACMXLUPGRADEABLE_NEW_OACMXL014x4 62332128084x4 82332128144x4 68312832214x4 62312832234x4 74332128244x4 82312832314x4 71332128324x4 6232000128344x4 74312832374x4 62332128434x4 62312832514x4 71312832524x4 62332128544x4 71332128614x4 82332128624x4 62312832644x4 71312832714x4 82312832734x4 6231282000814x4 331282000924x4 623128321014x4 3320001281044x4 743321281114x4 82312820001124x4 743128321214x4 82320001281244x4 82332128

вот поэтому и не шарит:
http://www.toadworld.com/platforms/oracle/b/weblog/archive/2016/09/26/why-my-execution-plan-has-not-been-shared-part-iii
авторWhen Oracle compile a new execution plan for a parent cursor several information are stored in memory together with the underlying child cursor. This cursor metadata contains, among others, the current optimizer parameters, object statistics, objects identities, the name, the type and the length of the bind variables. The information about the length of the bind variable used during the execution plan compilation is particularly non-innocent. Indeed, anything that breaks the stored bind variable length metadata is going to invalidate the cursor and, thereby, provoke a hard parse of a new execution plan. Within the child cursor metadata Oracle has implemented the following five buffer sizes to store varchar2 bind variable lengths:

a buffer for bind variable with less than 32 characters
a buffer for bind variable with a length between 33 and 128 characters
a buffer for bind variable with a length between 129 and 2000 characters
a buffer for bind variable with a length between 2001 and 4000 characters
a buffer for bind variable with more than 4000 characters
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
04.04.2017, 00:09
    #39432432
andreymx
andreymx
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
размер буфера для бинда - это для всех биндов вообще или для каждого?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
04.04.2017, 00:32
    #39432434
Sayan Malakshinov
Sayan Malakshinov
Модератор форума
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
связать V$open_cursor и V$SQL_PLAN по child_number
andreymx,

для каждого. смотри столбец BIND_POSITION - это и есть номер бинда из запроса
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / Oracle [игнор отключен] [закрыт для гостей] / связать V$open_cursor и V$SQL_PLAN по child_number / 12 сообщений из 12, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение  
Полит. конфиден.  
созд. / загр.: 521ms
Закрыть
start [/forum/topic.php?fid=52&mobile=1&tid=1886170]:
 0ms
get settings:
 9ms
get forum list:
 16ms
check forum access:
 4ms
check topic access:
 4ms
track hit:
 185ms
get topic data:
 10ms
get forum data:
 2ms
get page messages:
 51ms
get tp. blocked users:
 1ms
others: 239ms
total:  521ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]