Scripts:基于时间显示闪回日志中redo的脚本fdb_redo_time_matrix.sql
来源:互联网 发布:中国人工智能股票龙头 编辑:程序博客网 时间:2024/05/20 13:16
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fdb_redo_time_matrix.sql |
-- | CLASS : Flashback Database |
-- | PURPOSE : Provide details on the amount of redo data being collected by |
-- | Oracle Flashback Database over given time frames. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(sys_context('USERENV', 'INSTANCE_NAME'), 17) current_instance
FROM dual;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Flashback Database Redo Time Matrix |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN begin_time FORMAT a21 HEADING 'Begin Time'
COLUMN end_time FORMAT a21 HEADING 'End Time'
COLUMN flashback_data FORMAT 9,999,999,999,999 HEADING 'Flashback Data'
COLUMN db_data FORMAT 9,999,999,999,999 HEADING 'DB Data'
COLUMN redo_data FORMAT 9,999,999,999,999 HEADING 'Redo Data'
COLUMN estimated_flashback_size FORMAT 9,999,999,999,999 HEADING 'Estimated|Flashback Size'
SELECT
TO_CHAR(begin_time, 'DD-MON-YYYY HH24:MI:SS') begin_time
, TO_CHAR(end_time, 'DD-MON-YYYY HH24:MI:SS') end_time
, flashback_data
, db_data
, redo_data
, estimated_flashback_size
FROM
v$flashback_database_stat
ORDER BY
begin_time;
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fdb_redo_time_matrix.sql |
-- | CLASS : Flashback Database |
-- | PURPOSE : Provide details on the amount of redo data being collected by |
-- | Oracle Flashback Database over given time frames. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(sys_context('USERENV', 'INSTANCE_NAME'), 17) current_instance
FROM dual;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Flashback Database Redo Time Matrix |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN begin_time FORMAT a21 HEADING 'Begin Time'
COLUMN end_time FORMAT a21 HEADING 'End Time'
COLUMN flashback_data FORMAT 9,999,999,999,999 HEADING 'Flashback Data'
COLUMN db_data FORMAT 9,999,999,999,999 HEADING 'DB Data'
COLUMN redo_data FORMAT 9,999,999,999,999 HEADING 'Redo Data'
COLUMN estimated_flashback_size FORMAT 9,999,999,999,999 HEADING 'Estimated|Flashback Size'
SELECT
TO_CHAR(begin_time, 'DD-MON-YYYY HH24:MI:SS') begin_time
, TO_CHAR(end_time, 'DD-MON-YYYY HH24:MI:SS') end_time
, flashback_data
, db_data
, redo_data
, estimated_flashback_size
FROM
v$flashback_database_stat
ORDER BY
begin_time;
0 0
- Scripts:基于时间显示闪回日志中redo的脚本fdb_redo_time_matrix.sql
- Scripts:显示所有闪回日志的脚本fdb_log_files.sql
- Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
- Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
- Scripts:显示闪回数据库状态的脚本fdb_status.sql
- Scripts:显示AWR中执行计划的脚本dplan_allstats.sql
- Scripts:显示数据库中DML锁的脚本 locks_dml_lock_time.sql
- Scripts:显示数据库中长时间运行的SQL的脚本longtime.sql
- Scripts:显示数据库中长时间运行的操作的脚本longops.sql
- Scripts:显示数据库中锁和等待锁的脚本 locks_blocking2.sql
- Scripts:显示数据库中DML,DDL锁的脚本locks_dml_ddl.sql
- 查找引起redo日志暴增的SQL语句--脚本
- Scripts:显示数据库所有锁的脚本locks_blocking.sql
- Scripts:报告数据库中数据文件控制文件临时文件redo文件的使用情况dba_file_use.sql
- Scripts:查看回滚的SQL的脚本 huigun.sql
- Scripts:计算每天的redo大小awr_redo_nologging_size.sql
- Scripts:列出用户信息的脚本sec_users.sql
- Scripts:显示有LOB列的表的脚本(慎用)LobData.sql
- c2java 回溯之数独
- linux中用户的主目录~
- Hog算法加速的实现代码
- 【大数据】大数据排序或取重或去重相关问题
- 把Win8PE制作成U盘版的万能微型电脑维护系统
- Scripts:基于时间显示闪回日志中redo的脚本fdb_redo_time_matrix.sql
- Maven 核心概念——站点生成和报告
- 从埃及分数看迭代加深搜索
- Scripts:显示闪回数据库状态的脚本fdb_status.sql
- 网址
- linux -- xinput 输入设备管理
- Linux下面开起启动服务命令(chkconfig、ntsysv)
- oracle 分割字符串 截取字符串
- Dozer轻松实现对象间属性复制