No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week12
Registered user hits last month347
Go up

index stale_stats
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...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts 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, 27 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, 26 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
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