Home » RDBMS Server » Performance Tuning » 10g - gather_stats_job
10g - gather_stats_job [message #196004] Tue, 03 October 2006 11:12 Go to next message
Messages: 2
Registered: September 2006
Junior Member
We have a stored procedure that is running nightly to process approximately 200,000 parent records with 1.2M child records. The procedure performs inserts and updates on only a couple of tables one of which would have a significant number of rows deleted and inserted - probably around 1 million. With the upgrade to 10g, that process has taken a huge performance hit. In my reading, I've come across information that says the gather_stats_job by default runs from 10 pm to 6 am. Would that job use significant resources that would cause the performance issue we are seeing in the stored procedure while it is running at the same time?
Re: 10g - gather_stats_job [message #196107 is a reply to message #196004] Wed, 04 October 2006 03:07 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I wouldn't think so.
Try setting a statspack to run overnight. It's too long a time to do any detailed tuning, but it will let you know what else is running.
Previous Topic: Outline help
Next Topic: Script to Defragment Tables, Index and TableSpace
Goto Forum:

Current Time: Mon Jul 24 16:22:33 CDT 2017

Total time taken to generate the page: 0.10761 seconds