Scripts:查看表的列上的统计信息col_stats.sql
来源:互联网 发布:休闲鞋 知乎 编辑:程序博客网 时间:2024/06/05 00:13
set verify off
set pagesize 999
set lines 165
col table_name format a25 trunc
col column_name format a25
col avg_len format 9999999
col NDV format 999,999,999
col buckets format 999999
col low_value format a15
col high_value format a15
col density for .999999999
col data_type for a10
select column_name, data_type, avg_col_len, density, num_distinct NDV, histogram, num_buckets buckets, sample_size, last_analyzed,
display_raw(low_value,data_type) low_value, display_raw(high_value,data_type) high_value
from dba_tab_cols
where owner like nvl('&owner',owner)
and table_name like nvl('&table_name',table_name)
and column_name like nvl('%&column_name%',column_name)
order by internal_column_id
/
set pagesize 999
set lines 165
col table_name format a25 trunc
col column_name format a25
col avg_len format 9999999
col NDV format 999,999,999
col buckets format 999999
col low_value format a15
col high_value format a15
col density for .999999999
col data_type for a10
select column_name, data_type, avg_col_len, density, num_distinct NDV, histogram, num_buckets buckets, sample_size, last_analyzed,
display_raw(low_value,data_type) low_value, display_raw(high_value,data_type) high_value
from dba_tab_cols
where owner like nvl('&owner',owner)
and table_name like nvl('&table_name',table_name)
and column_name like nvl('%&column_name%',column_name)
order by internal_column_id
/
0 0
- Scripts:查看表的列上的统计信息col_stats.sql
- Scripts:比较表的统计信息diff_table_stats.sql
- Scripts:查询没有统计信息的对象perf_objects_without_statistics.sql
- Scripts:自动检查数据库里面的陈旧的统计信息check_stale_stats.sql
- 查看当前正在运行的SQL语句的统计信息
- 查看表的所有相关列信息
- 查看某表的统计信息
- Trafodion showstats查看表的统计信息
- Scripts:查看回滚的SQL的脚本 huigun.sql
- 查看oracle的统计信息
- Scripts:按日期查询归档信息的SQL check_archive.sql
- Scripts:dump nclob列的脚本(慎用)lob_dump_nclob.sql
- Scripts:查看表空间的语句脚本
- Scripts:显示有LOB列的表的脚本(慎用)LobData.sql
- Scripts:查看未提交的事务的脚本CurrentActivity.sql
- Scripts:查看数据库里面建的directories dba_directories.sql
- sql 查询表的所有列信息
- Scripts:检查ASMM的各个动态组件信息asmm_components.sql
- 泛化(Generalization) 聚合(aggregation)组合(composition)依赖(Dependency)
- 补充:linux下开发时还会经常用到的命令
- Android:adb 启动activity、service,发送broadcast
- 简单的Dialog开发步骤(类ME23N的PO功能)
- 载:java串口编程
- Scripts:查看表的列上的统计信息col_stats.sql
- 闫妮胡歌一吻情深
- 神奇的C语言四:typedef的使用
- Effective C++ Item 22 将成员变量声明为private
- 网络编程(自定义浏览器-Tomcat服务器)
- [C/C++]函数调用栈和栈帧
- 省赛总结
- 黑马程序员—JAVA基础之String、StringBuffer
- Android OBB文件和StorageManager类