tag:blogger.com,1999:blog-15440695.post6695699248811420656..comments2024-02-29T10:39:57.857-05:00Comments on Alex Fatkulin's Blog: Oracle GoldenGate Trail File SizeAlex Fatkulinhttp://www.blogger.com/profile/06361288475877100451noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-15440695.post-13621844917518351912012-03-28T11:42:07.372-04:002012-03-28T11:42:07.372-04:00I need my local trail files to be generated every...I need my local trail files to be generated every minute . can you please hekp me with the settingsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15440695.post-50231879871601971342011-10-25T21:30:17.329-04:002011-10-25T21:30:17.329-04:00I have a question about Flashback Data Archive tab...I have a question about Flashback Data Archive tables in Goldengate replication. Are these tables usually excluded in an extract like "TABLEEXCLUDE .SYS_FBA_*"? <br />What is the approach for replicating and initial load of Flash Back Data Archive tables?<br />Here is my problem. I exported a user schema using Oracle DataPump, imported into destination database. GoldenGate abended saying some tables dont exist on dest. I checked tables and there were about 200 tables that were not exported because they are FBDA tables and DataPump just ignores them. So, I recreated them on source with scripts.<br />So, how is this done? Source and destination have their own FBDA and these tables should not be neither recreated with scripts on dest or replicated? Or they have to be replicated with contents?Vladimir Grigorianhttp://vgrigorian.comnoreply@blogger.comtag:blogger.com,1999:blog-15440695.post-23000500423618860482011-03-07T17:11:02.947-05:002011-03-07T17:11:02.947-05:00FYI, for my test case the compression ratio was 22...FYI, for my test case the compression ratio was 22x (you can get compression stats using SEND TCPSTATS for your extract process).Alex Fatkulinhttps://www.blogger.com/profile/06361288475877100451noreply@blogger.comtag:blogger.com,1999:blog-15440695.post-46628248456986070482011-03-07T17:00:59.106-05:002011-03-07T17:00:59.106-05:00Page 289 in reference guide (http://download.oracl...Page 289 in reference guide (http://download.oracle.com/docs/cd/E18101_01/doc.1111/e17791.pdf) provides a formula for calculating TCPBUFSIZE value but I haven't done any performance tests to see how much real world impact it has. I'd imagine that on networks with big latencies larger buffer should provide more benefits so it depends on the circumstances.<br /><br />GG uses zlib for data compression so you should see some good benefits, especially in the corner cases like above.Alex Fatkulinhttps://www.blogger.com/profile/06361288475877100451noreply@blogger.comtag:blogger.com,1999:blog-15440695.post-27599211446942777372011-03-01T01:39:43.933-05:002011-03-01T01:39:43.933-05:00This is really good, thanks Alex for your research...This is really good, thanks Alex for your research. I do note that Oracle 11g GG has an RMTHOST parameter for compression -- have you tried this and do you have any recommendations for TCPBUFSIZE ?<br /><br />Kind Regards,<br /><br />WillAnonymousnoreply@blogger.com