Go up

Next thread:	AWR section
Prev thread:	Network Adapter could not establish the connection via scan listener

Message	Score	Author	Date
Hi Team, I have a job that gathers stats with c......		Phuti Tsongayinwe	Sep 07, 2022, 19:58
My apologies guys, I should have done better by do......		Phuti Tsongayinwe	Sep 08, 2022, 11:46

Follow up by mail

Click here

---

Subject:	index stale_stats
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 07, 2022, 19:58, 268 days ago
Os info:	Oracle Solaris 11.4 SPARC.
Oracle info:	Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0
Message:	Hi Team, I have a job that gathers stats with cascade but the column stale stats, on dba_ind_statistics, shows that the index stats are stale, even when the last analyzed date shows today. EXEC DBMS_STATS.gather_database_stats(cascade => TRUE); What might be the issue here? Can the index become stale after we have gathered the stats? Please help... Thanks in advance... Thanks Phuti
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: index stale_stats
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 08, 2022, 11:46, 268 days ago
Score:
Message:	My apologies guys, I should have done better by doing a bit of research. I can see that this has been discussed here before: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=43344 https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=93306 Thanks P
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here