Scripts:查询数据库对象汇总dba_object_summary.sql
来源:互联网 发布:人工智能的弊端作文 编辑:程序博客网 时间:2024/06/01 23:06
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_object_summary.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Provide a summary report of all objects in 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 : Object Summary |
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 owner FORMAT A20 HEADING "Owner"
COLUMN object_type FORMAT A25 HEADING "Object Type"
COLUMN obj_count FORMAT 999,999,999,999 HEADING "Object Count"
BREAK ON report ON owner SKIP 2
COMPUTE sum LABEL "" OF obj_count ON owner
COMPUTE sum LABEL "Grand Total: " OF obj_count ON report
SELECT
owner
, object_type
, count(*) obj_count
FROM
dba_objects
GROUP BY
owner
, object_type
ORDER BY
owner
, object_type
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_object_summary.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Provide a summary report of all objects in 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 : Object Summary |
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 owner FORMAT A20 HEADING "Owner"
COLUMN object_type FORMAT A25 HEADING "Object Type"
COLUMN obj_count FORMAT 999,999,999,999 HEADING "Object Count"
BREAK ON report ON owner SKIP 2
COMPUTE sum LABEL "" OF obj_count ON owner
COMPUTE sum LABEL "Grand Total: " OF obj_count ON report
SELECT
owner
, object_type
, count(*) obj_count
FROM
dba_objects
GROUP BY
owner
, object_type
ORDER BY
owner
, object_type
/
0 0
- Scripts:查询数据库对象汇总dba_object_summary.sql
- Scripts:查询数据库中表空间的情况汇总dba_tablespaces.sql
- Scripts:查询数据库中的无效对象dba_invalid_objects.sql
- Scripts:报告无效对象汇总dba_invalid_objects_summary.sql
- Scripts:查询数据库中各个表空间信息汇总dba_tablespace_to_owner.sql
- Scripts:报告数据库中对应对象用户表空间的段情况汇总dba_owner_to_tablespace.sql
- Scripts:报告数据库中段使用情况的汇总dba_segment_summary.sql
- Scripts:报告数据库中表信息汇总dba_table_info.sql
- EBS查询sql scripts
- Scripts:查询没有统计信息的对象perf_objects_without_statistics.sql
- Scripts:查询数据库中所有的表dba_tables_all.sql
- SQL语句查询数据库对象
- Scripts:报告数据库中所有已注册组件的汇总dba_registry.sql
- 各种数据库分页查询Sql汇总
- Scripts:查看数据库中的job dba_jobs.sql
- Scripts:数据库升级诊断脚本dbupgdiag.sql
- PL/SQL查询oracle数据库对象
- SQL数据库大量数据查询优化思考点汇总
- 理解 Node.js process.nextTick() {Understanding process.nextTick()}
- How Many Tables
- 解读ClassLoader
- android开发记录
- su和su -命令的区别
- Scripts:查询数据库对象汇总dba_object_summary.sql
- Android EditText的设置
- C++误区——直接初始化和复制初始化
- unity网格通信2--聊天
- Red5边源服务器集群部署
- 及其容易出错题总结 --关于继承组合接口等等
- 一个简单有效的用鼠标选中物品并拖动物品的方法
- Scripts:报告已安装的数据库选项(在升级数据库时需要用到)dba_options.sql
- TCP源码分析--tcp_write_xmit