Ai
1 Star 1 Fork 0

冯际成/Oracle_SQL_Scripts

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
rman_block_change_bct.sql 1.17 KB
一键复制 编辑 原始数据 按行查看 历史
Abdul mohammed 提交于 2016-02-06 08:58 +08:00 . Fri Feb 5 18:58:16 CST 2016
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;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/sapall/Oracle_SQL_Scripts.git
git@gitee.com:sapall/Oracle_SQL_Scripts.git
sapall
Oracle_SQL_Scripts
Oracle_SQL_Scripts
master

搜索帮助