Re: Log switch Not taking place - db hangs

Zhu

Metalink was checked. OS logs too were checked. No issues observed. Session wait did not show anything. Suggestion 5 is fine. But one cannot expect the DBA to sit in front of the monitor 24x7 to type these commands. My question is what is the cause of this so that it can be be addressed. Earlier we had a situation where in for no apparent reason DBMS_JOB did not fire. Later we found it was a bug in 9.2.0.1 and we were asked to patch to 9.2.0.6 which we complied and it is working fine now. Since i could not come up with any positive results in Metalink i posted here.

Any useful inputs would be appreciated.

Thanks

GovindanK

On Fri, 22 Apr 2005 20:44:54 +0800, "zhu chao" <zhuchao_at_gmail.com> said:
> If I were you, I will check:
> 1. Metalink. See any known issues. Like necessary os patch/oracle bug.
> 2. Tusc to see what the system call lgwr/arch is doing that time.
> 3. CHeck os log to see if anything abnormal.
> 4. see v$session_wait.
> 5. try archive log stop; archive log start to try re-post the archive
> process.
>

--
http://www.freelists.org/webpage/oracle-l