Scripts:显示所有闪回日志的脚本fdb_log_files.sql
来源:互联网 发布:山东中标数据查询 编辑:程序博客网 时间:2024/05/16 10:22
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fdb_log_files.sql |
-- | CLASS : Flashback Database |
-- | PURPOSE : Provide a list of all Flasback log files. |
-- | 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 Log Files |
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 thread# HEADING 'Thread #'
COLUMN sequence# HEADING 'Sequence #'
COLUMN name FORMAT a65 HEADING 'Log File Name'
COLUMN log# HEADING 'Log #'
COLUMN bytes FORMAT 999,999,999,999 HEADING 'Bytes'
COLUMN first_change# HEADING 'First Change #'
COLUMN first_time HEADING 'First Time' JUST RIGHT
BREAK ON thread# SKIP 2
COMPUTE count OF sequence# ON thread#
COMPUTE sum OF bytes ON thread#
SELECT
thread#
, sequence#
, name
, log#
, bytes
, first_change#
, TO_CHAR(first_time, 'DD-MON-YYYY HH24:MI:SS') first_time
FROM
v$flashback_database_logfile
ORDER BY
thread#
, sequence#;
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fdb_log_files.sql |
-- | CLASS : Flashback Database |
-- | PURPOSE : Provide a list of all Flasback log files. |
-- | 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 Log Files |
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 thread# HEADING 'Thread #'
COLUMN sequence# HEADING 'Sequence #'
COLUMN name FORMAT a65 HEADING 'Log File Name'
COLUMN log# HEADING 'Log #'
COLUMN bytes FORMAT 999,999,999,999 HEADING 'Bytes'
COLUMN first_change# HEADING 'First Change #'
COLUMN first_time HEADING 'First Time' JUST RIGHT
BREAK ON thread# SKIP 2
COMPUTE count OF sequence# ON thread#
COMPUTE sum OF bytes ON thread#
SELECT
thread#
, sequence#
, name
, log#
, bytes
, first_change#
, TO_CHAR(first_time, 'DD-MON-YYYY HH24:MI:SS') first_time
FROM
v$flashback_database_logfile
ORDER BY
thread#
, sequence#;
0 0
- Scripts:显示所有闪回日志的脚本fdb_log_files.sql
- Scripts:基于时间显示闪回日志中redo的脚本fdb_redo_time_matrix.sql
- Scripts:显示数据库所有锁的脚本locks_blocking.sql
- Scripts:显示闪回数据库状态的脚本fdb_status.sql
- Scripts:查询所有参数修改信息的脚本parm_mods.sql
- Scripts:报告所有用户session信息的脚本sess_user_sessions.sql
- Scripts:显示AWR中执行计划的脚本dplan_allstats.sql
- Scripts:显示数据库中DML锁的脚本 locks_dml_lock_time.sql
- Scripts:查看回滚的SQL的脚本 huigun.sql
- Scripts:显示数据库中长时间运行的SQL的脚本longtime.sql
- Scripts:列出用户信息的脚本sec_users.sql
- Scripts:显示有LOB列的表的脚本(慎用)LobData.sql
- Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
- Scripts:显示数据库中长时间运行的操作的脚本longops.sql
- Scripts:显示数据库中锁和等待锁的脚本 locks_blocking2.sql
- Scripts:显示数据库中DML,DDL锁的脚本locks_dml_ddl.sql
- Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
- Scripts:重建索引的脚本(看懂脚本再用)rebuild_indx.sql
- Maven 核心概念——坐标
- sqlcommand.parameters.add
- C++内联成员函数练习
- 师兄博士答辩有感
- CreateUserWizard输入密码和设置安全问题
- Scripts:显示所有闪回日志的脚本fdb_log_files.sql
- struts2 自定义result 处理JSON
- C++学习笔记21,对象赋值
- Maven 核心概念——仓库
- android launcher按键事件捕获
- ACM-最短路之畅通工程续——hdu1874
- 编写DLL程序的步骤
- Maven 核心概念——依赖管理
- c2java 回溯之数独