Two-Phase commit to overcome replication delay

Hi All,

Environment:
We have 2 databases (both are active) physically located in different geographical area(NJ and NY). Each DB has 2 node OPS (8i) and both database replicates in Master-Master using Oracle Advanced Replication (asynchronous).

For 95% of the applications can tolerate 2 to 5 Min's of replication delay between databases. But one of the application needs near real-time replication. This 5% of the application uses only 2 or 3 Tables. So we like to implement two-phase commit solution to avoid replication delay for these 3 tables. The application will invoke stored procedure and SP will write into local db (as normal) and remote db(using database link). In case if the remote db is not available then the stored procedure is intelligent enough to identify the remote db is down (catch the exception and write into separate queue table) and write into queue.
When the other DB becomes available, the queue will be pushed into the remote db using some mechanism(say DBMS_JOB).

We understand that there would be performance hit (2 writes instead of one write) and network latency.

Is there any other issues in this approach?

Thanks in advance
Sami

--
http://www.freelists.org/webpage/oracle-l