Slide 65
Slide 65 text
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
非同期I/Oのデータ読込み性能の確認(1)
Query V$BACKUP_ASYNC_IO / GV$BACKUP_ASYNC_IO
65
SQL> set linesize 300 pagesize 500
col TYPE for a9
col STATUS for a12
col FILENAME for a65
col TOTAL_MB for 999,999,999
alter session set NLS_DATE_FORMAT='MM/DD HH24:MI:SS';
select INST_ID, USE_COUNT, OPEN_TIME, CLOSE_TIME, SID, TYPE, STATUS,
BUFFER_SIZE, BUFFER_COUNT,
ELAPSED_TIME/100 "ELPD(SEC)",
TOTAL_BYTES/1024/1024 "TOTAL_MB", EFFECTIVE_BYTES_PER_SECOND,
IO_COUNT, READY, SHORT_WAITS, LONG_WAITS,
FILENAME
from GV$BACKUP_ASYNC_IO
where OPEN_TIME > to_date('11/27 13:00:00') -- Backup開始日時を指定すると便利
order by INST_ID, USE_COUNT, TYPE ;