Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> The 5-minute interval in sys.smon_scn_time table

The 5-minute interval in sys.smon_scn_time table

From: Challenge <hanna_shaw_at_yahoo.com>
Date: 23 Nov 2006 05:38:44 -0800
Message-ID: <1164289124.546292.130590@j44g2000cwa.googlegroups.com>


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. Received on Thu Nov 23 2006 - 07:38:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US