Home » RDBMS Server » Performance Tuning » data pull from a table (oracle 10g unix)
data pull from a table [message #366288] Fri, 12 December 2008 12:08
Messages: 48
Registered: February 2007
Hi All
We have two databases in our Data Warehouse environment.One database's tables are loaded(full table refresh )every day.After the loading is over data is pulled from the tables in that database in ETL tool and stored in the files which are used for downstream process.Here pulling 80 million data from all 5 tables take a long time.Is there any way we can change the yesterdays dataset to incorporate the changes.i think CDC may help.But on the 1st database we cant do any changes.Infact we are not allowed.Is there any method where CDC setup can be done without any changes in source DB.We can do anything in the tgt DB,
Previous Topic: I/O configuaration
Next Topic: poor performance of Exchange partition on composite range-hash tables
Goto Forum:

Current Time: Sun Aug 20 08:47:18 CDT 2017

Total time taken to generate the page: 0.10466 seconds