On Nov 10, 4:44 am, Mouhammed Iyad <[email protected]> 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
Can you prove the performance is bad? Has the time to process these
inserts increased over time? You're using database links and network
connectivity could be a problem and remember that you're passing a
large number of records across a network connection which can be slow.
You need to discover WHERE your time is being spent on these inserts,
then address the cause. Not knowing what your system statistics
report it's difficult to give any specific advice.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
