Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 ora 3113 - трейс не могу понять  [new]
Natalka
Member

Откуда: Far Far Away
Сообщений: 2632
два запроса, выполняю на сервере через sqlplus, один выпоняется, другой вызывает Ora-3113,
в алерт лог пусто, сделала трассировку сессии, не могу разобраться((
если смотреть тексты запросов, то второй- это первый без трех условий во where
помогите разобраться плиз
//начало файла пропускаю
SELECT DISTINCT LAB_ASSISTANT_ASLB ID_EMPLOYEE, CONTRACTOR.NAME_SHORT FIO FROM MR_DBA.ASSAY_ASSA ASSAY_ASSA, MR_DBA.ASSAY_LAB_ASLB ASLB, MR_DBA.CONTRACTOR CONTRACTOR,  MR_DBA.OUR_EMPLOYEE OUR_EMPLOYEE, MR_DBA.OUR_DIVISION  WHERE (CONTRACTOR.ID_CONTRACTOR = LAB_ASSISTANT_ASLB) AND (ASSAY_ASSA.ID_ASSAY_ASSA = ASLB.ID_ASSAY_ASLB)  AND (OUR_EMPLOYEE.ID_CONTRACTOR = CONTRACTOR.ID_CONTRACTOR)  AND (OUR_DIVISION.ID_CONTRACTOR = OUR_EMPLOYEE.OUR_DIV_ID_CONTRACTOR)  AND (OUR_DIVISION.KIND_DIVISION = 'МНЛ')
 and (ID_ASSAY_ASSA in ( select ID_ASSAY_ASSA
 from MR_DBA.ASSAY_ASSA,
 MR_DBA.POINT_OBSERV_POAA
 where (ID_POINT_OBSERV_ASSA = ID_POINT_OBSERV_POAA)
 and (ID_OBJECT_WORK_POAA in (183))
)) and (ID_ASSAY_ASSA in ( select ID_ASSAY_ASSA
 from MR_DBA.ASSAY_ASSA,
 MR_DBA.POINT_OBSERV_POAA
 where (ID_POINT_OBSERV_ASSA = ID_POINT_OBSERV_POAA)
 and (ID_GROUND_POAA in (314))
)) and (ID_ASSAY_ASSA in ( select ID_ASSAY_ASSA
 from MR_DBA.ASSAY_ASSA,
 MR_DBA.POINT_OBSERV_POAA
 where (ID_POINT_OBSERV_ASSA = ID_POINT_OBSERV_POAA)
 and (ID_LINE_COMMON_POAA in (77442))
)) and (ID_POINT_OBSERV_ASSA in (45238))
 ORDER BY CONTRACTOR.NAME_SHORT

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       1.50          0          0          8           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          5          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       1.50          0          5          8           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  SORT UNIQUE 
      0   NESTED LOOPS  
      0    NESTED LOOPS  
      0     NESTED LOOPS  
      0      NESTED LOOPS  
      0       NESTED LOOPS  
      0        NESTED LOOPS  
      0         HASH JOIN  
      8          TABLE ACCESS BY INDEX ROWID ASSAY_ASSA 
      8           INDEX RANGE SCAN XIF1541ASSAY_ASSA (object id 33594)
      0          HASH JOIN  
      0           NESTED LOOPS  
      0            NESTED LOOPS  
      0             TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0              INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0             TABLE ACCESS BY INDEX ROWID OUR_EMPLOYEE 
      0              INDEX RANGE SCAN XIF1367OUR_EMPLOYEE (object id 34432)
      0            TABLE ACCESS BY INDEX ROWID CONTRACTOR 
      0             INDEX UNIQUE SCAN P_KEY__CONTRACTOR__ (object id 34066)
      0           TABLE ACCESS FULL ASSAY_LAB_ASLB 
      0         TABLE ACCESS BY INDEX ROWID ASSAY_ASSA 
      0          INDEX UNIQUE SCAN XPKASSAY_ASSA (object id 33624)
      0        TABLE ACCESS BY INDEX ROWID ASSAY_ASSA 
      0         INDEX UNIQUE SCAN XPKASSAY_ASSA (object id 33624)
      0       TABLE ACCESS BY INDEX ROWID ASSAY_ASSA 
      0        INDEX UNIQUE SCAN XPKASSAY_ASSA (object id 33624)
      0      TABLE ACCESS BY INDEX ROWID POINT_OBSERV_POAA 
      0       INDEX UNIQUE SCAN XPKPOINT_OBSERV_POAA (object id 34686)
      0     TABLE ACCESS BY INDEX ROWID POINT_OBSERV_POAA 
      0      INDEX UNIQUE SCAN XPKPOINT_OBSERV_POAA (object id 34686)
      0    TABLE ACCESS BY INDEX ROWID POINT_OBSERV_POAA 
      0     INDEX UNIQUE SCAN XPKPOINT_OBSERV_POAA (object id 34686)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       1        0.00          0.00
  SQL*Net message from client                     1       17.59         17.59
********************************************************************************

CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FD9D666C_7BD9D" ("C0" NUMBER(8)
  ,"C1" NUMBER(6),"C2" VARCHAR2(32) ) IN_MEMORY_METADATA 
  CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO 4254951020 ) CACHE


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          1           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.00          0          0          1           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
********************************************************************************

CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FD9D666D_7BD9D" ("C0" NUMBER(8)
  ,"C1" NUMBER(6),"C2" VARCHAR2(32) ) IN_MEMORY_METADATA 
  CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO 4254951021 ) CACHE


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          1           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.00          0          0          1           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
********************************************************************************

CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FD9D666E_7BD9D" ("C0" NUMBER(8)
   ) IN_MEMORY_METADATA CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO 4254951022 ) 
  CACHE


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.01       0.00          0          0          2           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.01       0.00          0          0          2           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
********************************************************************************

31 мар 09, 04:44    [6996053]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Natalka
Member

Откуда: Far Far Away
Сообщений: 2632
продолжение
SELECT DISTINCT LAB_ASSISTANT_ASLB ID_EMPLOYEE, CONTRACTOR.NAME_SHORT FIO FROM MR_DBA.ASSAY_ASSA ASSAY_ASSA, MR_DBA.ASSAY_LAB_ASLB ASLB, MR_DBA.CONTRACTOR CONTRACTOR,  MR_DBA.OUR_EMPLOYEE OUR_EMPLOYEE, MR_DBA.OUR_DIVISION  WHERE (CONTRACTOR.ID_CONTRACTOR = LAB_ASSISTANT_ASLB) AND (ASSAY_ASSA.ID_ASSAY_ASSA = ASLB.ID_ASSAY_ASLB)  AND (OUR_EMPLOYEE.ID_CONTRACTOR = CONTRACTOR.ID_CONTRACTOR)  AND (OUR_DIVISION.ID_CONTRACTOR = OUR_EMPLOYEE.OUR_DIV_ID_CONTRACTOR)  AND (OUR_DIVISION.KIND_DIVISION = 'МНЛ')
 and (ID_ASSAY_ASSA in ( select ID_ASSAY_ASSA
 from MR_DBA.ASSAY_ASSA,
 MR_DBA.POINT_OBSERV_POAA
 where (ID_POINT_OBSERV_ASSA = ID_POINT_OBSERV_POAA)
 and (ID_OBJECT_WORK_POAA in (183))
))
 ORDER BY CONTRACTOR.NAME_SHORT

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.12       0.14          0          0          3           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        1      0.12       0.14          0          0          3           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS
********************************************************************************

