Ken,
How many archive processes do you have?
Are you doing manual archiving?
To archive ,ARC process obtains a write lock for log files
from an enqueue (I don't remember the name of it).I think
this error message related with that lock.
One more thing,
Does LGWR 's job take a great time (this is not because of log blocks size it has to write, as you know there is a 1m limit for it.Maybe disk I/O is too slow)
I hope you can find something if you check for these.
Regards
Emine
On Tue, 19 Dec 2000 09:31:00 -0800 "Fowler, Kenneth R" <kenneth_r_fowler_at_groton.pfizer.com> wrote:
> Has anyone seen this error before...
>
>
> Mon Dec 18 23:48:56 2000
> ARC0: Beginning to archive log# 3 seq# 648
> ARC0: Completed archiving log# 3 seq# 648
> Tue Dec 19 01:21:16 2000
> >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=45
>
>
> We are seeing a lot of segmentation errors from an application that has just
> been upgraded to 8.1.6.2.1. I am wondering if the above error could be
> related? Is the above error something to worry about? and/or could it cause
> application problems?
>
>
> Thanks,
> Ken
> (Kenneth R Fowler)
> (860) 732 0026 (Voice)
> (860) 732 3689 (Fax)
> (860) 715 8346 (Fax to Email)
> (860) 599 8791 (Fax @ Home)
> Clinical Systems DBA Support
> Kenneth_R_Fowler_at_groton.pfizer.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fowler, Kenneth R
> INET: kenneth_r_fowler_at_groton.pfizer.com
>
> 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: 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 Wed Dec 20 2000 - 02:41:49 CST
