Re: The 5-minute interval in sys.smon_scn_time table

From: Challenge <hanna_shaw_at_yahoo.com>
Date: 1 Dec 2006 07:49:30 -0800
Message-ID: <1164988170.487606.161390@f1g2000cwa.googlegroups.com>

Oracle version is 9.2.0.7 on AIX 5.2

Any idea why the interval is 10 mins instead of 5 mins? Thanks.

DA Morgan wrote:
> Challenge wrote:
> > Hi,
> >
> > According to the document, the smon_scn_time table will be updated
> > automatically by SMON every 5 minutes. Why the interval of the
> > smon_scn_time table is 10 minutes in my database?
> >
> > THREAD TIME_MP TIME_DP SCN_WRP SCN_BAS
> > ---------------- -----------------
> > ------------------------------------- -------------------
> > ----------------
> > ......
> > 1 1164280062 2006-11-23 06:07:43 0
> > 404008
> > 1 1164280662 2006-11-23 06:17:43 0
> > 404209
> > 1 1164281262 2006-11-23 06:27:43 0
> > 404410
> > 1 1164281862 2006-11-23 06:37:43 0
> > 404611
> > 1 1164282462 2006-11-23 06:47:43 0
> > 404812
> > 1 1164283062 2006-11-23 06:57:43 0
> > 405013
> > 1 1164283662 2006-11-23 07:07:43 0
> > 405214
> > 1 1164284262 2006-11-23 07:17:43 0
> > 405415
> > 1 1164284862 2006-11-23 07:27:43 0
> > 405616
> > ......
> >
> > Thanks.
> >

>

> And your version is?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Fri Dec 01 2006 - 09:49:30 CST