Deborah Lorraine wrote:
>
> For those of you DBA's with a UNIX/SYSADMIN background, what do you think
> of this problem:
>
> For a yet-to-be-explained reason, the system clock on our sun database
> server suddenly changed back 1 hour and 16 minutes sometime around 4 p.m.
> yesterday afternoon. The initial symptoms were that users could not log in
> to the database (we use kerberos for authenticating most user accounts
> which requires an accurate time), and we had an unusually high load average
> of 77! Once we finally figured out the clock was off and the sysadmin
> reset it, the load average did not change even though users could log in
> again. We then noticed 72 (of ~500) oracle processes in the run state, all
> evenly collecting CPU time, although database performance was good.
>
> Some of these 72 processes were orphans and had no database process. Most
> had been doing simple selects, but not a single one was actually active in
> the database. Not all were kerberos-autenticated sessions. The only thing
> these processes had in common is that their process time stamps were in the
> hour period of that questionable time:
>
> oracle 11971 1 2 16:02:28 ? 18:05 oracleprod (LOCAL=NO)
> oracle 13335 1 2 16:19:40 ? 18:19 oracleprod (LOCAL=NO)
> oracle 9911 1 1 15:47:23 ? 18:18 oracleprod (LOCAL=NO)
> ...
>
> After the clock was reset to the correct time, these processes did not
> clear out but when killed, the load returned to normal.
>
> For the most part, Oracle is oblivious to the system clock setting so what
> could have caused the shadow processes to run amok? What could they be
> doing to generate CPU yet doing nothing in the database? Any ideas?
>
> Thanks,
>
> Debi
>
Out of the top of my mind, and in the middle of the night : Oracle jobs?
RECO trying to fix things?
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Tue Dec 17 2002 - 18:08:51 CST
