Re: Streams source and target on same server
From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Tue, 11 Aug 2009 13:49:25 +0300
Message-ID: <OF66413DAD.0891F2B4-ONC225760F.003B1798-C225760F.003B7D16_at_seb.lt>
So far so good for us.
And yes, sysaux and dedicated logminer tablespaces are heavily used. I've got an impression that when a dedicated log miner tablespace ran out of space for streams queue then sysaux tablespace was chosen and ran out of space too.
May be I am wrong but "SYS.DBMS_LOGMNR_D.SET_TABLESPACE ('streams_tbs')" was executed and there are some miner segments in streams_tbs but eventually sysaux was filled too.
Date: Tue, 11 Aug 2009 13:49:25 +0300
Message-ID: <OF66413DAD.0891F2B4-ONC225760F.003B1798-C225760F.003B7D16_at_seb.lt>
So far so good for us.
And yes, sysaux and dedicated logminer tablespaces are heavily used. I've got an impression that when a dedicated log miner tablespace ran out of space for streams queue then sysaux tablespace was chosen and ran out of space too.
May be I am wrong but "SYS.DBMS_LOGMNR_D.SET_TABLESPACE ('streams_tbs')" was executed and there are some miner segments in streams_tbs but eventually sysaux was filled too.
Please consider the environment before printing this e-mail
"J. Dex"
<cemail_219_at_hotma
il.com> To
Sent by: <oracle-l_at_freelists.org>
oracle-l-bounce_at_f cc
reelists.org
Subject
Streams source and target on same
2009.08.05 19:10 server
Please respond to
cemail_219_at_hotmai
l.com
Has anybody run into any issues using Oracle streams where the source and
target databases are on the same server? The environment will be 10.2.0.4
on AIX.
Windows Live™: Keep your life in sync. Check it out.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 11 2009 - 05:49:25 CDT