1
2
3
4
5
6
7
8
9
begin
DBMS_STATS.GATHER_TABLE_STATS (
              ownname => 'xxx',
          tabname => 'ma_table',
          CASCADE => TRUE,
          estimate_percent => dbms_stats.auto_sample_size,
          method_opt => 'for all indexed columns size auto'
          );
end;

1
2
3
4
5
6
7
8
9
begin
DBMS_STATS.GATHER_TABLE_STATS (
              ownname => 'xxx',
          tabname => 'ma_table',
          CASCADE => TRUE,
          estimate_percent => dbms_stats.auto_sample_size,
          method_opt => 'for all columns size auto'
          );
end;

1
2
3
lsnrctl start

lsnrctl stop

1
2
3
4
5
6
7
8
9
10
11
 
create or replace trigger trg_enable_trace_at_logon
after logon
on database
begin
   execute immediate 'alter session set sql_trace=TRUE';
exception
  when others then
  NULL;
end trg_enable_trace_at_logon;
/