Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Существенно увеличивается Gets per Exec  [new]
Oerr
Member

Откуда: Сургут
Сообщений: 774
HI!
Уважаемые, обратите внимание на то что в отчете SP увеличивается Gets per Exec:
                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
     60,401,604          576      104,863.9   98.3  1494.61   1583.62   50787372
UPDATE QUIK_SD SET QSD_STATUS=:b1 WHERE QSD_SYS = :b2  AND QSD_S
TATUS NOT IN ( 'OK','REP','DEL','WLD'  ) RETURNING QSD_STATUS,QS
D_ERROR_TEXT,QSD_TR_CLIENT  INTO :b1,:b2,:b3

  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
      7,131,130           41      173,930.0  108.1   224.34    228.95   50787372
UPDATE QUIK_SD SET QSD_STATUS=:b1 WHERE QSD_SYS = :b2  AND QSD_S
TATUS NOT IN ( 'OK','REP','DEL','WLD'  ) RETURNING QSD_STATUS,QS
D_ERROR_TEXT,QSD_TR_CLIENT  INTO :b1,:b2,:b3

  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
     38,012,171           54      703,929.1   98.3   922.18    953.73   50787372
UPDATE QUIK_SD SET QSD_STATUS=:b1 WHERE QSD_SYS = :b2  AND QSD_S
TATUS NOT IN ( 'OK','REP','DEL','WLD'  ) RETURNING QSD_STATUS,QS
D_ERROR_TEXT,QSD_TR_CLIENT  INTO :b1,:b2,:b3

  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
     41,630,252           85      489,767.7  101.6  1027.86   1045.60   50787372
UPDATE QUIK_SD SET QSD_STATUS=:b1 WHERE QSD_SYS = :b2  AND QSD_S
TATUS NOT IN ( 'OK','REP','DEL','WLD'  ) RETURNING QSD_STATUS,QS
D_ERROR_TEXT,QSD_TR_CLIENT  INTO :b1,:b2,:b3

  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
     15,307,143            6    2,551,190.5   85.0   457.26    457.52   50787372
UPDATE QUIK_SD SET QSD_STATUS=:b1 WHERE QSD_SYS = :b2  AND QSD_S
TATUS NOT IN ( 'OK','REP','DEL','WLD'  ) RETURNING QSD_STATUS,QS
D_ERROR_TEXT,QSD_TR_CLIENT  INTO :b1,:b2,:b3
План:
sys@world|SQL>SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY)
  2  ;

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------
| Id  | Operation                    |  Name       | Rows  | Bytes | Cost (%CPU)|
---------------------------------------------------------------------------------
|   0 | UPDATE STATEMENT             |             |     1 |    13 |     4  (25)|
|   1 |  UPDATE                      | QUIK_SD     |       |       |            |
|*  2 |   TABLE ACCESS BY INDEX ROWID| QUIK_SD     |     1 |    13 |     4  (25)|
|*  3 |    INDEX UNIQUE SCAN         | PK_QSD      |   251K|       |     3  (34)|
---------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("QUIK_SD"."QSD_STATUS"<>'OK' AND "QUIK_SD"."QSD_STATUS"<>'REP' AND
              "QUIK_SD"."QSD_STATUS"<>'DEL' AND "QUIK_SD"."QSD_STATUS"<>'WLD')
   3 - access("QUIK_SD"."QSD_SYS"=TO_NUMBER(:Z))

16 rows selected.

Как можно объяснить?
Картинка с другого сайта.
http://surgutnet.ru
28 ноя 06, 10:38    [3459610]     Ответить | Цитировать Сообщить модератору
 Re: Существенно увеличивается Gets per Exec  [new]
Oerr
Member

Откуда: Сургут
Сообщений: 774
Упс... забыл.
sys@world|SQL>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

Картинка с другого сайта.
http://surgutnet.ru
28 ноя 06, 10:42    [3459636]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить