Oracle统计信息查看表及重新收集表

1、查看数据库是否为自动开启统计信息
1）查看语句
select client_name,status from dba_autotask_client;
CLIENT_NAME STATUS

---

auto optimizer stats collection DISABLED
auto space advisor DISABLED
sql tuning advisor DISABLED
2）开启方法：
BEGIN
DBMS_AUTO_TASK_ADMIN.ENABLE(
client_name => ‘auto optimizer stats collection’,
operation => NULL,
window_name => NULL);
END;
/
3）关闭方法：
BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => ‘auto optimizer stats collection’,
operation => NULL,
window_name => NULL);
END;
/
2、查看所需统计的表的大小：
col segment_name for a30;
set lines 9999;
set pages 999;
col segment_name for a30
col owner for a20
col tablespace_name for a40
select segment_name,owner,tablespace_name,round(sum(bytes/1024/1024/1024),2) as SIZE_GB from dba_segmen