Oracle Statistical information

Manually Brush Oracle Statistics
Select COUNT (1) from Log_trx_detail;
SELECT * FROM user_tab_statistics WHERE table_name = ' log_trx_detail ';
exec dbms_stats.gather_table_stats (' Ardb ', ' acct_balance ', cascade = TRUE);
exec dbms_stats.gather_table_stats (' Ardb ', ' log_trx ', cascade = TRUE);
EXEC dbms_stats.gather_table_stats (ownname=> ' Ardb ',tabname=> ' log_trx_detail ',granularity=> ' all ', Estimate_percent=>5,degree=>4,cascade=>true);
EXEC dbms_stats.gather_table_stats (ownname=> ' Ardb ',tabname=> ' acct_balance ',granularity=> ' all ', ESTIMATE _percent=>5,degree=>4,cascade=>true);
Execute dbms_stats.gather_table_stats (ownname = ' Ardb ', tabname = ' Trans_detail ', estimate_percent = DBMS_ STATS. Auto_sample_size, method_opt = ' for all COLUMNS SIZE 1 ', No_invalidate=>false, degree=>8, cascade = TRUE);
exec dbms_stats.gather_table_stats (' Ardb ', ' Log_trx ', ' P201301 ', granularity = ' PARTITION ', degree=>4, cascade = > True);
exec dbms_stats.gather_table_stats (' Ardb ', ' log_trx_detail ', ' P201301 ', granularity = ' PARTITION ', degree=>4, Cascade = TRUE);
alter system flush Shared_pool;

Turn off statistics updates
Begin
Dbms_auto_task_admin. DISABLE (client_name = ' Auto Optimizer stats collection ',
Operation = NULL,
Window_name = NULL);
End
/

View Dba_autotask_window_clients to see how they are performing seven days a week
SELECT * from Dba_autotask_window_clients;

Oracle Statistical information