Gather_database_stats_job_proc Takes Long Gather Stats for a Partition Table
(Doc ID 2345401.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Gather_database_stats_job_proc takes long gather stats for a partition table
- Using dbms_stats.gather_table_stats runs fine.
- A lot of tbl$or$idx$part$num are executed when gathering stats globally:
select substrb(dump(val,16,0,32),1,120) ep, cnt from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t)
dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"NBR" val,count(*)
cnt from "TEST"."HIST" t where TBL$OR$IDX$PART$NUM("TEST"."HIST",0,3,0,"ROWID") = :objn and "NBR" is not null group by "PM_CHG_NBR") order by val
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |