Iyad, You might find good answers for this question on the oracle-l group. You can subscribe to it and post your question there. Your question is more about database performance and not so much about PL/SQL.
Best Regards, Mike On Tue, Nov 10, 2009 at 2:44 AM, Mouhammed Iyad <iya...@gmail.com> wrote: > > > Hello Masters, > > I'm collecting a very big data from different databases to my database > using DBLinks (around 100 million daily record), > this operation is on daily bases, > > sometime I use create tables (NOLOGGING) & somtimes I use inserts > > my question is? > is there anything I could do to get a better performance, > specially when using the inserts, > > > I need your advices Masters, > > Best Regards, > Iyad > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---