dbms_stats.gather_table_stats
Follow up by mail Click here


Subject: dbms_stats.gather_table_stats
Author: javed akhtar, India
Date: Aug 13, 2017, 08:09, 67 days ago
Os info: linux
Oracle info: 11g
Message: Hi Team,

I have reported that one query is running slow after the analysis I got to know that dbms_stats.gather_table_stats was running on server, i said that don't run this such command in day time but 3rd party DBA are not ready to accept that this command will hamper the system performance, could you please help me to find out any doc or ref or link. so i can show them

thanks,
Javed
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dbms_stats.gather_table_stats
Author: Michel Cadot, France
Date: Aug 13, 2017, 09:53, 67 days ago
Message:
Just execute an AWR report on this period and show them what is using resources (of course if you have purchased the options that allow you to do so).

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dbms_stats.gather_table_stats
Author: javed akhtar, India
Date: Aug 13, 2017, 12:17, 67 days ago
Message: Hello Michel,

the same I already did, I am looking any Oracle document or any ref to proof that stats gather makes the system slow.


thanks,
Javed
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dbms_stats.gather_table_stats
Author: Michel Cadot, France
Date: Aug 13, 2017, 12:46, 67 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
AWR report IS the document you need.
You need nothing more.
It is the proof, on your own system, better than anything else.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here