<pre name="code" class="sql">首先:oracle有自动Job,进行shrink space
SQL> select client_name,status from dba_autotask_client;
CLIENT_NAME STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED
SQL> select * from DBA_AUTOTASK_WINDOW_CLIENTS;
WINDOW_NAME WINDOW_NEXT_TIME WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M
------------------------------ ------------------------------ ----- -------- -------- -------- -------- --------
WEDNESDAY_WINDOW 21-5月 -14 10.00.00.000000 下 FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
午 PRC
FRIDAY_WINDOW 2
auto space advisor
最新推荐文章于 2022-05-11 15:14:45 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)