Hi, We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc)
We are using read-only snaphots with multiple groups (one/schema), replication every minute. Simple 'select *' replication. One of the snapshot process seems to stall and all access to one of the tables in the actual group is blocked (any select hangs forever). Killing the snapshot job connection (alter session kill) frees the system/table. There is a trace file with >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<< . We have seen this with different applications (Java) and on different systems. In these cases the replication was on the same database (but that could be because we have not run as many tests in a distributed environment = target production configuration). So no db link involved in this case. There is no normal locks on the tables. Any advice ? Regards HEnrik -- --------------------------------------------------------------------------- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[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).
