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

Tag Archives: how to check the status of gather stats 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.

Gather Database Stats , Schema Stats & Dictionary and Fixed Object Statistics via DBMS_STATS in Oracle

Mehmet Salih Deveci May 10, 2019 Oracle 1

I will explain how to Gather Database Stats , Schema Stats & Dictionary and Fixed Object Statistics via DBMS_STATS in Oracle Database in this article. Let’s go to review how …