INSERT /*+ APPEND BYPASS_RECURSIVE_CHECK */ INTO 
  "SYS"."SYS_TEMP_0FD9D666C_7BD9D" SELECT /*+ NO_EXPAND SEMIJOIN_DRIVER */ 
  "ASLB"."ID_ASSAY_ASLB" "C0","ASLB"."LAB_ASSISTANT_ASLB" "C1",
  "CONTRACTOR"."NAME_SHORT" "C2" FROM "MR_DBA"."ASSAY_LAB_ASLB" "ASLB",
  "MR_DBA"."CONTRACTOR" "CONTRACTOR","MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "ASLB"."LAB_ASSISTANT_ASLB"=
  ANY (SELECT /*+ SEMIJOIN_DRIVER */ "CONTRACTOR"."ID_CONTRACTOR" FROM 
  "MR_DBA"."CONTRACTOR" "CONTRACTOR","MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "OUR_EMPLOYEE"."ID_CONTRACTOR"=
  "CONTRACTOR"."ID_CONTRACTOR" AND "OUR_DIVISION"."ID_CONTRACTOR"=
  "OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND "OUR_DIVISION"."KIND_DIVISION"=
  'МНЛ') AND "ASLB"."LAB_ASSISTANT_ASLB" IS NOT NULL AND 
  "ASLB"."LAB_ASSISTANT_ASLB"=ANY (SELECT /*+ SEMIJOIN_DRIVER */ 
  "OUR_EMPLOYEE"."ID_CONTRACTOR" FROM "MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "OUR_DIVISION"."ID_CONTRACTOR"=
  "OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND "OUR_DIVISION"."KIND_DIVISION"=
  'МНЛ') AND "CONTRACTOR"."ID_CONTRACTOR"="ASLB"."LAB_ASSISTANT_ASLB" AND 
  "OUR_EMPLOYEE"."ID_CONTRACTOR"="ASLB"."LAB_ASSISTANT_ASLB" AND 
  "OUR_EMPLOYEE"."ID_CONTRACTOR"="CONTRACTOR"."ID_CONTRACTOR" AND 
  "OUR_DIVISION"."ID_CONTRACTOR"="OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND 
  "OUR_DIVISION"."KIND_DIVISION"='МНЛ'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      1      0.01       0.00          0          1          1           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.03       0.02          0          1          1           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  LOAD AS SELECT  
      0   HASH JOIN  
      0    HASH JOIN  
      0     MERGE JOIN CARTESIAN 
      0      TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0       INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0      BUFFER SORT 
      0       TABLE ACCESS FULL CONTRACTOR 
      0     TABLE ACCESS FULL OUR_EMPLOYEE 
      0    TABLE ACCESS BY INDEX ROWID ASSAY_LAB_ASLB 
      0     BITMAP CONVERSION TO ROWIDS 
      0      BITMAP AND  
      0       BITMAP MERGE  
      0        BITMAP KEY ITERATION  
      0         NESTED LOOPS  
      0          NESTED LOOPS  
      0           TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0            INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0           TABLE ACCESS BY INDEX ROWID OUR_EMPLOYEE 
      0            INDEX RANGE SCAN XIF1367OUR_EMPLOYEE (object id 34432)
      0          INDEX UNIQUE SCAN P_KEY__CONTRACTOR__ (object id 34066)
      0         BITMAP CONVERSION FROM ROWIDS 
      0          INDEX RANGE SCAN XIF1636ASSAY_LAB_ASLB (object id 33738)
      0       BITMAP MERGE  
      0        BITMAP KEY ITERATION  
      0         TABLE ACCESS BY INDEX ROWID OUR_EMPLOYEE 
      0          NESTED LOOPS  
      0           TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0            INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0           INDEX RANGE SCAN XIF1367OUR_EMPLOYEE (object id 34432)
      0         BITMAP CONVERSION FROM ROWIDS 
      0          INDEX RANGE SCAN XIF1636ASSAY_LAB_ASLB (object id 33738)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  control file sequential read                    4        0.00          0.00
********************************************************************************

