How To Deactivate Segment Advisor

I have a database that is historic and there are some advisors that have active does not interest me, so I’ll stop SEGMENT ADVISOR to not load the system. A simple and fast way from a session with privileges is as follows;

ORCL*ANTO> SELECT client_name, status FROM dba_autotask_client;                                                                               
                                                                                                    
CLIENT_NAME                                                      STATUS                             
________________________________________________________________ ________                           
auto optimizer stats collection                                  ENABLED                            
auto space advisor                                               ENABLED                            
sql tuning advisor                                               ENABLED                            
                                                                                                    
Transcurrido: 00:00:01.40                                                                           
ORCL*ANTO>  EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name=>'auto space advisor', operation=>NULL, window_name=>NULL);                                                                                   
                                                                                                    
Procedimiento PL/SQL terminado correctamente.                                                       
                                                                                                    
Transcurrido: 00:00:00.07                                                                           
ORCL*ANTO>  SELECT client_name, status FROM dba_autotask_client;                                    
                                                                                                    
CLIENT_NAME                                                      STATUS                             
________________________________________________________________ ________                           
auto optimizer stats collection                                  ENABLED                            
auto space advisor                                               DISABLED                           
sql tuning advisor                                               ENABLED                            

HHT – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s