Oracle统计信息自动收集任务检查与调整
Oracle统计信息自动收集任务检查与调整
表统计信息收集情况检查
检查表的统计信息收集情况:
set lines 300
col owner for a30
col table_name for a30
col partition_name for a40
col partitioned for a20
col temporary for a20
col stattype_locked for a20
col stale_stats for a20
col table_owner for a30
-- WHETHER TEMPORARY OR PARTITIONED TABLE
select owner,table_name,partitioned
原文地址:https://blog.csdn.net/Sebastien23/article/details/140412807
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!