Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: replication hanging
Someone can correct me if I'm wrong, but I didn't think that Workgroup
server supported replication.
Dan
daehyunb_at_hotmail.com writes:
>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 Mon Jun 15 1998 - 10:49:07 CDT