It's urgent (Oracle running slow)

[dineshchand]

I m working on a application importing data into oracle.But after few import into Oracle DB my import process is taking so long time.My oracle is getting slow after running import few times.Can somebody suggest me some performance tips.


Thanks And Regards
Dinesh

[amitpatel66]

I m working on a application importing data into oracle.But after few import into Oracle DB my import process is taking so long time.My oracle is getting slow after running import few times.Can somebody suggest me some performance tips.


Thanks And Regards
Dinesh

What are you trying to exactly import? the whole schema or some tables of a particular schema?

[dineshchand]

What are you trying to exactly import? the whole schema or some tables of a particular schema?

I m importing data in in something around 50 tables in my database.And row insert that are executed in a single import are in lakhs.THis is my import scenario .When i load data in these tables in clean database performance is OK.but for the 2nd time around when i delete all my tables in which i m importing data and then start new import ,my performance dips down .what could be the reason ??