| 10g Default Job? [message #156348] |
Tue, 24 January 2006 17:38  |
RussBB
Messages: 2
Registered: January 2006
|
Junior Member |
|
|
I installed 10g on two of our servers (Win2003) and then loaded up a schema from a packaged app. I noticed that this job was in the dba_jobs view:
dbms_stats.gather_system_stats(gathering_mode=>'flush_cache');
I was wondering if anyone else has seen this. The software publish indicated that they didn't create that job and I can't find any reference to it on Metalink.
Thanks!
R Bass
"I'm an Oracle DBA because there isn't a 12 step program for it yet."
|
|
|
|
| Re: 10g Default Job? [message #156544 is a reply to message #156348] |
Wed, 25 January 2006 11:53  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I didn't know it created a job, I thought it used the new scheduler. There are some new features in 10g that cause it to come preloaded with jobs to gather statistics.
Check out dbms_scheduler in the plsql packages book, and chapters 25-28 in the 10g administrators guide.
|
|
|
|
| Re: 10g Default Job? [message #156548 is a reply to message #156544] |
Wed, 25 January 2006 12:18 |
RussBB
Messages: 2
Registered: January 2006
|
Junior Member |
|
|
the really atrange part is that I can not find any reference to an interval valuse of "flush_cache".
Thanks!
R Bass
"I'm an Oracle DBA because there isn't a 12 step program for it yet."
|
|
|
|
| Re: 10g Default Job? [message #535617 is a reply to message #156348] |
Thu, 15 December 2011 05:20 |
David Lozano Lucas
Messages: 2
Registered: September 2009
Location: Madrid
|
Junior Member |
 
|
|
Metalink note: ID 549272.1
The gathering_mode 'flush_cache' is for internal use only, hence not documented, but it dumps some info from gv$segstat and some view of the buffer cache contents into a temporary table.
The dbms_stats.gather_system_stats(gathering_mode=>'flush_cache') calls dbms_stats_internal.flush_cache_stats which flushes cache stats to persistent store and recomputes current values. So this flushes the gathered statistics from the cache.
[Updated on: Thu, 15 December 2011 05:20] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
