Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> The 5-minute interval in sys.smon_scn_time table
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 ---------------- ----------------- ------------------------------------- ------------------- ----------------405616
......
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
Thanks. Received on Thu Nov 23 2006 - 07:38:44 CST
![]() |
![]() |