Home » RDBMS Server » Performance Tuning » Copy history from db1 to db 2 (oracle 10, unix)
Copy history from db1 to db 2 [message #444198] Fri, 19 February 2010 05:08 Go to next message
Messages: 1
Registered: February 2010
Junior Member

We have two databases; one production and one history.
We have several jobs that copy data from the production to the history. We use two different ways:

From the production database we copy the data to the history using a db link (push strategy).

This is mostly done when a record is inserted.

From the history database we copy the data from the production using a db link (pull strategy).

This is mostly done using a dbms jobs which runs (eg.)every week.

I think the second option is more effecient since the use of the database links are kept to a minimum. I also believe that in option 2 the history database does most of the work so that the production database is loaded less heavily.

However, I can't find anything to confirm my believes.

Is my believe that option 2 is more efficient true?
Thanks in advance for any answer in this matter.

Re: Copy history from db1 to db 2 [message #444203 is a reply to message #444198] Fri, 19 February 2010 05:42 Go to previous message
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I can give you this link...
Hope you like it..

sriram Smile
Previous Topic: 11g Result Cache
Next Topic: Improve Performance (Merged RL)
Goto Forum:

Current Time: Thu Oct 27 16:33:24 CDT 2016

Total time taken to generate the page: 0.12117 seconds