| 10g - gather_stats_job [message #196004] |
Tue, 03 October 2006 11:12  |
judym
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  |
JRowbottom
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
