hi,
What is the scenario , we require to issue
EXEC dbms_stats.gather_schema_stats(’SCOTT’, cascade=>TRUE);