Hi Jared and List,
thanks for the reply. I haven't had much info yet as it deals with my next
job. Actually, I only have a list of problem questions from their side. The
problem is that their client application controls all security issues and
among other security restrictions there are time restrictions. E.g. a user
is supposed to do a job only in the desired time intervals.
Unfortunately, the client application use time of local nt workstation where
it's being run. Their SA told me that they had tryed to correct the time
manually. They changed time on the server while the DB was running. (not
sure it's good way) After that they observed strange effect. Oracle became
works slower and slower... And number of active session (v$session.status)
became grow permanently. Eventually they restored the time back. I'm not
sure that the time was the real cause of such side effect but I'm curious if
someone has encountered the same problem.
Thanks for your help,
Ed
>
>
>
>
> Eduard,
>
> You don't say why the time sync is causing such pain, or how you are
> syncing up the time.
>
> If the synchronization is a problem, check into using ntp or
> xntp found
> at www.ntp.org ( network time protocol )
>
> Many shops use this to keep servers in sync. I use it at home on
> linux boxes, works great.
>
> How is this synchronization affecting your Oracle instances?
>
> Jared
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
