GeekArticles 
FAQ Oracle FAQ
FAQ Oracle FAQHow to change repeat_interval for GATHER_STATS_JOB in 10GR2
Hi Tom,
How to change the auto stats collection job (GATHER_STATS_JOB) in 10GR2? It is created and scheduled by default to run at 10PM, we like to schedule it to run at different time, say 8PM on Friday and Saturday.
I tried this
BEGIN
DB...
Sponsored Links
Read Next: Partition name in Result set?
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
Sponsored Links
About |
Privacy Policy |
Submit Resource |
Submit Article |
Contact |
Site Map
Copyright © 2009 GeekArticles.com. All Rights Reserved.
