Scripts:显示数据库中闪回区文件的信息fra_files.sql
来源:互联网 发布:ubuntu find 文件夹 编辑:程序博客网 时间:2024/05/17 17:57
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fra_files.sql |
-- | CLASS : Flash Recovery Area |
-- | PURPOSE : Provide a list of all files in the Flash Recovery Area. |
-- | 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 : FRA 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 name FORMAT a80 HEADING 'File Name'
COLUMN member FORMAT a80 HEADING 'File Name'
COLUMN handle FORMAT a80 HEADING 'File Name'
COLUMN bytes FORMAT 999,999,999,999,999 HEADING 'File Size (Bytes)'
SELECT name, (blocks*block_size) bytes
FROM v$datafile_copy
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT name, null
FROM v$controlfile
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT member, null
FROM v$logfile
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT handle, bytes
FROM v$backup_piece
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT name, (blocks*block_size) bytes
FROM v$archived_log
WHERE is_recovery_dest_file = 'YES'
ORDER BY
1
, 2
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : fra_files.sql |
-- | CLASS : Flash Recovery Area |
-- | PURPOSE : Provide a list of all files in the Flash Recovery Area. |
-- | 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 : FRA 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 name FORMAT a80 HEADING 'File Name'
COLUMN member FORMAT a80 HEADING 'File Name'
COLUMN handle FORMAT a80 HEADING 'File Name'
COLUMN bytes FORMAT 999,999,999,999,999 HEADING 'File Size (Bytes)'
SELECT name, (blocks*block_size) bytes
FROM v$datafile_copy
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT name, null
FROM v$controlfile
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT member, null
FROM v$logfile
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT handle, bytes
FROM v$backup_piece
WHERE is_recovery_dest_file = 'YES'
UNION
SELECT name, (blocks*block_size) bytes
FROM v$archived_log
WHERE is_recovery_dest_file = 'YES'
ORDER BY
1
, 2
/
0 0
- Scripts:显示数据库中闪回区文件的信息fra_files.sql
- Scripts:显示数据库中闪回区的相关信息 fra_status.sql
- Scripts:显示数据库中的控制文件dba_controlfiles.sql
- Scripts:显示闪回区告警的信息fra_alerts.sql
- Scripts:查询控制文件的信息dba_controlfile_records.sql
- Scripts:显示闪回数据库状态的脚本fdb_status.sql
- Scripts:显示数据库所有锁的脚本locks_blocking.sql
- Scripts:显示数据库中DML锁的脚本 locks_dml_lock_time.sql
- Scripts:查询数据库中参数文件的信息(在重新建库或者克隆数据库时经常使用)dba_cr_init.sql
- Scripts:显示数据库中长时间运行的SQL的脚本longtime.sql
- Scripts:自动检查数据库里面的陈旧的统计信息check_stale_stats.sql
- Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
- Scripts:显示数据库中长时间运行的操作的脚本longops.sql
- Scripts:报告数据库中表信息汇总dba_table_info.sql
- Scripts:显示数据库中锁和等待锁的脚本 locks_blocking2.sql
- Scripts:显示数据库中DML,DDL锁的脚本locks_dml_ddl.sql
- Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
- Scripts:报告数据库中数据文件控制文件临时文件redo文件的使用情况dba_file_use.sql
- Square Coins
- Java Swing界面编程(10)---GridLayout布局管理器
- 《逆转未来》
- Scripts:显示数据库中闪回区的相关信息 fra_status.sql
- 软件架构学习之入门
- Scripts:显示数据库中闪回区文件的信息fra_files.sql
- 《编程之美-读书笔记》-1 中国象棋将帅问题
- 实现 组件-实体-系统
- linux 环境变量配置文件
- oracle commit 做了什么?
- 十四周项目二平面面积OJ版
- [Bzoj1008][HNOI2008]越狱
- Scripts:显示闪回区告警的信息fra_alerts.sql
- 客户端与服务端连接分析(一)