Home » RDBMS Server » Performance Tuning » data Pulling is very slow and how we can make it fast
data Pulling is very slow and how we can make it fast [message #65703] Fri, 10 December 2004 02:21 Go to next message
Vishal
Messages: 86
Registered: August 2000
Member
Hi,

We are using 6 Oracle Database Servers. From these databases we are pulling the data into one database. for that we have written some pl/sql, sql, and with the help of Corn we have schedued these scripts. But it is very slow. How i can make it fast. and what is the best way to for pulling the data from oracle databases into One Oracle Database
Re: data Pulling is very slow and how we can make it fast [message #65704 is a reply to message #65703] Fri, 10 December 2004 05:03 Go to previous messageGo to next message
Alan
Messages: 68
Registered: October 1999
Member
hi,
I guess that db_links are set-up okay. have you scheduled the cron jobs when the other databases are less busy. what activity occurs on the 6 databases?

cheers#
Re: data Pulling is very slow and how we can make it fast [message #65712 is a reply to message #65704] Mon, 13 December 2004 21:32 Go to previous message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
Hi

There are many factors that affect the data pulling. Shall these DBs are regularly monitored in terms of Analyze, Rebuilding Indexes etc. Most of the times the DB performance depends on the Query structures. Please check how they have built.

-Prakash
Previous Topic: will query performance be affected when run in Archieve mode database
Next Topic: Applying Hints in the query
Goto Forum:
  


Current Time: Wed Jan 27 10:33:11 CST 2021