Challenge wrote:
> 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
Hopefully someone knows but I will check and see if I can find
out. My first thought: Documentation error. But it may be something
else.
--
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 - 10:52:51 CST
