| DBLink Slow Performance [message #57209] |
Wed, 28 May 2003 10:38  |
Mahipal Singh
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
We are running two Oracle 8.i database server on NT 4.0 and another on SUN m/c.
Oracle database on NT Server has 10 tables from which data needs to be pulled and then pushed into Oracle database running on SUN Server. This process is using the DATABASE LINK for data transfer This data transfer process is getting invoked from a browser through JDBC Thin client driver (java iplanet application).
This process is transferring data 5000 records to 1,00000 records daily. Out of these,80% updates and 20% inserts will be there approx. takes a lot of time.
I need help In the given current scenario, Can the DB link currrent performance be improved?
If Yes, then what are the steps that we need to undertake.
|
|
|
|
| Re: DBLink Slow Performance [message #57230 is a reply to message #57209] |
Thu, 29 May 2003 06:58  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
dblinks are to deal with the networking layer.
You have to lookin to network traffics, tcp/ip or any protocol u use etc.
within oracle, you can tune some parameters like
TCP.NODELAY=TRUE in protocol.ora.
There are a few NET 8 parameters that may need a tweak too.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
