Scripts:显示数据库中的控制文件dba_controlfiles.sql
来源:互联网 发布:公务员可以开淘宝店吗 编辑:程序博客网 时间:2024/05/17 09:09
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_controlfiles.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Query all control files from the database. |
-- | 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(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Control Files |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 256
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 a85 HEADING "Controlfile Name"
COLUMN status HEADING "Status"
SELECT
name
, LPAD(status, 7) status
FROM v$controlfile
ORDER BY name
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_controlfiles.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Query all control files from the database. |
-- | 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(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Control Files |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 256
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 a85 HEADING "Controlfile Name"
COLUMN status HEADING "Status"
SELECT
name
, LPAD(status, 7) status
FROM v$controlfile
ORDER BY name
/
0 0
- Scripts:显示数据库中的控制文件dba_controlfiles.sql
- Scripts:显示数据库中闪回区文件的信息fra_files.sql
- Scripts:报告数据库中数据文件控制文件临时文件redo文件的使用情况dba_file_use.sql
- Scripts:查看数据库中的job dba_jobs.sql
- Scripts:查询控制文件的信息dba_controlfile_records.sql
- Scripts:显示闪回数据库状态的脚本fdb_status.sql
- Scripts:显示数据库中闪回区的相关信息 fra_status.sql
- Scripts:显示数据库所有锁的脚本locks_blocking.sql
- Scripts:显示数据库中DML锁的脚本 locks_dml_lock_time.sql
- Scripts:查看数据库中的报错dba_errors.sql
- Scripts:查询数据库中的无效对象dba_invalid_objects.sql
- Scripts:报告数据库中的top segment的脚本dba_top_segments.sql
- Scripts:显示数据库中长时间运行的SQL的脚本longtime.sql
- Scripts:显示数据库中锁和等待锁的脚本 locks_blocking2.sql
- Scripts:显示数据库中DML,DDL锁的脚本locks_dml_ddl.sql
- Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
- Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
- Scripts:显示数据库中长时间运行的操作的脚本longops.sql
- 保存 XML
- 数字数码管-解题思路及过程
- [JSP][JSTL]页面中调用函数--之${fn:}内置函数、判断字符串是否为空、替换回车符
- NSButton And NSTextField
- hdu-4747-Mex-线段树区域更新
- Scripts:显示数据库中的控制文件dba_controlfiles.sql
- ACM-MST(最小生成树)之Agri-Net——poj1258
- ibatis like查询防sql注入
- 每日算法之十九:Valid Parentheses
- Longest Substring Without Repeating Characters
- iOS中block类型大全
- 01.ViewPager使用Demo
- 2014任重道远的SEO行程
- iOS键盘设置相关