On Tue, 12 Dec 2006, Carel-Jan Engel wrote:
On Tue, 2006-12-12 at 22:55 +0100, Veres Lajos wrote:On Tue, 12 Dec 2006, Sam Chakkanat wrote:What is size of your application? How many tables? volume. Depending, Oracle Streams may also be an option.Rman dump is about 3 G. Exp dump~ 1.8 G. We have 70-80 tables. Most of selects uses a single (products) table. If we could spread the queries against that table that would be a big gain too.More important: how much redo are you generating? That might be an
About 5-6 G/day.
indication whether streams is feasible as well. Kirtikumar Deshpande used to be on this list (haven't seen him here for a while though), he knows a lot about streams. At first sight streams could be a useful alternative to you.
I think I should check this ,,streams'' thing.
Or this operations exclude the other?Yes, this is true up to 10gRx. 11xyz will support read-only access during redo apply. So, you probably have to wait for about a year or so. Or get in the Beta program.
Stability is important too. Beta things arent really acceptable. Thanks for your response. -- Veres Lajos vlajos@xxxxxxxxxxxxxx +36 20 438 5909 -- http://www.freelists.org/webpage/oracle-l