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
elnbado
Messages: 1
Registered: February 2010
Junior Member
Hi,

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:

1.
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.

2.
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.

Regards,
Barry
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
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I can give you this link...
Hope you like it..
http://www.dba-oracle.com/t_sql_dblink_performance.htm

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


Current Time: Wed Sep 28 21:11:18 CDT 2016

Total time taken to generate the page: 0.12659 seconds