IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: what is statistics in oracle

Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS in Oracle

Mehmet Salih Deveci July 31, 2021 Oracle 0

I will explain Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS in Oracle in this post.

ORA-20000: Insufficient privileges to Analyze an object in Schema during Gather DBMS_STATS

Mehmet Salih Deveci May 13, 2020 ORA-ERRORS 4

Hi, Sometimes You can get ” ORA-20000: Insufficient privileges to Analyze an object in Schema ” error during Gather DBMS_STATS Database, Schema, Table and Dictionary Stats.