Stale , DBTune & Tkprof

Stale Stats :

========

SELECT OWNER, TABLE_NAME, NUM_ROWS, stattype_locked,

OBJECT_TYPE, CHAIN_CNT, blocks, EMPTY_BLOCKS, LAST_ANALYZED, STALE_STATS FROM dba_tab_statistics WHERE owner ='MRANA' 
and STALE_STATS='YES';

dbms_stats.gather_table_stats('MY_SCHEMA', 'MY_TABLE');

DB Tuning Advisor :

===============

SET LONG 10000;
SET PAGESIZE 9999
SET LINESIZE 155
set verify off
col recommendations for a150
accept task_name -
prompt 'Task_Name: '
DECLARE
ret_val VARCHAR2(4000);
BEGIN
ret_val := dbms_sqltune.create_tuning_task(task_name=>'&&Task_name', sql_id=>'&sql_id', time_limit=>&time_limit);
dbms_sqltune.execute_tuning_task('&&Task_name');
END;
/
SELECT DBMS_SQLTUNE.report_tuning_task('&&task_name') AS recommendations FROM dual;
undef task_name;

tkprof :

======

tkprof raw_trace_file.trc output_file explain=apps/apps sort=(prsela,exeela,fchela) sys=no