第23次：2014-08-12-1.sql

botang

1. select * from dba_sql_profiles;
   
2. 
   
3. begin
   
4.    dbms_advisor.quick_tune(
   
5.    advisor_name => 'SQL Access Advisor',
   
6.    task_name => 'MYQUICK1',attr1 => 'select count(*)  from hr.tbig  group by type',template => 'SQLACCESS_WAREHOUSE') ;
   
7.   end;
   
8.   
   
9.   begin
   
10.      dbms_Stats.gather_table_stats('HR','TBIG');
    
11.   end;
    
12.   
    
13.   begin
    
14.    dbms_advisor.quick_tune(
    
15.    advisor_name => 'SQL Access Advisor',
    
16.    task_name => 'MYQUICK2',attr1 => 'select count(*)  from hr.tbig  group by type',template => 'SQLACCESS_WAREHOUSE') ;
    
17.   end;
    
18.   
    
19.   
    
20.     begin
    
21.    dbms_advisor.quick_tune(
    
22.    advisor_name => 'SQL Access Advisor',
    
23.    task_name => 'MYQUICK3',attr1 => 'select count(*)  from hr.tbig  group by type',template => 'SQLACCESS_OLTP') ;
    
24.   end;
    
25.   
    
26.   
    
27.      begin
    
28.    dbms_advisor.quick_tune(
    
29.    advisor_name => 'SQL Access Advisor',
    
30.    task_name => 'MYQUICK4',
    
31.    attr1 => 'select  *   from hr.tbig  where  text like ''create or replace%'' ',template => 'SQLACCESS_OLTP') ;
    
32.   end;
    
33.   
    
34.   
    
35.   select  * from dba_scheduler_jobs  j  order  by  j.job_name;
    
36.   
    
37.   select  * from dba_outstanding_alerts;
    
38.   
    
39.   select * from dba_alert_history;

复制代码