Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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