代码拉取完成,页面将自动刷新
col filename format a50
select status, bytes/1024/1024 "SIZE_MB", filename from v$block_change_tracking;
Prompt
prompt +---------------------------------------+
prompt | % read for backup where incremntal > 0|
Prompt +---------------------------------------+
prompt
select file#,
avg(datafile_blocks),
avg(blocks_read),
avg(blocks_read/datafile_blocks) * 100 as "% read for backup"
from v$backup_datafile
where incremental_level > 0
and used_change_tracking = 'YES'
group by file#
order by file#;
Prompt
prompt +------------------------------------+
prompt | Enter a datafile number to check if|
prompt | BCTF was used and other info |
Prompt +------------------------------------+
prompt
col bct_use format a10
select completion_time,file#, datafile_blocks, blocks_read, blocks blocked_backed, INCREMENTAL_LEVEL,
used_change_tracking "BCT_USE", blocks_read READ,
round((blocks_read/datafile_blocks) * 100,2) "%READ",
blocks WRTN, round((blocks/datafile_blocks)*100,2) "%WRTN"
from v$backup_datafile
where file#='&file_numb' order by 1;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。