OraFAQ Forum: Performance Tuning » data Pulling is very slow and how we can make it fast

Home » RDBMS Server » Performance Tuning » data Pulling is very slow and how we can make it fast

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data Pulling is very slow and how we can make it fast [message #65703]

Fri, 10 December 2004 02:21

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

Report message to a moderator

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

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#

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 11:39:44 CST 2024