INSERT /*+ APPEND BYPASS_RECURSIVE_CHECK */ INTO 
  "SYS"."SYS_TEMP_0FD9D666D_7BD9D" SELECT /*+ NO_EXPAND SEMIJOIN_DRIVER */ 
  "ASLB"."ID_ASSAY_ASLB" "C0","ASLB"."LAB_ASSISTANT_ASLB" "C1",
  "CONTRACTOR"."NAME_SHORT" "C2" FROM "MR_DBA"."ASSAY_LAB_ASLB" "ASLB",
  "MR_DBA"."CONTRACTOR" "CONTRACTOR","MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "ASLB"."LAB_ASSISTANT_ASLB"=
  ANY (SELECT /*+ SEMIJOIN_DRIVER */ "CONTRACTOR"."ID_CONTRACTOR" FROM 
  "MR_DBA"."CONTRACTOR" "CONTRACTOR","MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "OUR_EMPLOYEE"."ID_CONTRACTOR"=
  "CONTRACTOR"."ID_CONTRACTOR" AND "OUR_DIVISION"."ID_CONTRACTOR"=
  "OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND "OUR_DIVISION"."KIND_DIVISION"=
  'МНЛ') AND "ASLB"."LAB_ASSISTANT_ASLB" IS NOT NULL AND 
  "ASLB"."LAB_ASSISTANT_ASLB"=ANY (SELECT /*+ SEMIJOIN_DRIVER */ 
  "OUR_EMPLOYEE"."ID_CONTRACTOR" FROM "MR_DBA"."OUR_EMPLOYEE" "OUR_EMPLOYEE",
  "MR_DBA"."OUR_DIVISION" "OUR_DIVISION" WHERE "OUR_DIVISION"."ID_CONTRACTOR"=
  "OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND "OUR_DIVISION"."KIND_DIVISION"=
  'МНЛ') AND "CONTRACTOR"."ID_CONTRACTOR"="ASLB"."LAB_ASSISTANT_ASLB" AND 
  "OUR_EMPLOYEE"."ID_CONTRACTOR"="ASLB"."LAB_ASSISTANT_ASLB" AND 
  "OUR_EMPLOYEE"."ID_CONTRACTOR"="CONTRACTOR"."ID_CONTRACTOR" AND 
  "OUR_DIVISION"."ID_CONTRACTOR"="OUR_EMPLOYEE"."OUR_DIV_ID_CONTRACTOR" AND 
  "OUR_DIVISION"."KIND_DIVISION"='МНЛ'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      1      0.00       0.00          0          1          1           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.01       0.02          0          1          1           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  LOAD AS SELECT  
      0   HASH JOIN  
      0    HASH JOIN  
      0     MERGE JOIN CARTESIAN 
      0      TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0       INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0      BUFFER SORT 
      0       TABLE ACCESS FULL CONTRACTOR 
      0     TABLE ACCESS FULL OUR_EMPLOYEE 
      0    TABLE ACCESS BY INDEX ROWID ASSAY_LAB_ASLB 
      0     BITMAP CONVERSION TO ROWIDS 
      0      BITMAP AND  
      0       BITMAP MERGE  
      0        BITMAP KEY ITERATION  
      0         NESTED LOOPS  
      0          NESTED LOOPS  
      0           TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0            INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0           TABLE ACCESS BY INDEX ROWID OUR_EMPLOYEE 
      0            INDEX RANGE SCAN XIF1367OUR_EMPLOYEE (object id 34432)
      0          INDEX UNIQUE SCAN P_KEY__CONTRACTOR__ (object id 34066)
      0         BITMAP CONVERSION FROM ROWIDS 
      0          INDEX RANGE SCAN XIF1636ASSAY_LAB_ASLB (object id 33738)
      0       BITMAP MERGE  
      0        BITMAP KEY ITERATION  
      0         TABLE ACCESS BY INDEX ROWID OUR_EMPLOYEE 
      0          NESTED LOOPS  
      0           TABLE ACCESS BY INDEX ROWID OUR_DIVISION 
      0            INDEX RANGE SCAN XIF1428OUR_DIVISION (object id 34426)
      0           INDEX RANGE SCAN XIF1367OUR_EMPLOYEE (object id 34432)
      0         BITMAP CONVERSION FROM ROWIDS 
      0          INDEX RANGE SCAN XIF1636ASSAY_LAB_ASLB (object id 33738)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  control file sequential read                    4        0.00          0.00
********************************************************************************

