Specific Table/Schema Analyze in Oracle

--Specific Schema Analyze in Oracle---

EXEC DBMS_STATS.gather_schema_stats('SCOTT', estimate_percent => 15, cascade => TRUE);

--Specific Table Analyze in Oracle---
 
EXEC DBMS_STATS.gather_table_stats('STLBAS', 'STTRNDTL', estimate_percent => 25, cascade => TRUE);

EXEC DBMS_STATS.gather_table_stats('STLBAS', 'STFETRAN', estimate_percent => 25, cascade => TRUE);

EXEC DBMS_STATS.gather_schema_stats('STLBAS', estimate_percent => 15, cascade => TRUE);