Oracle DBMS_UTILITY.ANALYZE_SCHEMA

exec DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT','COMPUTE');

exec DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT','ESTIMATE', estimate_rows => 1000);

exec DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT','ESTIMATE', estimate_percent => 25);

exec DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT','DELETE');

Oracle DBMS_STATS.GATHER_SCHEMA_STATS

exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname, estimate_percent, block_sample, method_opt, degree, granularity, 
cascade, stattab, statid, options, statown ,no_invalidate, gather_temp, gather_fixed);

Code examples:

exec DBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',DBMS_STATS.AUTO_SAMPLE_SIZE);

exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'SCOTT'
                              ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE);

EXEC DBMS_STATS.gather_schema_stats(ownname => 'SCOTT', estimate_percent => 25);

EXEC DBMS_STATS.gather_table_stats('SCOTT', 'EMPLOYEES');

EXEC DBMS_STATS.gather_index_stats('SCOTT', 'EMPLOYEES_PK');

exec DBMS_STATS.DELETE_SCHEMA_STATS('SCOTT');

Database Proactive Bundle Patch 12.1.0.2

Patch 20141343 - Database Patch for Engineered Systems and DB In-Memory 12.1.0.2.4 (Jan2015)

20075921 DB_BP Both DB Homes and Grid Home
19769479 OCW_PSU Both DB Homes and Grid Home
19769473 ACFS_PSU Only Grid Home
19872484 DBWLM_PSU Only Grid Home

Patch 20698050 - Database Patch for Engineered Systems and DB In-Memory 12.1.0.2.7 (Apr2015)

20594149 DB_BP 12.1.0.2.7 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
20299022 OCW_PSU 12.1.0.2.3 Both DB Homes and Grid Home
20299018 ACFS_PSU 12.1.0.2.3 Only Grid Home
19872484 DBWLM_PSU 12.1.0.2.3 Only Grid Home

Patch 21188742 - Database Patch for Engineered Systems and DB In-Memory 12.1.0.2.10 (Jul2015)

21125181 DB_BP 12.1.0.2.10 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
20831113 OCW_PSU 12.1.0.2.4 Both DB Homes and Grid Home
20299018 ACFS_PSU 12.1.0.2.4 Only Grid Home
19872484 DBWLM_PSU 12.1.0.2.4 Only Grid Home

Patch 21744410 - Database Patch for Engineered Systems and DB In-Memory 12.1.0.2.13 (Oct2015)

21694919 DB_BP 12.1.0.2.13 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
21867380 OCW_PSU 12.1.0.2.5 Both DB Homes and Grid Home
21359761 ACFS_PSU 12.1.0.2.5 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5 Only Grid Home

Patch 22243551 - Database Patch for Engineered Systems and DB In-Memory 12.1.0.2.160119 (Jan2016)

21949015 DB_BP 12.1.0.2.160119 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
22329617 OCW_PSU 12.1.0.2.160119 Both DB Homes and Grid Home
21948341 ACFS_PSU 12.1.0.2.160119 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5 Only Grid Home

Patch 22899531 - Database Proactive Patch 12.1.0.2.160419 (Apr2016)

22806133 DB_BP 12.1.0.2.160419 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
23006522 OCW_PSU 12.1.0.2.160419 Both DB Homes and Grid Home
22502518 ACFS_PSU 12.1.0.2.160419 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5 Only Grid Home

Patch 23273686 - Database Proactive Patch 12.1.0.2.160719 (Jul2016)

23144544 DB_BP 12.1.0.2.160719 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
23520664 OCW_PSU 12.1.0.2.160719 Both DB Homes and Grid Home
23054341 ACFS_PSU 12.1.0.2.160719 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5 Only Grid Home

Patch 24448103 - Database Proactive Patch 12.1.0.2.161018 (Oct2016)

24340679 DB_BP 12.1.0.2.161018 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
24846605 OCW_PSU 12.1.0.2.161018 Both DB Homes and Grid Home
24007012 ACFS_PSU 12.1.0.2.161018Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 24968615 - Database Proactive Bundle Patch 12.1.0.2.170117

24732088 DB_BP 12.1.0.2.170117 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
25101514 OCW_PSU 12.1.0.2.170117 Both DB Homes and Grid Home
24828643 ACFS_PSU 12.1.0.2.170117Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 25433352 - Database Proactive Bundle Patch 12.1.0.2.170418

25397136 DB_BP 12.1.0.2.170418 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
25481150 OCW_PSU 12.1.0.2.170418 Both DB Homes and Grid Home
25363750 ACFS_PSU 12.1.0.2.170418Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 26022196 - Database Proactive Bundle Patch 12.1.0.2.170718

25869760 DB_BP 12.1.0.2.170718 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
25869825 OCW_PSU 12.1.0.2.170718 Both DB Homes and Grid Home
25869830 ACFS_PSU 12.1.0.2.170718Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 26610322 - Database Proactive Bundle Patch 12.1.0.2.170814

26609798 DB_BP 12.1.0.2.170814 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
26609945 OCW_PSU 12.1.0.2.170814 Both DB Homes and Grid Home
25869830 ACFS_PSU 12.1.0.2.170718Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 26635880 - Database Proactive Bundle Patch 12.1.0.2.171017

26717470 DB_BP 12.1.0.2.171017 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
26392192 OCW_PSU 12.1.0.2.171017 Both DB Homes and Grid Home
26392164 ACFS_PSU 12.1.0.2.171017Foot1 Only Grid Home
21436941 DBWLM_PSU 12.1.0.2.5Footref1 Only Grid Home
Footnote1 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Patch 27010930 - Database Proactive Bundle Patch 12.1.0.2.180116

26925263 DB_BP 12.1.0.2.180116 Only DB Home for non-Oracle RAC setup. Both DB Homes and Grid Home for Oracle RAC setup.
26925218 OCW_PSU 12.1.0.2.180116 Both DB Homes and Grid Home
26910974 ACFS_PSU 12.1.0.2.180116Foot2 Only Grid Home
26983807 DBWLM_PSU 12.1.0.2.180116Footref2 Only Grid Home
Footnote2 For ACFS and DBWLM these subpatches are not applicable to the HP-UX Itanium and Linux on IBM System z platforms.

Oracle Grid Infrastructure Patch Set Update 11.2.0.4

Patch 19955028 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.5 (Jan2015) (Includes Database PSU 11.2.0.4.5)

19769489 DB_PSU Both DB Homes and Grid Home
19769476 OCW_PSU Both DB Homes and Grid Home
19769469 ACFS_PSU Only Grid Home

Patch 20485808 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.6 (Apr2015) (Includes Database PSU 11.2.0.4.6)

20299013 DB_PSU 11.2.0.4.6 (INCLUDES CPUAPR2015) Both DB Homes and Grid Home
20420937 OCW_PSU 11.2.0.4.6 Both DB Homes and Grid Home
20299019 ACFS_PSU 11.2.0.4.6 Only Grid Home

Patch 20996923 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.7 (Jul2015) (Includes Database PSU 11.2.0.4.7)

20760982 DB_PSU 11.2.0.4.7 (INCLUDES CPUJUL2015) Both DB Homes and Grid Home
20831122 OCW_PSU 11.2.0.4.7 Both DB Homes and Grid Home
20299019 ACFS_PSU 11.2.0.4.6 Only Grid Home

Patch 21523375 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.8 (Oct2015) (Includes Database PSU 11.2.0.4.8)

21352635 DB_PSU 11.2.0.4.8 (INCLUDES CPUOCT2015) Both DB Homes and Grid Home
21352649 OCW_PSU 11.2.0.4.8 Both DB Homes and Grid Home
21352642 ACFS_PSU 11.2.0.4.8 Only Grid Home

Patch 22191577 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160119 (Jan2016) (Includes Database PSU 11.2.0.4.160119)

21948347 DB_PSU 11.2.0.4.160119 (INCLUDES CPUJAN2016) Both DB Homes and Grid Home
21948348 OCW_PSU 11.2.0.4.160119 Both DB Homes and Grid Home
21948355 ACFS_PSU 11.2.0.4.160119 Only Grid Home

Patch 22646198 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016) (Includes Database PSU 11.2.0.4.160419)

22502456 DB_PSU 11.2.0.4.160419 (INCLUDES CPUAPR2016) Both DB Homes and Grid Home
22502549 OCW_PSU 11.2.0.4.160419 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 23274134 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160719 (Jul2016) (Includes Database PSU 11.2.0.4.160719)

23054359 DB_PSU 11.2.0.4.160719 (INCLUDES CPUJUL2016) Both DB Homes and Grid Home
23054319 OCW_PSU 11.2.0.4.160719 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 24436338 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.161018 (Oct2016) (Includes Database PSU 11.2.0.4.161018)

24006111 DB_PSU 11.2.0.4.161018 (INCLUDES CPUOCT2016) Both DB Homes and Grid Home
23054319 OCW_PSU 11.2.0.4.160719 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 25476126 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.170418 (Apr2017) (Includes Database PSU 11.2.0.4.170418)

24732075 DB_PSU 11.2.0.4.170418 (INCLUDES CPUAPR2017) Both DB Homes and Grid Home
23054319 OCW_PSU 11.2.0.4.160719 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 26030799 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.170718 (Jul2017) (Includes Database PSU 11.2.0.4.170718)

25869727 DB_PSU 11.2.0.4.170718 (INCLUDES CPUJUL2017) Both DB Homes and Grid Home
25920335 OCW_PSU 11.2.0.4.170718 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 26610246 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.170814 (Jul2017) (Includes Database PSU 11.2.0.4.170814)

26609445 DB_PSU 11.2.0.4.170814 (INCLUDES CPUJUL2017) Both DB Homes and Grid Home
26609929 OCW_PSU 11.2.0.4.170814 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 26635745 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.171017 (Includes Database PSU 11.2.0.4.171017)

26392168 DB_PSU 11.2.0.4.171017 (INCLUDES CPUOCT2017) Both DB Homes and Grid Home
26609929 OCW_PSU 11.2.0.4.170814 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home

Patch 27107360 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180116 (Includes Database PSU 11.2.0.4.180116)

26925576 DB_PSU 11.2.0.4.180116 (INCLUDES CPUOCT2017) Both DB Homes and Grid Home
26609929 OCW_PSU 11.2.0.4.170814 Both DB Homes and Grid Home
22502505 ACFS_PSU 11.2.0.4.160419 Only Grid Home