INSERT /*+ APPEND BYPASS_RECURSIVE_CHECK */ INTO 
  "SYS"."SYS_TEMP_0FD9D666E_7BD9D" SELECT /*+ SEMIJOIN_DRIVER */ 
  "POINT_OBSERV_POAA"."ID_POINT_OBSERV_POAA" "C0" FROM 
  "MR_DBA"."POINT_OBSERV_POAA" "POINT_OBSERV_POAA" WHERE 
  "POINT_OBSERV_POAA"."ID_OBJECT_WORK_POAA"=183


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute      1      0.00       0.00          0         32          3         282
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.01       0.00          0         32          3         282

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  LOAD AS SELECT  
    282   TABLE ACCESS BY INDEX ROWID POINT_OBSERV_POAA 
    282    INDEX RANGE SCAN XIF1460POINT_OBSERV_POAA (object id 34670)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  control file sequential read                    4        0.00          0.00
  direct path write                               1        0.00          0.00



********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        2      0.12       1.65          0          0         11           0
Execute      2      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          5          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        5      0.12       1.65          0          5         11           0

Misses in library cache during parse: 2

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       2        0.00          0.00
  SQL*Net message from client                     2       19.70         37.29


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      111      0.04       0.04          0          0          0           0
Execute    188      0.03       0.55          0         34         18         304
Fetch      152      0.01       0.00          0        315          0          79
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      451      0.09       0.60          0        349         18         383

Misses in library cache during parse: 14

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  control file sequential read                   12        0.00          0.01
  direct path write                               1        0.00          0.00

    3  user  SQL statements in session.
  111  internal SQL statements in session.
  114  SQL statements in session.
********************************************************************************
Trace file: test_ora_2904.trc
Trace file compatibility: 9.02.00
Sort options: default

       1  session in tracefile.
       3  user  SQL statements in trace file.
     111  internal SQL statements in trace file.
     114  SQL statements in trace file.
      25  unique SQL statements in trace file.
    2173  lines in trace file.

почему второй короткий запрос не выполняется? execute=0
и где причина ошибки 3113?
или еще где почитать? плиз
31 мар 09, 04:47    [6996054]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Natalka
Member

Откуда: Far Far Away
Сообщений: 2632
((пжалста, скажите, что делать то..
1 апр 09, 05:39    [7003051]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
pravednik
Member

Откуда: Jacksonville, FL
Сообщений: 16268
Natalka
((пжалста, скажите, что делать то..

алертлог покажите
1 апр 09, 05:58    [7003057]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
pravednik
Member

Откуда: Jacksonville, FL
Сообщений: 16268
pravednik
Natalka
((пжалста, скажите, что делать то..

алертлог покажите

не обращайте внимание
1 апр 09, 06:10    [7003059]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Natalka
Member

Откуда: Far Far Away
Сообщений: 2632
в алерт нет никаких ora-((
я вчера с нуля постаивла тот же оракл и базу восстановила, зря может, но уже не знаю, что делать.. ошибка остается(( на металинке читала-читала, параметры какие можно поменяла, без толку

что еще делать можно? принимаются любые варианты
1 апр 09, 06:22    [7003063]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
star_transformation_enabled=fals
Guest
попробуй.
1 апр 09, 09:02    [7003232]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
kinky cat
Member

Откуда: с дивана23
Сообщений: 1238
мож битый блок ?
1 апр 09, 10:14    [7003527]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Skeeve
Member

Откуда:
Сообщений: 33
Natalka,
А кокая ОС и версия Оракла-то?
1 апр 09, 11:30    [7004269]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Natalka
Member

Откуда: Far Far Away
Сообщений: 2632
star_transformation_enabled=fals,

урааааааааааааа!!!!! работает)) пойду читать.. спасибо большое
2 апр 09, 02:55    [7009067]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
wildwind
Member

Откуда: Москва
Сообщений: 1296
Natalka
два запроса, выполняю на сервере через sqlplus, один выпоняется, другой вызывает Ora-3113, в алерт лог пусто

Но трейс от пользовательского процесса должен же оставаться.
2 апр 09, 11:24    [7010186]     Ответить | Цитировать Сообщить модератору
 Re: ora 3113 - трейс не могу понять  [new]
Timm
Member

Откуда: Moscow, Ё-burg
Сообщений: 3696
Natalka
star_transformation_enabled=fals,

урааааааааааааа!!!!! работает)) пойду читать.. спасибо большое

Это отсюда.
2 апр 09, 13:12    [7011265]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить