Home » RDBMS Server » Server Administration » 10g Default Job?
10g Default Job? [message #156348] Tue, 24 January 2006 17:38 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: dbam.tablespace_mon(2,TRUE);
Next Topic: see ora-01653 again
Goto Forum:
  


Current Time: Thu Mar 28 12:45:57 CDT 2024