Ask ORACLE's real-time synchronous replication technology. Experts come in and take a look, thank you first.

tianjijicncn

Database A writes data in real time. The amount of data is large, and the peak value is 60W / hour.
 
At the same time, the query operation must be performed from A. There are multiple table queries, once every 10 minutes.
 
Because A is a production environment, it is under great pressure. It is worried that too frequent queries to A will affect performance. So consider adding database B. Synchronize some tables in A to B in real time (or within 5 minutes). Then query in B.
 
I know snapshot technology, but shouldn't it be possible to sync?
 
I don't know what technology ORACLE9I_Enterprise version provides such real-time replication or synchronization? It is desirable to minimize the impact on the main database A.
 
I hope you can give advice, thank you in advance.

whbilly

Write a job

Perform the following operation every 5 minutes

copy from oracle / oracle @ myoracle to rman / rman @ catdb append rman.append usin
g select * from oracle.students;

tianjijicncn

5 minutes is probably too long. In addition, I am afraid that this will have too much impact on the performance of the main database A.

marceau543

Write triggers, it won't cost you like a job

onlysnake

Is it possible to achieve this? Realize the synchronization of the two a and b, and reflect the delay time to 0.0 a few seconds, and then query in A and B respectively

tianjijicncn

Writing triggers should not work, because the main database is always updated. Will have too much impact on the main database.

I have consulted friends who are used as DBAs, and they think that advanced replication techniques are not suitable. The main database itself is updated quite frequently, and such real-time synchronization will have a great impact on the performance of the main database.

I use oracle9i and edezheng mentioned materialized views. Do you think it will have a big impact on the performance of the main database?

In contrast, you think that the performance impact of direct query operations on the main database or the performance impact of other technologies such as synchronization, which one is acceptable?

Thanks a lot!

edezheng

In my opinion, if you are not using a third-party specialized product, you should try to use the program provided by oracle itself. I have tested the materialized view, if there are not too many tables to be synchronized, it is still acceptable.

tianjijicncn

Now it seems that materialized views are a better choice. Let me find some relevant information first.

I know too little about ORACLE. By the way, where is the best way to do Beijing ORACLE training? I want to participate. The original factory does not consider it, it is too expensive, the company does not give too high training costs.

skyman14

Materialized views are used for this
But there is a disadvantage. If the connection between a and b libraries is broken, the materialized view needs to be rebuilt