Problemas de System I/O (ESTOU DESESPERADO)

[raulcsnetoParticipante]

boa tarde, segue o resultado da operação:

SQL> set autot on exp stat;
SQL> set linesize 9999;
SQL> select (SYSDATE – AU.HRENVIO_PTU)243600 DURACAO, AU.NRAUTORIZACAO, AU.AOMEIO_SOLICITACAO, AU.NOARQUIVO_RESPOSTA, AU.AOAPROVACAO_REMOTA from PRODUCAo.AUTORIZACAO AU, PRODUCAo.CONTROLE_INTERCAMBIO_ONLINE C where AU.NRAUTORIZACAO(+) = C.NRAUTORIZACAO and AU.CDSITUACAO = ‘AB’ and AU.HRENVIO_PTU is not null and AU.HRRESPOSTA_PTU is null and AU.CDMOTIVO_CANCELAMENTO is null and C.NRAUTORIZACAO > 1 order by AU.NRAUTORIZACAO ;

DURACAO NRAUTORIZACAO A NOARQUIVO_RESPOSTA A

---

    60      12883786 A \10.0.12.100localposretorno32451983.1in                                                                                          S

Execution Plan

Plan hash value: 2430761173

---

| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |

| 0 | SELECT STATEMENT | | 161K| 9320K| | 185K (3)| 00:04:07 |
| 1 | SORT ORDER BY | | 161K| 9320K| 21M| 185K (3)| 00:04:07 |
| 2 | NESTED LOOPS | | 161K| 9320K| | 183K (3)| 00:04:03 |
|* 3 | TABLE ACCESS FULL| AUTORIZACAO | 309K| 15M| | 183K (3)| 00:04:03 |

|* 4 | INDEX UNIQUE SCAN| PK_CONTROLE_INTERCAMBIO_ONLINE | 1 | 5 | | 0 (0)| 00:00:01 |

Predicate Information (identified by operation id):

3 – filter(“AU”.”HRENVIO_PTU” IS NOT NULL AND “AU”.”CDSITUACAO”=’AB’ AND “AU”
NULL AND “AU”.”CDMOTIVO_CANCELAMENTO” IS NULL AND “AU”.”NRAUTORIZA
4 – access(“AU”.”NRAUTORIZACAO”=”C”.”NRAUTORIZACAO”)
filter(“C”.”NRAUTORIZACAO”>1)

Statistics

    431  recursive calls
      1  db block gets
 477934  consistent gets
 127996  physical reads
    144  redo size
    886  bytes sent via SQL*Net to client
    492  bytes received via SQL*Net from client
      2  SQL*Net roundtrips to/from client
     20  sorts (memory)
      0  sorts (disk)
      1  rows processed

SQL>