I would like to know how to deal with active indexes.
And pando, thanks for your input, I will increase my shared pool size.
And as I mentioned, we are using a poduct which will reads the web server logs ,transalate them as required and import them to our database. this is done by an executable(perl), which I have no control over. I know it is using sql loader because that's how the files are being loaded. I did search for scripts where I could change the loader parameters ,but did'nt find any and finally reached this conclusion.

Thanks a lot for all of your time.