Tanel,
Thanks for your response.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 13:29:26 -0800
Hi!
In one migration of about 600GB DB I used 2 dblinks (loading different
partitions in parallel with separate statemen
Hi!
In one migration of about 600GB DB I used 2 dblinks (loading different
partitions in parallel with separate statements), then added 3rd link after
what the bottleneck seemed to be the network. (I saw full network
utilization from perfmon on windows, wasn't too much of a wait interface
user bac
Thanks for your input. Discussion here is to keep maximum use of dblinks for
data load/transfer from one server to another.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 12:49:27 -0800
You can also close the dbl
You can also close the dblink to avoid having many open idle sessions on the
remote database.
alter session close database link dblink;
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL
Tanel,
A quick question? How many open dblinks you have used at one time without
any issues? Default setting in init.ora is 4(if I am not wrong) and I never
used it more than that. If Dennis wants to use more than 4 dblinks at one
time, he should modify this param(open_dblinks) in init.ora, rig