Tune data coming from legacy system into Oracle DB [message #555223] |
Tue, 22 May 2012 09:25 |
|
vivekgupta15
Messages: 3 Registered: May 2012
|
Junior Member |
|
|
Customer is sending data from legacy system (Source) with the help of web service which in turn calls a package lying on Oracle server (Target). Now this package is simply inserting data passed by legacy system into master staging table in Oracle database. When they started this process in Sept 2011 then 4 lack records were inserted into staging table. In Oct 11 it was 0 records (not sure why), Nov 11 it was 2 lack records, Dec 11 it was 1 lack records, in Jan 12 it was 1 lac records, Feb 12 73k records, Mar 12 0 records, Apr 12 52k records.
As we see that number of records inserted in the table got reduced with time so any ideas what could be the reason? Just wondering what should be the starting point here since web service is calling that package on the fly, how can i enable trace for that package? I cannot replicate this is Dev as this process is only working in PROD.
Any help/pointers will be appreciated!!
|
|
|
|
|
|
|
|
|