Help: replication hanging

I am having hanging problem when performing complex snapshot. Because it is complex snapshot, I do complete refresh. I use dbms_snapshot.refresh() to refresh the snapshot, but I queued this in Oracle job queue; I am using dbms_job.submit(). I need to put this in a queue because there are few customized procedures that has to run with this refresh.

The replication (or job) would run few times, then it would hang. When I query the v$session_wait, the event that it is waiting is 'log file sync'. Since I am not using fast refresh, there is no log file associated with snapshots. What log file is this talking about? I was not sure what log file this event was referring to. So, I manually initiated checkpoint on both sides (alter system checkpoint) and flushed shared pool (alter system flush shared_pool), but no cake. It remained hung.

I am using Oracle Workgroup Server 7.3.2 on Windows NT. I don't recall encountering this problem when I was using Oracle Enterprise server version. Can anyone enlighten me?

Thanks in advance. By the way, my email address is daehyunb_at_hotmail.com.

-Daehyun Lee

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 12 1998 - 16:56:36 CDT