Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: The 5-minute interval in sys.smon_scn_time table
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.orgReceived on Fri Nov 24 2006 - 17:14:31 CST
![]() |
![]() |